How many buffer pools are available in db2?

Answer Posted / s

You can define:

50 4KB BP0-BP49
10 8KB BP8K0-BP8K9
10 16KB BP16K0-BP16K9
10 32KB BP32K0-BP32K9

The number of buffer pools you define is specific to the
DB2 sysbsystem and depends on the DB2 workload. If you dont
have enough real memory to support your bufferpools,
performance will affected severely because of paging.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the definition of cobol in varchar field.

700


Why db2 is called db2?

597


Is db2 a mainframe database?

569


How do I change the column size in db2?

600


How many types of page locks can be held in db2?

593






Is db2 a database?

576


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2327


Can we delete records from view?

566


What is explain plan in db2?

592


What is package in cobol db2?

704


What does db2 mean?

589


What is the difference between bind and rebind in db2?

858


is it compulsory commitment control in journal?

2016


What is db2 connect?

612


What is the physical storage length of timestamp data type?

646