Interested to Buy Any Domain ? << Click Here >> for more details...
How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 7765 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s
Depends on how many Buffer pools you would like to define
to the system. You can use upto 50 4KB and 10 8KB, 10 16KB
and 10 32KB bufferpools
The minimum buffer pool storage that DB2 allocates
4KB 2000 pages
8KB 1000 pages
16KB 500 pages
32KB 250 pages
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the information associated with sysibm.syslinks table?
What is meant by explain?
How to create backup table in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is view db2?
Explain packages.
What is the clustering index in the db2 database?
What's The Error Code For Unique Index Voilation?
define clustering index.
What does reorg do in db2?
Highlight all the advantages that are attached to a package.
What os does db2 run on?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is cascading rollback?
