Interested to Buy Any Domain ? << Click Here >> for more details...
How many buffer pools are available in db2?
- 2 Answers
- 7207 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 |
what is the difference between normal select query and currosor
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is ibm db2 database?
What is database reorganization?
What is the FREE command?
What is db2 plan table?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
What is cursor?
What is EXPLAIN?
What Utility is used to migrate DB2 from one release to the next?
What is a clustering index?
What do the initials DDL and DML stand for and what is their meaning?
COBOL 
