Programs loading slowly

[Leroy]

Hi Ryan,

We are on V5R2, Xe Update 2, SP 21. We have had this problem for quite a while but are only now getting serious about solving it.
We have been through most things, SQL packages, checked indexes, Client Access Express, etc.
GetUserProfileCache is called hundreds of times during a user session but the poor response doesn't happen every time it's called but it happens enough to really piss people off.

Regards

 

[rhunt01]

When we experienced this exact problem - it was based on both the installation of a new AS400 and an OS400 upgrade from V4R5 to V5R2. Earlier in this thread I have detailed a list of items that we had to optimize in order to get everything running properly and elliminate that program delay.

If you want to start with the items that had the largest impact for me, the are:
1) Make sure you are using the CAE SP of SI08994 or later. ODBC latency was finally fixed in this SP.

2) Adjust prestart and maximum use attributes on QZDASOINIT jobs. I have my system set to prestart 650 QZDASOINIT jobs (used for ODBC's) and end and restart each job after 200 uses. (this setting depends on how many users you have)

3) Make sure you are at least up to date with OneWorld required PTF's. Although, I found benefit in keeping with the latest cumulative, hiper, and DB2.

I also found that I needed lots of temporary storage PTF's - there were a lot for V5R2
(http://www-1.ibm.com/support/docview.wss?rs=110&uid=nas188c105155938650086256a570053a140&loc=en_US)

I still would look at all the other items that I mentioned in the previous post. They ALL played a part in getting rid of that delay.

Good Luck.

 

[mkellow]

Hi Ryan,

Thanks for the information. I will look into this. I just have one question . The PTF that you mention for CAE ?? I did a search on the iseries website and it came back and told me that the ptf was for v5r1. Is this the correct PTF number ?

Thanks
Matthew

 

[rhunt01]

Sorry, I typo'd. This is from the IBM site:

V5R2M0 Service Packs - iSeries Access for Windows:

PTF Number Available Installed Files Date
Base code August 2002 05/07/2002
SI04684 August 2002 08/01/2002
SI05853 September 2002 08/02/2002
SI06631 December 2002 08/03/2002
SI07675 February 2003 08/04/2002
SI08894 June 2003 08/05/2002
SI09809 October 2003 08/06/2002
SI10914 February 2004 08/07/2002
SI14294 June 2004 08/08/2002
SI16136 November 2004 08/09/2002

So, I meant SI08894. But, That is outdated at this point. I would try to surpass it if I were you. But, as mentioned, an ODBC latency issue was resolved in SI08894 so I would make sure to use atleast that SP, if not newer.

Good Luck

 

[mkellow]

thanks for the information Ryan. I will be looking into all of this and i will let you know how i go .

Thanks
Matthew

 

[qaqqini]

Did you get a resolution to this issue? if so and you still remember please let me know.

thanks!