Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 17190 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
How to find the number of rows in a db2 table?
How do I delete a column in db2?
What is the difference between using bind () and rebind () methods of naming class?
What is the difference between oracle and db2?
What is collection in db2 bind?
How to rename a table in DB2 ?
can we view the access paths created by dbrm ? how ? thx
What is copy pending and check pending in db2?
How do I change the column size in db2?
What are the contents of a dclmgen?
What is sqlca’s maximum length?
What is a db2 collection?
What is deadlock in db2?
How to create db2 table in mainframe?
What is the physical storage length of the data types date, time, and timestamp?
