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?



What is FREEPAGE and PCTFREE in TABLESPACE creation?..

Answer / 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

More DB2 Interview Questions

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,


What is cloudant database?

0 Answers  


Explain the function of data manager.

0 Answers  


Define db2 and its databases?

0 Answers  


What is the maximum No of rows per page?

0 Answers   IBM,






How would you find out the total number of rows in a db2 table?

0 Answers  


Why cursor is used in db2?

0 Answers  


What is explain plan in db2?

0 Answers  


How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,


How do you stop a db2 database in linux?

0 Answers  


AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,


can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,






Categories