Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 16922 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 do I import a csv file into db2?
What is check constraint. Explain with example.
Are views updateable?
What is the clustering index in the db2 database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is iseries database?
what is utility for parm lib
How do you pull up a query which was previously saved in qmf?
How to restart a DB2 program?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What does reorg do in db2?
Describe major components of db2?
What is the difference between plan and package in db2?
What does sqlcabc has?
