81) When will you chose to run RUNSTATS?
After a load, or after mass updates, inserts, deletes, or after REORG.
82) Give some example of statistics collected during RUNSTATS?
# of rows in the table
Percent of rows in clustering sequence
# of distinct values of indexed column
# of rows moved to a nearby/farway page due to row length increase
83) What is REORG? When is it used?
REORG reorganizes data on physical storage to reclutser rows, positioning
overflowed rows in their proper sequence, to reclaim space, to restore free
space. It is used after heavy updates, inserts and delete activity and after
segments of a segmented tablespace have become fragmented.
84) What is IMAGECOPY ? –
It is full backup of a DB2 table which can be used in recovery.
85) When do you use the IMAGECOPY? –
To take routine backup of tables
After a LOAD with LOG NO
After REORG with LOG NO
|