Interested to Buy Any Domain ? << Click Here >> for more details...
How many buffer pools are available in db2?
- 2 Answers
- 7214 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 |
Can a Db2 table data be retrived through JCL?
What are the three types of page locks that can be held?
What happens to the PLAN if index used by it is dropped?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is query for your birthday date should be in hours,minute and seconds format?
What is a dbrm in db2?
What is a DB2 bind?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
In which column of which DB2 catalog would you find the length of the rows for all tables?
how do you resolve -805?
What is the maximum length of sqlca?
What is the significance of DB2 free space and what parameters control it?
COBOL 
