Follow Our FB Page << >> 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 is the use of reorg in db2?

0 Answers  

what is the use of bind parameter, Replace?

5 Answers   IBM,

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

what is a trigger and types of triggers

3 Answers   HSBC,

What is sqlca?

0 Answers  

Describe the elements of the SELECT query syntax?

3 Answers  

What is a cursor?

2 Answers  

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

What is the size of a data page?

2 Answers   IBM,

how to unload different table data into different gdg files/ vsam files.

3 Answers  

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

How can deadlocks be resolved?

0 Answers