Mainframe, MVS and zOS Discussion

Posted: **Mon Jan 25, 2016 2:42 pm**

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?

Posted: **Mon Jan 25, 2016 3:42 pm**

Is it one job or is it based on Partition?

Mainframe, MVS and zOS Discussion

Reducing the time of RUNSTAT job.

Reducing the time of RUNSTAT job.

Re: Reducing the time of RUNSTAT job.