What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 15688 Views
- I also Faced
- E-Mail Answers
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 |
What is the use of reorg in db2?
what is the use of bind parameter, Replace?
What if we fail to give values in columns declared as NOT NULL ?
what is a trigger and types of triggers
What is sqlca?
Describe the elements of the SELECT query syntax?
What is a cursor?
what is difference between Static call and Dynamic call? How does it function?
What is the size of a data page?
how to unload different table data into different gdg files/ vsam files.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How can deadlocks be resolved?
COBOL 
