Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about mirror activator disk mirroring?

338


What is netezza database?

343


define clustering index.

420


What is cursor in dbms?

352


Define sqlca.

438






What is the difference between dbm cfg and db cfg file in db2 ?

561


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

1310


List down the types of triggers in the db2 database?

385


How is a typical db2 batch pgm executed?

425


What is db2 connect?

371


What is a collection in db2?

386


What is db2 bind?

414


Define buffer pool.

426


What is dbrm library?

374


How to access db2 tables in mainframe?

372