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 is reorg and runstats in db2?
How do I copy a table in db2?
How to execute stored procedures?
How can you count the number of rows from a table tab?
How to rename a table in DB2 ?
What is consistency token in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What are the contents of dclgen?
Explain packages.
How to run db2 command in windows?
What is the maximum size of a char data type in db2?
What is the difference between oracle and db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Can we insert update delete in view?