View previous topic :: View next topic
|
Author |
Message |
abirami_yn
New User
Joined: 30 Jan 2006 Posts: 3
|
|
|
|
HI,
Can u Explain about RUNSTATS and REORG in DB2?
Thanks in Advance,
Abirami |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
Back to top |
|
|
v.amirthalingam
New User
Joined: 13 Feb 2006 Posts: 1 Location: chennai
|
|
|
|
RUNSTATS
Gathers summary information about the characteristics of the data in table spaces and indexes. This information is recorded in the DB2 catalog, and is used by DB2 to select access paths to data during the bind process. It is available to the database administrator for evaluating database design, and determining when table spaces or indexes should be reorganized
REORG
Reorganized a table space to improve access performance and reclaim fragmented space. In addition, the utility can reorganize a single partition of either a partitioned index ora partitioned table space. If you specify REORG UNLOAD ONLY or REORG UNLOAD PAUSE, the REORG utility unloads data in a format acceptable to the LOAD utility of the same DB2 table space.
Regards,
amir... |
|
Back to top |
|
|
|