IBM AS/400 and iSeries: PowerHouse Performance Question

[David Morrison - Corporate]

Richard,

Thanks for the input.  I will send you my address in an individual e-mail.

Regarding clearing files:  I'd suggest, if possible, making a copy of the file (CRTDUPOBJ or CPYF) in the user's QTEMP, and using that file in PH programs; then you don't have to worry about clearing it out at the end of the user's session (delete it mid-session, if need be).

David Morrison
McBride Electric


-----Original Message-----
From: Latimer, Richard [mailto:richard.latimer@airways.co.nz]
Sent: Sunday, December 15, 2002 12:56 PM
To: David Morrison - Corporate; powerh-l@lists.swau.edu
Subject: RE: IBM AS/400 and iSeries: PowerHouse Performance Question


David,

this is a screenshot of my production library list:

     QSYS        SYS       System Library                    
     QSYS2       SYS       System Library for CPI's          
     QHLPSYS     SYS                                         
     QUSRSYS     SYS                                         
     LATIMERPRO  CUR                                         
     PH607E      USR       PowerHouse 6.07 Full Development  
     ATDBPROD    USR       ATDB Production Program Library   
     MAILBOX     USR       ATDB Production DDM Interface     
     PRODDATA    USR       ATDB PRODUCTION DATA LIBRARY      
     QTEMP       USR                                         
     QGPL        USR       General Purpose Library         


I am not sure why we established the DDM libray (we "share" some files such
as the corporate address book with our JDE ERP on another '400) so far up
the order but it only has 5 objects.

Out training / testing environment is set up similarly except it use
different Data and DDM libraries and also has a library to hold the programs
under test above the ATDBPROD program library.

Our development area has everything tossed in together and while I have no
idea whether there is a performance difference it sure makes organisation /
maintenance a pain. Some our upgrades and enhancements have necessitated
recompiling of many program objects - we find it is easier to clean out the
production program library and recompile the entire application in one big
process rather than run into versioning problems from doing it piecemeal.

Conrad's answer also clears up a niggle we have had for some time - our
application is predominantly batch processing (using QTP) but there are a
number of edit / view screens. Some of the processes clear out the files
they are using after processing is complete by using the CL command CLRPFM
because it is substantially faster than individual deletions and avoids
reorganizing the file to compact the deleted records. This has occasionally
failed, leading to all kinds of duplcate key drama's when the data is
reprocessed! We found that there were a number of file locks floating around
(OS400 is a bit touchy about eeven read locks) and it was safest to log out
of the application totally and log back in to start the jobs. It seems some
'closes' on some of the screens may be a good idea !

regards

Richard

BTW I have some hard copy Cognos info on optimising AS400 apps, it's
probably too big to fax but if anyone is interested I am happy to slowpost
copies if you reply off list with addresses ...

 


**********************************************************************
This electronic message together with any attachments is confidential. If
you receive it in error: (i) you must not use, disclose, copy or retain
it; (ii) please contact the sender immediately by reply email and then
delete the emails. Views expressed in this email may not be those of the
Airways Corporation of New Zealand Limited
**********************************************************************



_________________________________________________
Scanned for viruses on 15 Dec 2002 12:57:41
No viruses found.
Virus scanning by http://erado.com