zOs/SQL/PLANCLE4

//A540769R JOB (CP00,KE50),'DB2 reo',
//             TIME=1440,REGION=0M,SCHENV=DB2ALL,CLASS=M1,
//             MSGCLASS=T,NOTIFY=&SYSUID
//*
//* ux utility generator reo
//*           who RZX DE0G A540769 2
//*           13.11.16 16:11:03 A540769J
//*
//STEP1    EXEC PGM=DSNUTILB,TIME=1440,
//             PARM=(DE0G,'A540769R.REORG'),
//             REGION=0M
//SYSPRINT   DD SYSOUT=*
//*YSPRINT   DD DSN=DSN.JOBRUN.A540769J.STEP1.#DT#,
//*            DISP=(NEW,CATLG,CATLG),MGMTCLAS=BAT#NW,DSNTYPE=LARGE,
//*            DCB=(RECFM=FB,LRECL=132,DSORG=PS),SPACE=(CYL,(1,1000))
//SYSUDUMP   DD SYSOUT=*
//SYSTEMPL   DD DISP=SHR,DSN=DE0G.DBAA.LISTDEF(TEMPL)
//UTPRINT    DD SYSOUT=*
//RNPRIN01   DD SYSOUT=*
//STPRIN01   DD SYSOUT=*
//INDUMMY    DD DUMMY
//SYSIN      DD *
--OPTIONS PREVIEW
  LISTDEF   ALLLI
    INCLUDE TABLE CMNBATCH.PLAN_TABLE PARTLEVEL ALL
    INCLUDE TABLE CMNBATCH.DSN_*_TABLE PARTLEVEL ALL
  LISTDEF BASELI INCLUDE LIST   ALLLI BASE
  LISTDEF AUXLI  INCLUDE LIST   ALLLI LOB
                 INCLUDE LIST   ALLLI XML
---- reorg base --------------------------------------------------------
 REORG TABLESPACE  LIST BASELI
    LOG NO
    SORTDATA
    COPYDDN(TCOPYD)
    SHRLEVEL CHANGE
    DRAIN_WAIT 20
      RETRY 20
      RETRY_DELAY 180
      MAXRO 20
      DRAIN ALL
      LONGLOG CONTINUE
      DELAY 600
      TIMEOUT TERM
    UNLDDN TSRECD
    UNLOAD CONTINUE
    PUNCHDDN TPUNCH
    DISCARDDN TDISC
    SORTKEYS
    SORTDEVT DISK
    STATISTICS
      INDEX ALL KEYCARD
      UPDATE ALL
---- reorg lob and xml ----------------------------------------------
  REORG TABLESPACE  LIST AUXLI
    LOG NO
    SORTDATA
    COPYDDN(TCOPYD)
    SHRLEVEL CHANGE
    DRAIN_WAIT 20
      RETRY 20
      RETRY_DELAY 180
      MAXRO 20
      DRAIN ALL
      LONGLOG CONTINUE
      DELAY 600
      TIMEOUT TERM
    UNLDDN TSRECD
    UNLOAD CONTINUE
    SORTKEYS
    SORTDEVT DISK
---- runstats all ------------------------------------------------------
  RUNSTATS TABLESPACE LIST ALLLI
    SHRLEVEL CHANGE
    TABLE USE PROFILE
    TABLESAMPLE SYSTEM AUTO