load partion replace with NPI

Alison Pelletier

load partion replace with NPI
Hello.

We have 2 subsystem data sharing, both members are DB2 9 CM for z/OS. Soon after our upgrade to DB2 9 two of our utility load replace partition jobs started using significantly more CPU time on one of the lpars. One utility job costs much more on one lpar where the other utility job costs more on the other. The bulk of the CPU time is noticed in the SORTBLD phase and I believe it is the large NPI that is where most of that CPU is spent. In the historical Omegamon data the CPU is recorded in the CPU_PARAL columns and there are higher IRLM latch suspends compared to times when the load is lesser CPU on the other lpar. The utility job went back to a more normal cost for a brief time starting on 11/7. My theory is it's because everything was recycled, including the coupling facility, etc. for time change. It has since increased again to what it had been before 11/7. The volume of rows loaded is not very different from one day to another, in fact one of the jobs loads with dummy input. The # of parallel tasks are no different.

We have a PMR open, but I wonder if any of you in DB2-L land has experienced this. Is there an environmental factor that contributes to the increase in CPU time?

Thanks in advance for your help.

Alison Pelletier
Discover Financial Services

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv