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
What language is db2 written in?
How do you find the maximum value in a column in db2?
What is buffer pool and list some of them?
What is dbrm? When it will be created?
Why db2 is called db2?
Why cursor is used in db2?
B37 abend during spufi?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Why do chiropractors use drop table?
What is dbrm library?
What is bind plan?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How can the duplicate values be eliminated from db2 select?
Define declaration generator (dclgen).
How to check table size in db2 sap?
