Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 17182 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
What is rct?
How do you stop a db2 database in linux?
What is runstats db2?
Why do we need reorg in db2?
can we view the access paths created by dbrm ? how ? thx
What is package in cobol db2?
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?
What is dclgen in db2?
What is the physical storage length of timestamp data type?
What is clone table?
Name the various locking levels available?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is null indicator in cobol db2?
What is db2 optimizer?
