Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How would you find out the total number of rows in a db2 table?
What is db2 optimizer?
How is a typical db2 batch pgm executed?
What are the 2 sqlcodes that are returned?
How connect db2 database to datastage?
What are types of indexes?
What is the difference between drop table and delete table?
What is innodb buffer pool?
What is dbrm?
What is the use of dclgen in db2?
What is schema in db2?
Which isolation level provides maximum concurrency?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the use of runstats in db2?
What is db2 bind?
