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 do I import a csv file into db2?
What is null in db2?
Can we insert update delete in view?
How to create backup table in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
List out the three types of page locks that can be held.
What is the purpose of using commit?
How can we retrieve the total number of records in RPG & CLLE?
What is the syntax for FETCH in DB2 ?
Is ibm db2 free?
Is schema the same as database?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How do I add a column to an existing table in db2?
How to view db2 table structure?
How do I optimize a query in db2?
