How many buffer pools are there in DB2?
Answers were Sorted based on User's Feedback
Answer / sabahat khan
50 4K size Buffer Pool BP01 to BP49
10 8K size Buffer Pool 8KBP0 to 8KBP9
10 16K size Buffer Pool 16KBP0 to 16KBP9
10 32K size Buffer Pool 32KBP0 to 32KBP9
Is This Answer Correct ? | 15 Yes | 0 No |
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.
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
Can we install 2 different versions of Db2 on same mainframe?
what is the difference between normal select query and currosor
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What is lock escalation?
How to connect to db2 database from windows command line?
What is the use of db2?
What is an instance in db2?
how to u check the query is executing or not ?where will u check for sqlcode ?
What's The Error Code For Unique Index Voilation?