zOs/JCL/DB2RUNSQ
//A540769R JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG0
//*
//***************************************************
//* CREATED BY : A540769
//* TIMESTAMP : 06/21/2006.10.10.05
//* ENVIRONMENT: ISPF 5.7MVS TSO
//* RELEASE : V7.4.02 08/31/2004
//* DB2 VERSION: 810
//***************************************************
//STEP1 EXEC PGM=DSNUTILB,TIME=1440,
// PARM=(DBTF,'A540769R.RUNSTA'),
// REGION=0M
//*DSSPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//RNPRIN01 DD SYSOUT=*
//SYSIN DD *
RUNSTATS TABLESPACE "AU01A1T"."SAM15590"
TABLE("SAMJ"."CAURTSDV") SAMPLE 40
COLUMN("CAURTSD-TYPE")
COLGROUP("CAURTSD-TYPE") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM15260"
TABLE("SAMJ"."CAURUG")
COLUMN("CAURUG-ACTSTA")
COLGROUP("CAURUG-ACTSTA") FREQVAL COUNT 15
COLGROUP("CAURUGTS-ACTSTA") FREQVAL COUNT 15
COLGROUP("CAURUG-ACT-INT") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM15460"
TABLE("SAMJ"."CAURUMS")
COLUMN("CAURUMS-G-ACTSTA")
COLGROUP("CAURUMS-G-ACTSTA") FREQVAL COUNT 15
COLGROUP("CAURUS-ACTSTA") FREQVAL COUNT 15
COLGROUP("CAURUMS-ACT-INT") FREQVAL COUNT 15
COLGROUP("CAURUMSTS-ACTSTA") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM13590"
TABLE("SAMJ"."CLARTSDV")
COLUMN("CLARTSD-TYPE")
COLGROUP("CLARTSD-TYPE") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM13260"
TABLE("SAMJ"."CLARUG")
COLUMN("CLARUG-ACTSTA")
COLGROUP("CLARUG-ACTSTA") FREQVAL COUNT 15
COLGROUP("CLARUGTS-ACTSTA") FREQVAL COUNT 15
COLGROUP("CLARUG-ACT-INT") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM13460"
TABLE("SAMJ"."CLARUMS")
COLUMN("CLARUMS-G-ACTSTA")
COLGROUP("CLARUMS-G-ACTSTA") FREQVAL COUNT 15
COLGROUP("CLARUS-ACTSTA") FREQVAL COUNT 15
COLGROUP("CLARUMS-ACT-INT") FREQVAL COUNT 15
COLGROUP("CLARUMSTS-ACTSTA") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM05300"
TABLE("SAMJ"."BASEUS")
COLUMN("BASEUS-C-C01-003")
COLGROUP("BASEUS-C-C01-003") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
//A540769S JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG0
//*
//***************************************************
//* CREATED BY : A540769
//* TIMESTAMP : 06/21/2006.10.10.05
//* ENVIRONMENT: ISPF 5.7MVS TSO
//* RELEASE : V7.4.02 08/31/2004
//* DB2 VERSION: 810
//***************************************************
//STEP1 EXEC PGM=DSNUTILB,TIME=1440,
// PARM=(DBTF,'A540769S.RUNSTA'),
// REGION=0M
//*DSSPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//RNPRIN01 DD SYSOUT=*
//SYSIN DD *
RUNSTATS TABLESPACE "AU01A1T"."SAM05510"
TABLE("SAMJ"."BASETABS")
COLUMN("BASETABS-C-01-02")
COLGROUP("BASETABS-C-01-02") FREQVAL COUNT 15
COLGROUP("BASETABS-C-32-01") FREQVAL COUNT 1
COLGROUP("BASETAB-ACTSTA") FREQVAL COUNT 15
COLGROUP("BASETABS-TYPE") FREQVAL COUNT 15
COLGROUP("BASETAB-USAGE") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM05500"
TABLE("SAMJ"."BASETAB")
COLUMN("BASETAB-SAM-ID3")
COLGROUP("BASETAB-SAM-ID3") FREQVAL COUNT 15
COLGROUP("BASETAB-SAM-ID4") FREQVAL COUNT 15
COLGROUP("BASETAB-ACTSTA") FREQVAL COUNT 15
COLGROUP("BASETAB-KIND") FREQVAL COUNT 15
COLGROUP("BASETAB-USAGE") FREQVAL COUNT 15
COLGROUP("BASETAB-C-01-02") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM15400"
TABLE("SAMJ"."CAURUS")
COLUMN("CAURUS-ACTSTA")
COLGROUP("CAURUS-ACTSTA") FREQVAL COUNT 15
COLGROUP("CAURUSTS-ACTSTA") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM15610"
TABLE("SAMJ"."CAURTSRG")
COLUMN("CAURTSRG-TYPE")
COLGROUP("CAURTSRG-TYPE") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM13400"
TABLE("SAMJ"."CLARUS")
COLUMN("CLARUS-ACTSTA")
COLGROUP("CLARUS-ACTSTA") FREQVAL COUNT 15
COLGROUP("CLARUSTS-ACTSTA") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE
RUNSTATS TABLESPACE "AU01A1T"."SAM13610"
TABLE("SAMJ"."CLARTSRG")
COLUMN("CLARTSRG-TYPE")
COLGROUP("CLARTSRG-TYPE") FREQVAL COUNT 15
SORTNUM 4
SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE