Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 17073 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 meant by concurrency?
What's the maximum number of volumes that can be added to a STOGROUP?
Explain the function of data manager.
What is a view? Why use it?
Can any one tell me about Restart logic in DB2.
Explain correlated sub-queries.
How to resolve -818 sql code in DB2?
what is a collection?
What is host variable in db2 cobol?
What are the functions in DB2?
what is the name of the default db2 catalog database?
what are the bind parameters?
COBOL 
