Page 1 of 1

Buffer pool in DB2 and batch processing on mainframes.

Posted: Tue Dec 08, 2015 11:15 am
by Ashish Mathew
Hi,

We use buffer pool concept in in DB2 and in batch processing on mainframes too. Do they follow the same concept or DB2 treat the buffer pools differently?

Re: Buffer pool in DB2 and batch processing on mainframes.

Posted: Tue Dec 08, 2015 6:33 pm
by Robert Sample
Are you talking batch jobs in general or batch DB2 jobs in particular?

Re: Buffer pool in DB2 and batch processing on mainframes.

Posted: Wed Dec 09, 2015 2:49 pm
by Ashish Mathew
Robert Sample wrote:Are you talking batch jobs in general or batch DB2 jobs in particular?
I am asking in general. I think I can apply the same concept to batch DB2 jobs also.

Re: Buffer pool in DB2 and batch processing on mainframes.

Posted: Thu Dec 10, 2015 5:34 am
by Robert Sample
Buffering for batch jobs works differently. Each data set usually has its own set of buffers -- there's no pooling as with DB2. There are situations where there will be pools (such as when BLSR -- Batch Local Shared Resources -- is used) but otherwise it's one set of buffers per data set.