R: [DB2-L] [z/OS]High Getpages & Buffer Updates for Insert on one member in Data S

Adrian Collett

R: [DB2-L] [z/OS]High Getpages & Buffer Updates for Insert on one member in Data S
Hmmm, thanks for that Mauro,
The symptoms are identical, even though the object definitions are
different...our problem is also exacerbated by the fact that we can't
reproduce it in our test environment!!!!

Btw, have you already applied UK38799 or UK39481 ???

Thanks again,
Ciao,
Adrian

Moschelli Mauro ha scritto:
> Hi Adrian,
> we recently had a similar issue on a LOAD SHRLEVEL CHANGE utility job, which under the covers does a massive insert. For less than 1 million inserts we saw up to 70 million getpage and the same number of Global locks.
> In our case locksize was page, segmented tablespace with compress yes and GBP Dependent. The elapsed time went from a few minutes to some hours. If it is not GBP Dep the time is again few minutes. We solved by ALTERing the tablespace to CLOSE YES, which helps it not being GBP Dep at the time of the execution and, when possible, STOP/START of the tablespace before execution. However we are already working with IBM folks and opening a PMR.
>
> HTH
>
> Ciao
>
> Mauro Moschelli
> Intesa Sanpaolo S.p.A.
>
> IBM Certified Database Administrator - DB2 UDB V8.1 for z/OS
>
>


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html