|
View previous topic :: View next topic
|
| Author |
Message |
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
I'm quite familiar withe the concept "BUFFER POOL" in DB2, but how about Buffer?
from the name , I understand that BUFFER POOL is a place where a lot of buffer reside.
I searched the DB2 manuals, but all are about BUFFER POOL, no specification to the concept: buffer.
So, would you please give me a hint on this? thanks. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
how in heaven can You say that You are familiar with BUFFER POOL when You seem to ignore the elementary concept of buffer 
what happened when You googled for buffer or buffer computer science
no reason for us to retype what can be found with no effort in computer science literature
 |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
isn't buffer a cow-like animal ?
or is it the thing made from milk which you use to bake stuff in ? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
the only time i heard buffer used for a dairy derivative
was when somebody asked for it with the mouth stuffed with sausages and bacon  |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| I thought there was milk from a "reduced-calorie buffer" used for making Mozarella? |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| I'm quite familiar withe the concept "BUFFER POOL" in DB2, but how about Buffer? |
Why do we not have a facepalm emoticon?
How can anyone be familiar with buffer pools but not know about buffers? It's like saying you are familiar with transportation but not know what a car is. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Or Car Pools, and don't know what a Car is?
I like the sort of "Buffer Neighbourhood" definition. Lounging on the front steps in the summer, admiring the record-areas in their skimpy summer dresses... whoa, cold shower please.
Edit, if we're getting really off-topic. Another one off to FAQ (or CAQ).
Thomas the Tank engine has buffers. You also have buffers at the end of railway tracks. Sometimes Thomas, or the other engines, run into the buffers, which they would hit with their buffers. I don't think it has anything to do with pools. |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| A child can act as a buffer between its parents. So if there is more than 1 child we talk about a buffer pool. |
|
| Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
Buffer is a high school cheerleader who learns that she is a Slayer, a chosen one gifted with the strength and skills to fight the forces of evil, and who carries out her destiny in...
Oops, that's Buffy. Never mind. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
| Possibly a reference to the Pattern Buffer (rather important part of the Transporter - Beam me up / Energize) |
|
| Back to top |
|
|
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
From some articles, I can see buffer can be counted,
i.e. "10000 buffers in BP0",
so, how many allocation is needed for a buffer?
can buffer be caculated by "KB" or "MB" or cylinder/track?
Still, can you please give me some material on this concept for z/OS? thanks. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
so, how many allocation is needed for a buffer?
can buffer be caculated by "KB" or "MB" or cylinder/track? |
The answer to your first question is, however many are needed. The answer to your second question is no -- one buffer represents the bytes required to read one physical block from the tape / disk / whatever into memory. How many bytes is that? If the block size is 4096 then the answer is 4096. If the block size is 32760 then the answer is 32760. Typically, buffer allocations are in terms of the number of buffers and not KB or MB or tracks or cylinders.
How many buffers are needed? That depends upon the file type, the access characteristics (sequential, random, skip sequential), and so forth. There is no single answer to the question. If there are not enough buffers, the processing is slowed down since the system is having to wait for data to move from the external media to memory. If there are too many buffers, the system uses resources to manage them and processing again suffers. QSAM (sequential) files default to 5 buffers while VSAM KSDS files default to 2 data and 1 index buffer. Neither default is anywhere near enough, generally. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Buffer is an area of storage into which data is read or from which it is written. Typically, buffers are used only for temporary storage.
With respect to DB2:
• 4-KB page buffer pools are named BP0 through BP49
• 8-KB page buffer pools are named BP8K0 through BP8K9
• 16-KB page buffer pools are named BP16K0 through BP16K9
• 32-KB page buffer pools are named BP32K through BP32K9
This link might be of your interest too: www.ibm.com/developerworks/data/library/techarticle/0212wieser/#bufferpools |
|
| Back to top |
|
|
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
so, how do I know the buffer quantity is enough or not?
That is, how to determine the quantity of buffer for a particular buffer pool, e.g. BP0? |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
| Back to top |
|
|
|
|
