R: [DB2-L] R: [DB2-L] [z/OS]High Getpages & Buffer Updates for Insert on one membe

Mauro Moschelli

R: [DB2-L] R: [DB2-L] [z/OS]High Getpages & Buffer Updates for Insert on one membe
No, not yet. They really match the problem description.

Bye


Mauro

-----Messaggio originale-----
Da: DB2 Data Base Discussion List [mailto:[login to unmask email] Per conto di Adrian Collett
Inviato: mercoledì 21 gennaio 2009 16.25
A: [login to unmask email]
Oggetto: Re: [DB2-L] R: [DB2-L] [z/OS]High Getpages & Buffer Updates for Insert on one member in Data Sharing

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

Prima di stampare, pensa all'ambiente ** Think about the environment before printing

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * 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