What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 16256 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 |
Which catalog table stores referential constraints?
What is dclgen (declaration generator)?
what is the difference between where clause and having clause
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is role in db2?
What is ibm db2 used for?
What does db2 mean?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Can you search give an array in the WHERE clause of a db2 query?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
What are the two types of logging in the db2 database? Explain them.
COBOL 
