How many Buffer pools are there in DB2 and what are they?
Answer / s
Depends on how many Buffer pools you would like to define
to the system. You can use upto 50 4KB and 10 8KB, 10 16KB
and 10 32KB bufferpools
The minimum buffer pool storage that DB2 allocates
4KB 2000 pages
8KB 1000 pages
16KB 500 pages
32KB 250 pages
| Is This Answer Correct ? | 9 Yes | 2 No |
What is dbrm? When it will be created?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
Is db2 a programming language?
What is commit in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is a LIKE table and how is it created?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are the three DB2 date and time data types and their associated functions?
What's the maximum number of characters that a tablename can have?
how we will do null data selection in cobol-db2 program
What are the three lock types?
What is db2 bind process?