Buffer pool in DB2 and batch processing on mainframes.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
Ashish Mathew
Registered Member
Posts: 50
Joined: Thu Jun 27, 2013 6:17 pm

Buffer pool in DB2 and batch processing on mainframes.

Post 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?
User avatar
Robert Sample
Global Moderator
Global Moderator
Posts: 1886
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
United States of America

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

Post by Robert Sample »

Are you talking batch jobs in general or batch DB2 jobs in particular?
Ashish Mathew
Registered Member
Posts: 50
Joined: Thu Jun 27, 2013 6:17 pm

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

Post 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.
User avatar
Robert Sample
Global Moderator
Global Moderator
Posts: 1886
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
United States of America

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

Post 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.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”