BP32K0 question

JH

BP32K0 question
What is BP32K0?
I could not find BP32K0 in any IBM documentation but
seeing some DBA websites mentioning BP32K0.
Am I missing something ?




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

John McKown

Re: BP32K0 question
(in response to JH)
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf Of JJ
> Sent: Wednesday, January 03, 2007 11:56 AM
> To: [login to unmask email]
> Subject: [DB2-L] BP32K0 question
>
>
> What is BP32K0?
> I could not find BP32K0 in any IBM documentation but
> seeing some DBA websites mentioning BP32K0.
> Am I missing something ?

32K buffer pool? I don't recognise the trailing zero.

--
John McKown
Senior Systems Programmer
HealthMarkets
Keeping the Promise of Affordable Coverage
Administrative Services Group
Information Technology

The information contained in this e-mail message may be privileged
and/or confidential. It is for intended addressee(s) only. If you are
not the intended recipient, you are hereby notified that any disclosure,
reproduction, distribution or other use of this communication is
strictly prohibited and could, in certain circumstances, be a criminal
offense. If you have received this e-mail in error, please notify the
sender by reply and delete this message without copying or disclosing
it.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

John McKown

Re: BP32K0 question
(in response to John McKown)
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf Of McKown, John
> Sent: Wednesday, January 03, 2007 11:58 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] BP32K0 question
>
>
> > -----Original Message-----
> > From: DB2 Data Base Discussion List
> > [mailto:[login to unmask email] On Behalf Of JJ
> > Sent: Wednesday, January 03, 2007 11:56 AM
> > To: [login to unmask email]
> > Subject: [DB2-L] BP32K0 question
> >
> >
> > What is BP32K0?
> > I could not find BP32K0 in any IBM documentation but
> > seeing some DBA websites mentioning BP32K0.
> > Am I missing something ?
>
> 32K buffer pool? I don't recognise the trailing zero.
>
> --
> John McKown

Ah, here it is:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQJ13/2.4

<quote>
bpname
A name that identifies a buffer pool. The following list shows the
names of the different buffer pool sizes.

4KB
BP0, BP1, BP2, ..., BP49
8KB
BP8K0, BP8K1, BP8K2, ..., BP8K9
16KB
BP16K0, BP16K1, BP16K2, ..., BP16K9
32KB
BP32K, BP32K1, BP32K2, ..., BP32K9
</quote>

--
John McKown
Senior Systems Programmer
HealthMarkets
Keeping the Promise of Affordable Coverage
Administrative Services Group
Information Technology

The information contained in this e-mail message may be privileged
and/or confidential. It is for intended addressee(s) only. If you are
not the intended recipient, you are hereby notified that any disclosure,
reproduction, distribution or other use of this communication is
strictly prohibited and could, in certain circumstances, be a criminal
offense. If you have received this e-mail in error, please notify the
sender by reply and delete this message without copying or disclosing
it.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steve Whittaker

Re: BP32K0 question
(in response to John McKown)
Our DB2 for z/OS starts out with BP32K and then goes up BP32K1, BPK32K2
etc. No mention of a 'BP32K0' that I could find...They did put the '0'
in there with BP8K0 and BP16K0 but not sure why they left out the
32K...Just assumed they were playin around as usual.. :-)
Its just another 32k buffer pool...
Just something I've noticed...

--Steve....

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of McKown, John
Sent: Wednesday, January 03, 2007 12:58 PM
To: [login to unmask email]
Subject: Re: [DB2-L] BP32K0 question


> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf Of JJ
> Sent: Wednesday, January 03, 2007 11:56 AM
> To: [login to unmask email]
> Subject: [DB2-L] BP32K0 question
>
>
> What is BP32K0?
> I could not find BP32K0 in any IBM documentation but
> seeing some DBA websites mentioning BP32K0.
> Am I missing something ?

32K buffer pool? I don't recognise the trailing zero.

--
John McKown
Senior Systems Programmer
HealthMarkets
Keeping the Promise of Affordable Coverage
Administrative Services Group
Information Technology

The information contained in this e-mail message may be privileged
and/or confidential. It is for intended addressee(s) only. If you are
not the intended recipient, you are hereby notified that any disclosure,
reproduction, distribution or other use of this communication is
strictly prohibited and could, in certain circumstances, be a criminal
offense. If you have received this e-mail in error, please notify the
sender by reply and delete this message without copying or disclosing
it.

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steen Rasmussen

Re: BP32K0 question
(in response to Steve Whittaker)
I just had a look in my DB2 SQL Reference Guide from 1985 (DB2 Release
1), and at that time you only had BP0, BP1, BP2 and BP32K.

So +20 years ago , no one probably thought of the need for more than 3
4K bufferpools and 1 32K bufferpool - not to mention 8K and 16K
bufferpools.

So - historical reasons is probably a good answer :-)


Steen Rasmussen
CA
Senior Consultant DB2 tools
Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)
Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Whittaker, Stephen
Sent: Wednesday, January 03, 2007 12:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] BP32K0 question

Our DB2 for z/OS starts out with BP32K and then goes up BP32K1, BPK32K2
etc. No mention of a 'BP32K0' that I could find...They did put the '0'
in there with BP8K0 and BP16K0 but not sure why they left out the
32K...Just assumed they were playin around as usual.. :-)
Its just another 32k buffer pool...
Just something I've noticed...

--Steve....

-----Original Message-----

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: BP32K0 question
(in response to Steen Rasmussen)
Happy New Year to ALL.

Aha, historical reason. And it seems that the guys who added 8K,16K BP
were using different
count method from their DB2 traditions, so we may find some other changes
like that?
Thanks, Steen.





"Rasmussen, Steen" <[login to unmask email]>
·¢¼þÈË: DB2 Data Base Discussion List <[login to unmask email]>
2007-01-04 02:14
Çë´ð¸´ ¸ø
DB2 Database Discussion list at IDUG <[login to unmask email]>


ÊÕ¼þÈË
[login to unmask email]
³­ËÍ

Ö÷Ìâ
Re: [DB2-L] BP32K0 question






I just had a look in my DB2 SQL Reference Guide from 1985 (DB2 Release
1), and at that time you only had BP0, BP1, BP2 and BP32K.

So +20 years ago , no one probably thought of the need for more than 3
4K bufferpools and 1 32K bufferpool - not to mention 8K and 16K
bufferpools.

So - historical reasons is probably a good answer :-)


Steen Rasmussen
CA
Senior Consultant DB2 tools
Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)
Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Whittaker, Stephen
Sent: Wednesday, January 03, 2007 12:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] BP32K0 question

Our DB2 for z/OS starts out with BP32K and then goes up BP32K1, BPK32K2
etc. No mention of a 'BP32K0' that I could find...They did put the '0'
in there with BP8K0 and BP16K0 but not sure why they left out the
32K...Just assumed they were playin around as usual.. :-)
Its just another 32k buffer pool...
Just something I've noticed...

--Steve....

-----Original Message-----

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


harby ariza

Re: BP32K0 question
(in response to hhuang@DCCSH.ICBC.COM.CN)

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



Hi All,

Running a 3090 machine with 200 megabytes of RAM back then even one bufferpool would've been more than enough. So yep looks like historical reasons.

Cheers,

Harby

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of William Huang
Sent: Thursday, 4 January 2007 11:51 AM
To: [login to unmask email]
Subject: Re: [DB2-L] BP32K0 question



Happy New Year to ALL.

Aha, historical reason. And it seems that the guys who added 8K,16K BP were using different
count method from their DB2 traditions, so we may find some other changes like that?
Thanks, Steen.





"Rasmussen, Steen" <[login to unmask email]>
???: DB2 Data Base Discussion List <[login to unmask email]>

2007-01-04 02:14
??? ?
DB2 Database Discussion list at IDUG <[login to unmask email]>


???
[login to unmask email]
??
??
Re: [DB2-L] BP32K0 question






I just had a look in my DB2 SQL Reference Guide from 1985 (DB2 Release
1), and at that time you only had BP0, BP1, BP2 and BP32K.

So +20 years ago , no one probably thought of the need for more than 3
4K bufferpools and 1 32K bufferpool - not to mention 8K and 16K
bufferpools.

So - historical reasons is probably a good answer :-)


Steen Rasmussen
CA
Senior Consultant DB2 tools
Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)
Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Whittaker, Stephen
Sent: Wednesday, January 03, 2007 12:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] BP32K0 question

Our DB2 for z/OS starts out with BP32K and then goes up BP32K1, BPK32K2
etc. No mention of a 'BP32K0' that I could find...They did put the '0'
in there with BP8K0 and BP16K0 but not sure why they left out the
32K...Just assumed they were playin around as usual.. :-)
Its just another 32k buffer pool...
Just something I've noticed...

--Steve....

-----Original Message-----

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in reliance
upon this information, by persons or entities other than the intended recipient is
prohibited.

If you have received this in error, please contact the sender and delete this e-mail
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute
the information contained in this e-mail and any attached files, with the permission
of the sender.

This message has been scanned for viruses with Symantec Scan Engine and cleared by
MailMarshal.
_______________________________________________________________________________________