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 |
What happens in bind step in a db2 program?
What is a storage group (stogroup)?
Q3. How will you fetch duplicate values from a DB2 table?
How do you select a row using indexes in db2?
What keyword does an SQL SELECT statement use for a string search?
What is dbrm? What it contains?
On the create tablespace, what does the CLOSE parameter do?
Mention the location where the output received from explain statement is stored.
What are the prerogatives?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?