Interested to Buy Any Domain ? << Click Here >> for more details...
How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 7697 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 |
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What if we fail to give values in columns declared as NOT NULL ?
What will the COMMIT accomplish?
What techniques are used to retrieve data from more than one table in a single SQL statement?
what is difference between Static call and Dynamic call? How does it function?
pls explain the precompilation process of cobol-db2 pgm
What is the purpose of rollback and commit?
How can we retrieve the total number of records in RPG & CLLE?
what are extents?
What is dbrm library?
COBOL 
