zOs/JCL/DB2RUNST
//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=(DP4G,'A540769S.RUNSTA'),
// REGION=0M
//*DSSPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//RNPRIN01 DD SYSOUT=*
//SYSIN DD *
LISTDEF LSTA
INCLUDE TABLESPACE DA540769.A403*
-- INCLUDE TABLESPACE DS100447.PLANTABS
-- INCLUDE TABLESPACE VV27A1T.VDPS329
LISTDEF LSTB INCLUDE LIST LSTA BASE
LISTDEF LSTL INCLUDE LIST LSTA LOB
OPTIONS EVENT (ITEMERROR, SKIP)
RUNSTATS TABLESPACE LIST LSTA -- DA540769.A403P2
TABLE USE PROFILE
-- INDEX(ALL KEYCARD) -- FREQVAL NUMCOLS 99 COUNT 10)
REPORT NO UPDATE ALL
SHRLEVEL CHANGE
//SYSIX DD * SET PROFILE --------------------------
RUNSTATS TABLESPACE DA540769.A403P1
TABLE (A540769.TWK403P1)
COLUMN(ID)
INDEX(ALL KEYCARD) -- FREQVAL NUMCOLS 99 COUNT 10)
SET PROFILE -- PROFILE UPDATE
//