Answer Posted / 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 |
Post New Answer View All Answers
What is a buffer in memory?
What are types of indexes?
What is reorg and runstats in db2?
What is dclgen (declaration generator)?
What is precompiler in db2?
What is drop table?
How can the duplicate values be eliminated from db2 select?
What are host variables in db2?
Which component is responsible for db2 startup and shutdown?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How do I add a column in 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.
How do I add a column to an existing table in db2?
Which component is used to execute the sql statements?
Give a brief description of db2 isolation levels?