Powerhouse + Oracle-9i + AIX - Response issues

[Joe Boyle]

You don't say which version of PH you have so it is possible that you have
PH library routines which are out of step with the Oracle version.

Does the Cobol routine run any better when called from outside PH, if not,
what are you comparing performance with i.e. why do you think performance is
poor ?

Regards, Joe. 

  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Goparaju, Vidyasagar
Sent: 31 August 2005 22:11
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/9559f4a0/attachment.html