How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 6792 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 |
Can you access the DB2 Directory table using SQL?
What is a synonym? How is it used?
What does db2 blu stand for?
What is the syntax for FETCH in DB2 ?
When reorg is used?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
How do you stop a db2 database in linux?
How many Buffer pools are there in DB2 and what are they?
Explain dclgen.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Explain an outer join?
COBOL 
