How many Buffer pools are there in DB2 and what are they?
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
What are packages in db2?
What is an instance database?
How would you find out the total number of rows in a db2 table?
Describe major components of db2?
can we view the access paths created by dbrm ? how ? thx
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Explain in brief how does db2 determine what lock-size to use?
How do we specify index to include or not during bind process.
How do I copy a table in db2?
What is explain in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is ibm db2 connect?
What is catalog database in db2?
What's The Percentage Free Space ?
Define declaration generator (dclgen).