Reducing the time of RUNSTAT job.

[Priya Hare]

Hi.

One of our job, which is a DB2 RUNSTATS job, takes a long time to execute.

We have a huge partition table space (150GB) and the job needs 450 minutes to RUNSTATS on the entire table space.

RUNSTATS statements are like this:

Code: Select all

RUNSTATS TABLESPACE DATABS.TPSAPST 
TABLE(ALL) INDEX(ALL) SHRLEVEL CHANGE 

Is thereany way to reduce the Job execution time?

[zprogrammer]

Is it one job or is it based on Partition?