BP0 Getpages -- Why?

[login to unmask email]

BP0 Getpages -- Why?
Given that BP0 is dedicated to the DB2 catalog and directory, why would a
CICS transaction require BP0 getpages every time it executes?

Kevin Mulcahy
CheckFree Corporation



Roger Miller

Re: BP0 Getpages -- Why?
(in response to kmulcahy@CHECKFREE.COM)
Is anything bound VALIDATE(RUN)? Authorization checking? Any dynamic SQL?

Roger Miller

[login to unmask email]@RYCI.COM> on 01/03/2000 06:17:08 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: BP0 Getpages -- Why?



Given that BP0 is dedicated to the DB2 catalog and directory, why would a
CICS transaction require BP0 getpages every time it executes?

Kevin Mulcahy
CheckFree Corporation








HARBRY ARIZA

Re: BP0 Getpages -- Why?
(in response to Roger Miller)
Any tablespace or indexspace can use BP0 just if you specified that. If
you want change it , you have to check what not catalog tablespace is using
the BP0 BUFFERPOOL. You can create a query to search from
sysibm.systablespace and find out what tablespaces are using the BP0 bpool.

I hope it helps.

>From: [login to unmask email]
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: BP0 Getpages -- Why?
>Date: Mon, 3 Jan 2000 09:17:08 -0500
>
>Given that BP0 is dedicated to the DB2 catalog and directory, why would a
>CICS transaction require BP0 getpages every time it executes?
>
>Kevin Mulcahy
>CheckFree Corporation
>
>
>
>
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



ODIMIR BARBOSA

Re: BP0 Getpages -- Why?
(in response to HARBRY ARIZA)
If you have dynamic sql / validate run ...
Your access in BP0 :
DSNDB06.SYSDBASE, DSNDB06.SYSSTATS, DSNDB06.SYSUSER,
DSNDB06.SYSVIEWS, DSNDB06.DSNADH01,
DSNDB06.DSNATX02, DSNDB06.DSNAUH01, DSNDB06.DSNDSX01, ....

Odimir


> -----Original Message-----
> From: Roger Miller [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 1:28 PM
> To: [login to unmask email]
> Subject: Re: BP0 Getpages -- Why?
>
> Is anything bound VALIDATE(RUN)? Authorization checking? Any dynamic
> SQL?
>
> Roger Miller
>
> [login to unmask email]@RYCI.COM> on 01/03/2000 06:17:08 AM
>
> Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
> Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>
>
> To: [login to unmask email]
> cc:
> Subject: BP0 Getpages -- Why?
>
>
>
> Given that BP0 is dedicated to the DB2 catalog and directory, why would a
> CICS transaction require BP0 getpages every time it executes?
>
> Kevin Mulcahy
> CheckFree Corporation
>
>
>
>
>
>
>
>
>
>



[login to unmask email]

Re: BP0 Getpages -- Why?
(in response to ODIMIR BARBOSA)
Thanks for the replies! We are getting BP0 getpage activity on CICS
transactions, and the reason is not apparent to me. There is no dynamic SQL
and no objects in BP0 other than the DB2 catalog and directory. The
number of BP0 getpages is constant and significant. I suspect
authorization and am researching this, but can't turn on a trace in
production right now. Does anyone have any more ideas? Here are some BP0
I/O statistics from B&B:

DATA TABLE I/O I/O
BASE SPACE P COUNT %
-------- -------- - -------- -----
DSNDB06 SYSDBASE 1328108 57.4
DSNDB01 DSNLLX01 519580 22.5
DSNDB01 SPT01 108323 4.7
DSNDB01 DSNLLX02 51296 2.2
DSNDB01 SYSLGRNX 43029 1.9

Kevin Mulcahy
CheckFree Corporation



Michael Murley

Re: BP0 Getpages -- Why?
(in response to kmulcahy@CHECKFREE.COM)
If there are any update (UPDATE, INSERT, or DELETE) transactions, getpages
for SYSLGRNX and its indexes are expected, since an update to a table space
not previously open for update causes DB2 to insert a new SYSLGNRX row.

The getpages for SPT01 show up when DB2 loads a package into the EDMPOOL, I
think. I'm surprised you don't see any activity for DSNDB01.DBD01 for DBD
access (maybe it's just not included in the reporting interval below?).

The I/O to SYSDBASE is a bit more mysterious to me. Are any plans bound with
VALIDATE(RUN)?

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 7:09 AM
To: [login to unmask email]
Subject: Re: BP0 Getpages -- Why?


Thanks for the replies! We are getting BP0 getpage activity on CICS
transactions, and the reason is not apparent to me. There is no dynamic SQL
and no objects in BP0 other than the DB2 catalog and directory. The
number of BP0 getpages is constant and significant. I suspect
authorization and am researching this, but can't turn on a trace in
production right now. Does anyone have any more ideas? Here are some BP0
I/O statistics from B&B:

DATA TABLE I/O I/O
BASE SPACE P COUNT %
-------- -------- - -------- -----
DSNDB06 SYSDBASE 1328108 57.4
DSNDB01 DSNLLX01 519580 22.5
DSNDB01 SPT01 108323 4.7
DSNDB01 DSNLLX02 51296 2.2
DSNDB01 SYSLGRNX 43029 1.9

Kevin Mulcahy
CheckFree Corporation








Adrian Savory

Re: BP0 Getpages -- Why?
(in response to Michael Murley)
Not using a shadow catalog for 3rd party utilities by any chance?

Adrian Savory
ACSIS Ltd




[login to unmask email] on 04/01/2000 13:08:33

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Adrian Savory/ZI/England/Zurich)

Subject: Re: BP0 Getpages -- Why?



Thanks for the replies! We are getting BP0 getpage activity on CICS
transactions, and the reason is not apparent to me. There is no dynamic SQL
and no objects in BP0 other than the DB2 catalog and directory. The
number of BP0 getpages is constant and significant. I suspect
authorization and am researching this, but can't turn on a trace in
production right now. Does anyone have any more ideas? Here are some BP0
I/O statistics from B&B:

DATA TABLE I/O I/O
BASE SPACE P COUNT %
-------- -------- - -------- -----
DSNDB06 SYSDBASE 1328108 57.4
DSNDB01 DSNLLX01 519580 22.5
DSNDB01 SPT01 108323 4.7
DSNDB01 DSNLLX02 51296 2.2
DSNDB01 SYSLGRNX 43029 1.9

Kevin Mulcahy
CheckFree Corporation








Craig Mullins

Re: BP0 Getpages -- Why?
(in response to Adrian Savory)
Kevin:

First of all, verify that the tablespaces and indexes of all accessed
objects are actually in a bufferpool other than BP0. You might have missed
one or perhaps there is some access to an object that you were not aware of.

Secondly, if the transaction uses any dynamic SQL, access to the catalog (in
BP0) will occur when the SQL is prepared during run time.

Also, if no dynamic SQL and the objects are actually in another bufferpool,
how was the plan bound? If it used VALIDATE(RUN) then DB2 will access the
catalog (in BP0) to verify the existence of objects at run time.

Good luck,
Craig S. Mullins
Director, DB2 Technology Planning
BMC Software
http://www.bmc.com
[login to unmask email]
http://www.craigsmullins.com
[login to unmask email]

>ORIGINAL POST============<
>Date: Mon, 3 Jan 2000 09:17:08 -0500
>From: [login to unmask email]
>Subject: BP0 Getpages -- Why?
>
>Given that BP0 is dedicated to the DB2 catalog and directory, why would a
>CICS transaction require BP0 getpages every time it executes?
>
>Kevin Mulcahy
>CheckFree Corporation
>



Piontkowski Michael ML

Re: BP0 Getpages -- Why?
(in response to Craig Mullins)
Kevin :

Another possibility -
I would think the REOPT(VARS) bind option causes
getpages to the catalog/directory.


Mike Piontkowski
Voice/Fax: 302.886.4612
mailto:[login to unmask email]

> ----------
> From: Mullins, Craig[SMTP:[login to unmask email]
> Sent: Tuesday, January 04, 2000 12:33 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] BP0 Getpages -- Why?
>
> Kevin:
>
> First of all, verify that the tablespaces and indexes of all accessed
> objects are actually in a bufferpool other than BP0. You might have missed
> one or perhaps there is some access to an object that you were not aware
> of.
>
> Secondly, if the transaction uses any dynamic SQL, access to the catalog
> (in
> BP0) will occur when the SQL is prepared during run time.
>
> Also, if no dynamic SQL and the objects are actually in another
> bufferpool,
> how was the plan bound? If it used VALIDATE(RUN) then DB2 will access the
> catalog (in BP0) to verify the existence of objects at run time.
>
> Good luck,
> Craig S. Mullins
> Director, DB2 Technology Planning
> BMC Software
> http://www.bmc.com
> [login to unmask email]
> http://www.craigsmullins.com
> [login to unmask email]
>
> >ORIGINAL
> POST============<
> >Date: Mon, 3 Jan 2000 09:17:08 -0500
> >From: [login to unmask email]
> >Subject: BP0 Getpages -- Why?
> >
> >Given that BP0 is dedicated to the DB2 catalog and directory, why would a
> >CICS transaction require BP0 getpages every time it executes?
> >
> >Kevin Mulcahy
> >CheckFree Corporation
> >
>
>
>
>
>
>