Interested to Buy Any Domain ? << Click Here >> for more details...
How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 7757 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 |
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
what are stage one indexable predicates?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is a page in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How many types of page locks can be held in db2?
What is SPUFI?
Which command is used to remove all rows from a table?
What is the difference between Primary key and unique index?
Define data page.
How will you delete duplicate records from a table?
COBOL 
