What is FREEPAGE and PCTFREE in TABLESPACE creation?
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 is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
how to resolve -818 error. how to see timestamp token in load module and plan
is it possible to get -811 error when you use cursors. why?
what is the role of the cursor in db2?
Is db2 relational database?
Define db2.
Can you tell me how can you find out the # of rows updated after an update statement?
What is runstats utility in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is meant by a unit of recovery?
Could anyone clearly explain the diference between sub query and correlated sub query?