How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 6827 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
Explain the contention situations caused by locks?
What are data types?
how to execute qcmdexc in rpgle?plz write code also?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is ibm db2 client?
What is release/acquire in bind?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How to resolve -504 sql code in DB2?
How to get the ddl of a table in db2?
What kind of database is db2?
COBOL 
