IBM AS/400 and iSeries: PowerHouse Performance Question

[Whittall, Conrad]

Once PowerHouse has opened a data file it keeps it open and reuses the
connection for other screens that access the same file...so long as the
original open mode is compatible with what other screen programs want to do.

For example, if screen A opens file X for read/write access  (maybe a
PRIMARY, DETAIL, SECONDARY or DESIGNER file) and then later screen B needs
file X as a read-only REFERENCE file, PowerHouse will not open the file
again but simply reuse the existing connection. If the user accesses screen
B first, then file X will be opened for read-only access. If they then
access screen A then file X will have to be opened a second time...this time
for read/write access.

So, once a data file is open it is unlikely that PowerHouse will need to
open it again (unless the designer has explicitly asked for a program to
close it using the CLOSE option of the FILE statement. However, a program
file is opened each time it is called (although your operating system might
cache these files depending on how often they are being accessed, and so a
PowerHouse access might not necessarily mean a disk access).

Given all of this it is probably slightly more efficient to have the program
library ahead of the data library on a user's library list...since they will
be opening program files much more often than data files.

Best regards,
Conrad

Conrad Whittall
e-Learning Architect, Global Education Services
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

-----Original Message-----
From: David Morrison - Corporate [mailto:dmorrison@mcbrideelectric.com]
Sent: 12 December 2002 12:32
To: powerh-l@lists.swau.edu
Subject: IBM AS/400 and iSeries: PowerHouse Performance Question


We currently keep our Production programs and data in the same library.

We're thinking of splitting them into two separate libraries.  Does anyone
know if this will affect interactive and/or batch performance of PowerHouse
programs?  And, in which direction?

If we make this change, would it be better to put the program library ahead
of the data library, in the users' library list?

Thanks.

David Morrison
McBride Electric
= = = = = = = = = = = = = = = = = = = = = = = = = = = =



This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.