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 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,