What is FREEPAGE and PCTFREE in TABLESPACE creation?
Answer Posted / abhishek kale
PCTFREE indicates to DB2 what percentage of each page in
the table space or index to leave free when either loading
or reorganizing the data. DB2 will then use that free space
when inserting new rows and index entries.
FREEPAGE indicates to DB2 how often to leave a full page of
free space when either loading or reorganizing the data.
For example, if you specify FREEPAGE 5, DB2 will allocate a
page of free space after filling five pages with data.
|Is This Answer Correct ?||11 Yes||3 No|
Explain about mirror activator disk mirroring?
What is netezza database?
define clustering index.
What is cursor in dbms?
What is the difference between dbm cfg and db cfg file in db2 ?
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
List down the types of triggers in the db2 database?
How is a typical db2 batch pgm executed?
What is db2 connect?
What is a collection in db2?
What is db2 bind?
Define buffer pool.
What is dbrm library?
How to access db2 tables in mainframe?