Powerhouse + Oracle-9i + AIX - Response issues

[Goparaju, Vidyasagar]

Hi David,
 
We have started with one of our AS400 clients and so far everything is Ok except these performance issues. All these issues pop up when testing on complete database loaded with production data.
 
Sagar
 
-----Original Message-----
From: David Morrison - Corporate [mailto:dmorrison at mcbrideelectric.com]
Sent: Wednesday, August 31, 2005 5:29 PM
To: Goparaju, Vidyasagar; powerh-l at lists.sowder.com
Subject: RE: Powerhouse + Oracle-9i + AIX - Response issues
 
Sagar,
 
We're one of the remaining AS/400 (iSeries) PowerHouse shops, so I'm curious about your conversion.  Are you going to require all your customers to leave the native AS/400 environment by a particular time? Say, when Cognos ends PH 607 support in, I think, February of 2007?  Is the AIX/Oracle environment on the iSeries hardware?
 
Thanks.
 
David Morrison
McBride Electric
San Diego, CA
-----Original Message-----
From: powerh-l-bounces+dmorrison=mcbrideelectric.com at lists.sowder.com [mailto:powerh-l-bounces+dmorrison=mcbrideelectric.com at lists.sowder.com]On Behalf Of Goparaju, Vidyasagar
Sent: Wednesday, August 31, 2005 2:11 PM
To: powerh-l at lists.sowder.com
Subject: Powerhouse + Oracle-9i + AIX - Response issues
We are in the process of migration from AS400 Powerhouse to Powerhouse on AIX under Oracle environment.
 
We have successfully converted our application and almost ready for the production move. But we have been experiencing response issues. Powerhouse under Oracle environment is relatively very slow.
 
Any of you have gone thru similar issues when migrated to Oracle environment? What steps have you taken to improve the response? We have a huge Cobol routine that runs off of our quick screens using DO EXTERNAL. That is also taking longer time and a big concern to our clients.
 
 Please let me know if you have any suggestions or information.
 
Thanks very much
Sagar Goparaju
TradePoint Systems
 
STATEMENT OF CONFIDENTIALITY:
The information contained in this electronic message is intended for the exclusive use of the addressee(s) and may contain confidential information.  If you are not the intended recipient of this email, be advised you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited.  Please notify TradePoint Systems LLC immediately at (603) 889-3200 and destroy all copies of this message and any attachments.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20050831/bd480456/attachment.htm