DB2: Sample job for RUNSTATS

The below job performs RUNSTATS for an entire database. If RUNSTATS needs to be run for a specific table space, then LISTDEF need to be changed accordingly.

//STEP01  EXEC PGM=DSNUTILB,PARM='DBXT,RUNSTAT'           

//LISTD    DD  *                                      

 LISTDEF TSLIST                                       

 INCLUDE TABLESPACE MYDB.*                 

//SYSPRINT DD SYSOUT=*

//SYSIN    DD *                       

  OPTIONS                             

   LISTDEFDD LISTD                    

  RUNSTATS TABLESPACE LIST TSLIST     

    TABLE ALL                         

    INDEX ALL                         

  SHRLEVEL CHANGE                     

//*