What is the difference between RUNSTATS and REORG

pretty · New User Joined: 13 Mar 2006 Posts: 6

My question is about Runstats, reorg and what is the difference between these two where should we use runstats.

Jag · New User Joined: 07 Dec 2005 Posts: 30 Location: India

Hi,

Reorg and Runstats: Reorg is used to ornaize the memory space and put all the data in a perticular manner so that data accessing will be easy and also to reduce the wastage of memory..

Run stats is used to store the statistics of which stored where and stuff in the DB2 catalog...

Runstats is a job when we organize the date we run the Runstats to store the new memory location where the data is stored...If we dont run the runstats also DB2will work But the performace will be low..

Cheers,
Jag