Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 17189 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 a buffer in memory?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is IMAGECOPY ?
How to solve S0C7 abend with out using DISPlay in 10 mins?
Define data page.
What is meant by explain?
What is referential integrity?
What is catalog database in db2?
Explain about rct in db2?
what is sql abend code -801,-802?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
COBOL 
