How many Buffer pools are there in DB2 and what are they?

Question Posted / guest

1 Answers
7675 Views
IBM, I also Faced
E-Mail Answers

How many Buffer pools are there in DB2 and what are they?..

Depends on how many Buffer pools you would like to define
to the system. You can use upto 50 4KB and 10 8KB, 10 16KB
and 10 32KB bufferpools

The minimum buffer pool storage that DB2 allocates
4KB 2000 pages
8KB 1000 pages
16KB 500 pages
32KB 250 pages

Is This Answer Correct ?

9 Yes

2 No

Post New Answer

More DB2 Interview Questions

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers

Mention the definition of cobol in varchar field.

Explain packages.

What is drop table?

What is null in db2?

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers Cap Gemini,

How does DB2 use multiple table indexes?

1 Answers

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers HeadStrong,

Can there be more than one cursor open for any program?

0 Answers

What is collection in db2 bind?

0 Answers

What is dclgen in db2?

0 Answers

What is a db2 table?

0 Answers

For more DB2 Interview Questions Click Here