DSNTEJCC
This JCL shows how to execute DSN1SMFP, a tool for processing Db2 trace data in SMF format into reports that are useful for evaluating the Db2 environment for Common Criteria.
//* 00000100
//* Job name = DSNTEJCC 00000200
//* 00000300
//* LICENSED MATERIALS - PROPERTY OF IBM 00000400
//* 5615-DB2 00000500
//* (C) COPYRIGHT 2006, 2013 IBM CORP. ALL RIGHTS RESERVED. 00000600
//* 00000700
//* Status = VERSION 11 00000800
//* 00000900
//* Function = 00001000
//* This JCL shows how to execute DSN1SMFP, a tool for processing 00001100
//* DB2 trace data in SMF format into reports that are useful 00001200
//* for evaluating the DB2 environment for Common Criteria. 00001300
//* 00001400
//* Pseudocode = 00001500
//* TEJCCS01 Step Delete existing DSN1SMFP report data sets 00001600
//* TEJCCS01 Step Execute DSN1SMFP 00001700
//* 00001800
//* Dependencies = 00001900
//* - The job step that executes DSN1SMFP needs to specify both 00002000
//* the SDSNEXIT and SDSNLOAD libraries unless these are available 00002100
//* from the link list. 00002200
//* - The SDSNEXIT library needs to contain the DSNHDECP module 00002300
//* used by the DB2 subsystem that generated the SMF records to be 00002400
//* processed. 00002500
//* 00002600
//* Notes = 00002700
//* - The following manual tailoring is required: 00002800
//* 1. Add a valid job card 00002900
//* 2. Locate and change all occurrences of the following strings 00003000
//* as indicated: 00003100
//* A. 'DSN!!0.SDSN' to the 'prefix.SDSN' of DB2's target 00003200
//* libraries. 00003300
//* B. 'DSN!!0.DSNTEJCC' to the 'prefix.DSNTEJCC' for data sets 00003400
//* created by this job 00003500
//* C. 'DSN!!0.!DSN!.SMFDATA' to the name of the input data set 00003600
//* containing the SMF records to be processed 00003700
//* 3. SPACE allocations for output data sets may need to be 00003800
//* adjusted depending on the input data set from SMF. 00003900
//* 00004000
//* Change Activity = 00004100
//* PK90013 - Update for DB2 V9 @V9* 00004200
//* 15674_dsn1smfp Update for DB2 V11 @VB* 00004300
//********************************************************************* 00004400
//* 00004500
//* Step 1: Delete existing DSN1SMFP report data sets 00004600
//* 00004700
//TEJCCS01 EXEC PGM=IEFBR14 00004800
//IFCID003 DD DSN=DSN!!0.DSNTEJCC.IFCID003, 00004900
// DISP=(MOD,DELETE), 00005000
// UNIT=SYSDA,SPACE=(0,0) 00005100
//IFCID004 DD DSN=DSN!!0.DSNTEJCC.IFCID004, 00005200
// DISP=(MOD,DELETE), 00005300
// UNIT=SYSDA,SPACE=(0,0) 00005400
//IFCID005 DD DSN=DSN!!0.DSNTEJCC.IFCID005, 00005500
// DISP=(MOD,DELETE), 00005600
// UNIT=SYSDA,SPACE=(0,0) 00005700
//IFCID023 DD DSN=DSN!!0.DSNTEJCC.IFCID023, 00005800
// DISP=(MOD,DELETE), 00005900
// UNIT=SYSDA,SPACE=(0,0) 00006000
//IFCID024 DD DSN=DSN!!0.DSNTEJCC.IFCID024, 00006100
// DISP=(MOD,DELETE), 00006200
// UNIT=SYSDA,SPACE=(0,0) 00006300
//IFCID025 DD DSN=DSN!!0.DSNTEJCC.IFCID025, 00006400
// DISP=(MOD,DELETE), 00006500
// UNIT=SYSDA,SPACE=(0,0) 00006600
//IFCID083 DD DSN=DSN!!0.DSNTEJCC.IFCID083, 00006700
// DISP=(MOD,DELETE), 00006800
// UNIT=SYSDA,SPACE=(0,0) 00006900
//IFCID106 DD DSN=DSN!!0.DSNTEJCC.IFCID106, 00007000
// DISP=(MOD,DELETE), 00007100
// UNIT=SYSDA,SPACE=(0,0) 00007200
//IFCID140 DD DSN=DSN!!0.DSNTEJCC.IFCID140, 00007300
// DISP=(MOD,DELETE), 00007400
// UNIT=SYSDA,SPACE=(0,0) 00007500
//IFCID141 DD DSN=DSN!!0.DSNTEJCC.IFCID141, 00007600
// DISP=(MOD,DELETE), 00007700
// UNIT=SYSDA,SPACE=(0,0) 00007800
//IFCID142 DD DSN=DSN!!0.DSNTEJCC.IFCID142, 00007900
// DISP=(MOD,DELETE), 00008000
// UNIT=SYSDA,SPACE=(0,0) 00008100
//IFCID143 DD DSN=DSN!!0.DSNTEJCC.IFCID143, 00008200
// DISP=(MOD,DELETE), 00008300
// UNIT=SYSDA,SPACE=(0,0) 00008400
//IFCID144 DD DSN=DSN!!0.DSNTEJCC.IFCID144, 00008500
// DISP=(MOD,DELETE), 00008600
// UNIT=SYSDA,SPACE=(0,0) 00008700
//IFCID145 DD DSN=DSN!!0.DSNTEJCC.IFCID145, 00008800
// DISP=(MOD,DELETE), 00008900
// UNIT=SYSDA,SPACE=(0,0) 00009000
//IFCID269 DD DSN=DSN!!0.DSNTEJCC.IFCID269, 00009100
// DISP=(MOD,DELETE), 00009200
// UNIT=SYSDA,SPACE=(0,0) 00009300
//IFCID270 DD DSN=DSN!!0.DSNTEJCC.IFCID270, 00009400
// DISP=(MOD,DELETE), 00009500
// UNIT=SYSDA,SPACE=(0,0) 00009600
//IFCID350 DD DSN=DSN!!0.DSNTEJCC.IFCID350, 00009700
// DISP=(MOD,DELETE), 00009800
// UNIT=SYSDA,SPACE=(0,0) 00009900
//IFCID361 DD DSN=DSN!!0.DSNTEJCC.IFCID361, 00010000
// DISP=(MOD,DELETE), 00010100
// UNIT=SYSDA,SPACE=(0,0) 00010200
//IFCID362 DD DSN=DSN!!0.DSNTEJCC.IFCID362, 00010300
// DISP=(MOD,DELETE), 00010400
// UNIT=SYSDA,SPACE=(0,0) 00010500
//* 00010600
//* Step 2: Execute DSN1SMFP 00010700
//* 00010800
//TEJCCS02 EXEC PGM=DSN1SMFP,COND=(4,LT) 00010900
//STEPLIB DD DISP=SHR,DSN=DSN!!0.SDSNEXIT 00011000
// DD DISP=SHR,DSN=DSN!!0.SDSNLOAD 00011100
//SMFINDD DD DISP=SHR,DSN=DSN!!0.!DSN!.SMFDATA 00011200
//SYSPRINT DD SYSOUT=* 00011300
//IFCID003 DD DSN=DSN!!0.DSNTEJCC.IFCID003, 00011400
// DISP=(,CATLG), 00011500
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00011600
// DCB=(RECFM=FB,LRECL=132) 00011700
//IFCID004 DD DSN=DSN!!0.DSNTEJCC.IFCID004, 00011800
// DISP=(,CATLG), 00011900
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00012000
// DCB=(RECFM=FB,LRECL=132) 00012100
//IFCID005 DD DSN=DSN!!0.DSNTEJCC.IFCID005, 00012200
// DISP=(,CATLG), 00012300
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00012400
// DCB=(RECFM=FB,LRECL=132) 00012500
//IFCID023 DD DSN=DSN!!0.DSNTEJCC.IFCID023, 00012600
// DISP=(,CATLG), 00012700
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00012800
// DCB=(RECFM=FB,LRECL=132) 00012900
//IFCID024 DD DSN=DSN!!0.DSNTEJCC.IFCID024, 00013000
// DISP=(,CATLG), 00013100
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00013200
// DCB=(RECFM=FB,LRECL=132) 00013300
//IFCID025 DD DSN=DSN!!0.DSNTEJCC.IFCID025, 00013400
// DISP=(,CATLG), 00013500
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00013600
// DCB=(RECFM=FB,LRECL=132) 00013700
//IFCID083 DD DSN=DSN!!0.DSNTEJCC.IFCID083, 00013800
// DISP=(,CATLG), 00013900
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00014000
// DCB=(RECFM=FB,LRECL=132) 00014100
//IFCID106 DD DSN=DSN!!0.DSNTEJCC.IFCID106, 00014200
// DISP=(,CATLG), 00014300
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00014400
// DCB=(RECFM=FB,LRECL=132) 00014500
//IFCID140 DD DSN=DSN!!0.DSNTEJCC.IFCID140, 00014600
// DISP=(,CATLG), 00014700
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00014800
// DCB=(RECFM=FB,LRECL=132) 00014900
//IFCID141 DD DSN=DSN!!0.DSNTEJCC.IFCID141, 00015000
// DISP=(,CATLG), 00015100
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00015200
// DCB=(RECFM=FB,LRECL=132) 00015300
//IFCID142 DD DSN=DSN!!0.DSNTEJCC.IFCID142, 00015400
// DISP=(,CATLG), 00015500
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00015600
// DCB=(RECFM=FB,LRECL=132) 00015700
//IFCID143 DD DSN=DSN!!0.DSNTEJCC.IFCID143, 00015800
// DISP=(,CATLG), 00015900
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00016000
// DCB=(RECFM=FB,LRECL=132) 00016100
//IFCID144 DD DSN=DSN!!0.DSNTEJCC.IFCID144, 00016200
// DISP=(,CATLG), 00016300
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00016400
// DCB=(RECFM=FB,LRECL=132) 00016500
//IFCID145 DD DSN=DSN!!0.DSNTEJCC.IFCID145, 00016600
// DISP=(,CATLG), 00016700
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00016800
// DCB=(RECFM=FB,LRECL=132) 00016900
//IFCID269 DD DSN=DSN!!0.DSNTEJCC.IFCID269, 00017000
// DISP=(,CATLG), 00017100
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00017200
// DCB=(RECFM=FB,LRECL=132) 00017300
//IFCID270 DD DSN=DSN!!0.DSNTEJCC.IFCID270, 00017400
// DISP=(,CATLG), 00017500
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00017600
// DCB=(RECFM=FB,LRECL=132) 00017700
//IFCID350 DD DSN=DSN!!0.DSNTEJCC.IFCID350, 00017800
// DISP=(,CATLG), 00017900
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00018000
// DCB=(RECFM=FB,LRECL=132) 00018100
//IFCID361 DD DSN=DSN!!0.DSNTEJCC.IFCID361, 00018200
// DISP=(,CATLG), 00018300
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00018400
// DCB=(RECFM=FB,LRECL=132) 00018500
//IFCID362 DD DSN=DSN!!0.DSNTEJCC.IFCID362, 00018600
// DISP=(,CATLG), 00018700
// UNIT=SYSDA,SPACE=(CYL,(20,2),RLSE), 00018800
// DCB=(RECFM=FB,LRECL=132) 00018900
//* 00019000