How many buffer pools are available in db2?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / manisha shukla
A buffer pool is main storage that is reserved to satisfy
the buffering requirements for one or more tablespaces or
indexes, and is made up of either 4K or 32K pages.
There are four buffer pools: BP0, BP1, BP2, and BP32.
Is This Answer Correct ? | 2 Yes | 3 No |
How do I optimize a query in db2?
What is the difference between static and dynamic SQL?
what's the error code for Unique Index Violation?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
What is the difference between Where and Having Clause
What are the isolation levels possible ?
What is DCLGEN ?
what is a collection?
What is schema in db2?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What does it mean if the null indicator has -1, 0, -2?
Is schema the same as database?