zOs/TX/PER26RE7
//A540769R JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M,SCHENV=DB2
//*MAIN CLASS=LOG
//STEP1 EXEC PGM=DSNUTILB,TIME=1440,
// PARM=(DP4G,'A540769T.REORG'),
// REGION=0M
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSTEMPL DD DISP=SHR,DSN=DP4G.DBAA.LISTDEF(TEMPL)
//SYSIN DD *
LISTDEF LST#REO INCLUDE TABLESPACE QTXDBY.APER26 PARTLEVEL
REORG TABLESPACE QTXDBY.APER26
LOG NO
SORTDATA
COPYDDN(TCOPYD)
SHRLEVEL CHANGE
MAPPINGTABLE S100447.MAPTAB03
MAXRO 300
DRAIN ALL
DELAY 1500
TIMEOUT TERM
UNLOAD CONTINUE
PUNCHDDN TPUNCH
DISCARDDN TDISCA
SORTKEYS
STATISTICS
TABLE(QTXCRY.TPER26)
COLUMN ALL
COLGROUP(TKKEY ) FREQVAL 10 MOST ,
COLGROUP(VERFALL ) FREQVAL 10 MOST ,
COLGROUP(BOERSE ) FREQVAL 10 MOST ,
COLGROUP(WHRG ) FREQVAL 10 MOST ,
COLGROUP(STATUS ) FREQVAL 10 MOST ,
COLGROUP(KURSDATUM ) FREQVAL 10 MOST ,
COLGROUP(MUT_TIMESTAM ) FREQVAL 10 MOST ,
COLGROUP(TK_KURSTYP ) FREQVAL 10 MOST ,
COLGROUP(TK_ZUSATZ ) FREQVAL 10 MOST ,
COLGROUP(CS_KA_NUM ) FREQVAL 10 MOST ,
COLGROUP(KURS_LIEFERUNG ) FREQVAL 10 MOST ,
COLGROUP(KURS_UMRECHNUNG ) FREQVAL 10 MOST ,
COLGROUP(MENGE ) FREQVAL 10 MOST ,
COLGROUP(BOERSE_TK ) FREQVAL 10 MOST ,
COLGROUP(ERSTELLUNG ) FREQVAL 10 MOST ,
COLGROUP(QUELLE ) FREQVAL 10 MOST ,
COLGROUP(LOG_EINTRAG ) FREQVAL 10 MOST ,
COLGROUP(INSTRAD ) FREQVAL 10 MOST ,
COLGROUP(KS_BPL_ST ) FREQVAL 10 MOST ,
COLGROUP(KS_BPL_HT ) FREQVAL 10 MOST ,
COLGROUP(KS_BPL_KS ) FREQVAL 10 MOST ,
COLGROUP(KS_ALT_KS ) FREQVAL 10 MOST ,
COLGROUP(KS_BPL_HA ) FREQVAL 10 MOST ,
COLGROUP(KS_AIS_SP ) FREQVAL 10 MOST ,
COLGROUP(KS_BPL_IN ) FREQVAL 10 MOST ,
COLGROUP(KS_BPL_SP ) FREQVAL 10 MOST ,
COLGROUP(EXCODE ) FREQVAL 10 MOST
INDEX ALL KEYCARD
REPORT NO UPDATE ALL