Interested to Buy Any Domain ? << Click Here >> for more details...
How many buffer pools are available in db2?
- 2 Answers
- 7065 Views
- I also Faced
- E-Mail Answers
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 run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
How to define the a field which accepts value till 99999.99 in db2
Explain in detail about buffer manager and its functionalities?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
Can you use max on a char column?
What is cascading rollback?
Plan has the optimized access path in it. But is that optimized access path is attained or known
What are some SQL aggregates and other built-in functions?
How to update more then one record using update?
What is collection in db2 bind?
What is the physical storage length of the data types date, time, and timestamp?
What is query for your birthday date should be in hours,minute and seconds format?
COBOL 
