What is FREEPAGE and PCTFREE in TABLESPACE creation?
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 does sqlcabc has?
Before you give the explain statement, what are the prerogatives?
What is explain in db2?
What are packages in db2?
Which component is responsible for processing sql statements and selecting access paths?
what is a corelated subquerry?
What is rebind in db2?
What is the use of predicate?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What happens in bind step in a db2 program?
What does db2 mean?
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?
When do you specify the isolation level?
i want to maintain uniqueness on pdf without make lf??????????