Interested to Buy Any Domain ? << Click Here >> for more details...
How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 7584 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 |
What is FREEPAGE and PCTFREE in TABLESPACE creation?
List down the types of triggers in the db2 database?
What is the default page size of buffer pools?
how can i pull up a query which was previously stored in qmf
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
how to u check the query is executing or not ?where will u check for sqlcode ?
What is the use of with ur in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is cobol db2?
What is host variable in db2 cobol?
What parameters are used to control the free space in DB2?
How to fetch the last row from the table in SQL (db2)?
COBOL 
