Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 16953 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
Explain in brief how does db2 determine what lock-size to use?
What is declare cursor?
What is cursor with hold option in db2?
What is the difference between db2 and oracle?
How do you stop a db2 database in linux?
Explain about dbrm.
List down the data types in the db2 database.
What is schema in db2?
Highlight all the advantages that are attached to a package.
Explain how can you do the explain of a dynamic sql statement?
What is innodb buffer pool?
Define declaration generator (dclgen).
Which component is responsible for db2 startup and shutdown?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is db2 look?
