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 |
Define check constraint.
How to retrieve rows from a db2 table in embedded sql?
Is ibm db2 open source?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is a collection?
Can we declare DB2 HOST variable in COBOL COPY book?
What is the use of reorg in db2?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
Which components manage deadlocks in db2?
How do you filter out the rows retrieved from a Db2 table ?
Is db2 a mainframe database?
What are db2 objects?