How many Buffer pools are there in DB2 and what are they?
Answer Posted / 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 |
Post New Answer View All Answers
What is check constraint. Explain with example.
How can you classify the locks in db2?
What is a trigger in the db2 database?
What is the latest version of ibm db2?
What is a system catalog table in db2?
How do I add a column in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is db2 catalog database?
Discuss about db2 bind?
How can you quickly find out the # of rows updated after an update statement?
Mention the various locks that are available in db2.
How do I add a column to an existing table in db2?
Can we update view in db2?
What is a bind card?
Which command is used to connect to a database in DB2 ? Give the Syntax.