Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 17071 Views
- I also Faced
- E-Mail Answers
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
What is the information associated with sysibm.syslinks table?
Outputs of explain are with matchcols = 0. What does this signify?
Mention the downsides of page level lock.
What is cloudant database?
What is page size in db2?
What is clone table?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How does cobol compile db2 program?
Mention the different locking levels that are available in db2.
How to rename a table in DB2 ?
What is null in db2?
What is copy pending status in db2?
What is the use of reorg in db2?
What is the maximum size of varchar data type in db2?
What are catalog tables in db2?
