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