|
Sample Report from SMF 61, 65 and 66 Records
| ||||||||||||||||||||||||||||||||||||||||
It's easy to report on SMF data!
| |
|
Spectrum SMF Writer handles the difficult SMF record parsing for you automatically. You just specify which fields you want to see. Spectrum SMF Writer also converts the arcane date and time fields and reformats them into an attractive report. Plus Spectrum SMF Writer even exports SMF data as comma delimited files to use on your PC.
|
The sample SMF report below was created with Spectrum SMF Writer,
the low-cost 4GL SMF report writer.
In this report, we read as input the SMF file and select three types of records:
The report shows the time, system and jobname associated with each change to the catalog. It shows the type of change, information about the entity involved, and the catalog changed. We sorted the report in time order. (We could also have sorted it by entity name, and then time order.)
This is a good example of reporting on 3 different SMF record types. In this case, it was easy because all 3 records have the same layout. This example also shows how to code "tables" to look up the meaning of various codes. That way your report shows meaningful information, not just cryptic codes.
All of this with just a few lines of code!
Why not install a Spectrum SMF Writer trial right now and start making your own SMF reports!
INPUT: SMF61 /* DEFINE SMF FILE AND TYPE 61 RECORDS */
COPY: REC65 /* DEFINE TYPE 65 RECORDS */
COPY: REC66 /* DEFINE TYPE 66 RECORDS */
INCLUDEIF: SMF61RTY=61 OR 65 OR 66
COMPUTE: ACTION = WHEN(SMF61SUB='IN') ASSIGN('INSERT')
WHEN(SMF61SUB='DE') ASSIGN('DELETE')
WHEN(SMF61SUB='UP') ASSIGN('UPDATE')
COMPUTE: TYPE = WHEN(SMF61TYP='A') ASSIGN('NON-VSAM')
WHEN(SMF61TYP='B') ASSIGN('GDG')
WHEN(SMF61TYP='C') ASSIGN('CLUSTER')
WHEN(SMF61TYP='D') ASSIGN('DATASET')
WHEN(SMF61TYP='E') ASSIGN('VSAM EXT')
WHEN(SMF61TYP='F') ASSIGN('FREE SPC')
WHEN(SMF61TYP='G') ASSIGN('AIX')
WHEN(SMF61TYP='H') ASSIGN('GDS')
WHEN(SMF61TYP='I') ASSIGN('INDEX')
WHEN(SMF61TYP='J') ASSIGN('CDG EXDT')
WHEN(SMF61TYP='K') ASSIGN('VVR')
WHEN(SMF61TYP='L') ASSIGN('LIB REC')
WHEN(SMF61TYP='M') ASSIGN('MSTR CAT')
WHEN(SMF61TYP='N') ASSIGN('NONVSAM HDR')
WHEN(SMF61TYP='O') ASSIGN('OAM NONVSAM')
WHEN(SMF61TYP='P') ASSIGN('PAGE SPC')
WHEN(SMF61TYP='Q') ASSIGN('VVR HDR2')
WHEN(SMF61TYP='R') ASSIGN('PATH')
WHEN(SMF61TYP='T') ASSIGN('TRUE NAME')
WHEN(SMF61TYP='U') ASSIGN('USER CAT')
WHEN(SMF61TYP='V') ASSIGN('VOLUME')
WHEN(SMF61TYP='W') ASSIGN('LIB VOL')
WHEN(SMF61TYP='X') ASSIGN('ALIAS')
WHEN(SMF61TYP='Y') ASSIGN('UPGRADE')
WHEN(SMF61TYP='Z') ASSIGN('VVR HDR1')
WHEN(SMF61TYP=X'00') ASSIGN('NRML NONVS')
WHEN(SMF61TYP=X'01') ASSIGN('JES3 REC')
ELSE ASSIGN(SMF61TYP)
COLUMNS:
SMF61TME('TIME')
SMF61CPU('SYSTEM')
SMF61JNM('JOB')
ACTION
TYPE('ENTITY|TYPE')
SMF61ENM('ENTITY NAME')
SMF61CNM('CATALOG NAME' 20)
SORT: SMF61TME
TITLE: 'INTEGRATED CATALOG CHANGES'
TITLE: 'FROM SMF 61, 65 AND 66 RECORDS'
INTEGRATED CATALOG CHANGES
FROM SMF 61, 65 AND 66 RECORDS
ENTITY
TIME SYSTEM JOB ACTION TYPE ENTITY NAME CATALOG NAME
___________ ______ ________ ______ ___________ ____________________________________________ ____________________
11:30:34.46 JA0 DUMPSMF UPDATE GDS SMFDATA.SMFJA0.G4544V00 CATALOG.D83I80
11:31:13.30 JA0 CSQAMSTR INSERT NON-VSAM CSQARC1.CSQA.B0016780 CATALOG.PETUCAT1
11:31:13.83 JA0 CSQAMSTR INSERT NON-VSAM CSQARC1.CSQA.A0016780 CATALOG.PETUCAT1
11:31:14.07 JA0 CSQAMSTR INSERT NON-VSAM CSQARC2.CSQA.B0016780 CATALOG.PETUCAT1
11:31:14.80 JA0 CSQAMSTR INSERT NON-VSAM CSQARC2.CSQA.A0016780 CATALOG.PETUCAT1
11:31:16.90 JA0 IXGLOGR INSERT CLUSTER IXGLOGR.GRP2.CICSVR.RKILPROD.A0010514 CATALOG.PET.IXGLOGR
11:31:16.90 JA0 IXGLOGR INSERT CLUSTER IXGLOGR.GRP2.CICSVR.RKILPROD.A0010514 CATALOG.PET.IXGLOGR
11:31:17.31 JA0 IXGLOGR UPDATE CLUSTER IXGLOGR.GRP2.CICSVR.RKILPROD.A0010440 CATALOG.PET.IXGLOGR
11:31:17.32 JA0 IXGLOGR UPDATE CLUSTER IXGLOGR.GRP2.CICSVR.RKILPROD.A0010440 CATALOG.PET.IXGLOGR
11:31:17.38 JA0 IXGLOGR DELETE CLUSTER IXGLOGR.GRP2.CICSVR.RKILPROD.A0010440 CATALOG.PET.IXGLOGR
11:31:17.38 JA0 IXGLOGR DELETE CLUSTER IXGLOGR.GRP2.CICSVR.RKILPROD.A0010440 CATALOG.PET.IXGLOGR
11:31:25.65 JA0 DUMPSMF UPDATE GDS SMFDATA.SMFJA0.G4544V00 CATALOG.D83I80
11:32:05.80 JA0 DFHSM UPDATE NON-VSAM IMSVS.IMS8.D2006195.T2056084.VCE CATALOG.DSWAT5
11:32:05.81 JA0 DFHSM UPDATE NON-VSAM IMSVS.IMS8.D2006195.T2056084.VCE CATALOG.DSWAT5
11:32:41.11 JA0 JKELLEY INSERT NON-VSAM JKELLEY.SPFLOG4.LIST CATALOG.PETCAT
11:34:48.45 JB0 DUMPSMF UPDATE GDS SMFDATA.SMFJB0.G8531V00 CATALOG.D83I80
11:34:50.10 JA0 IXGLOGR INSERT CLUSTER CQSOFF.CQS.FF.LOGSTRM.A0000351 CATALOG.DSWAT5
11:34:50.10 JA0 IXGLOGR INSERT CLUSTER CQSOFF.CQS.FF.LOGSTRM.A0000351 CATALOG.DSWAT5
11:35:39.01 JB0 DUMPSMF UPDATE GDS SMFDATA.SMFJB0.G8531V00 CATALOG.D83I80
11:35:45.77 JA0 SMSVSAM UPDATE DATASET RLSADSW.RLSKILL.GPVSAM5.DATA CATALOG.PET.RLSADSW
11:35:45.85 JA0 SMSVSAM UPDATE DATASET RLSADSW.RLSKILL.GPVSAM5.DATA CATALOG.PET.RLSADSW
11:35:52.91 JA0 SMSVSAM UPDATE INDEX RLSADSW.RLSKILL.GPVSAM5.INDEX CATALOG.PET.RLSADSW
11:35:52.94 JA0 SMSVSAM UPDATE INDEX RLSADSW.RLSKILL.GPVSAM5.INDEX CATALOG.PET.RLSADSW
11:37:32.45 JB0 DFHSM UPDATE NON-VSAM IMSVS.IMS8.D2006195.T2103158.V09 CATALOG.DSWAT5
11:37:32.45 JB0 DFHSM UPDATE NON-VSAM IMSVS.IMS8.D2006195.T2103158.V09 CATALOG.DSWAT5
11:41:06.66 JA0 U050011 INSERT NON-VSAM U050011.HELLO.C CATALOG.OEUCAT
11:41:07.79 JA0 U050011 DELETE NON-VSAM U050011.HELLO.C CATALOG.OEUCAT
11:41:22.25 JA0 SMSVSAM UPDATE DATASET RLSADSW.RLSKILL.GPVSAM5.DATA CATALOG.PET.RLSADSW
11:41:22.36 JA0 SMSVSAM UPDATE DATASET RLSADSW.RLSKILL.GPVSAM5.DATA CATALOG.PET.RLSADSW
11:41:36.24 JA0 SMSVSAM UPDATE INDEX RLSADSW.RLSKILL.GPVSAM5.INDEX CATALOG.PET.RLSADSW
11:41:36.28 JA0 SMSVSAM UPDATE INDEX RLSADSW.RLSKILL.GPVSAM5.INDEX CATALOG.PET.RLSADSW
11:41:38.23 JA0 U050011 INSERT NON-VSAM U050011.HELLO.C CATALOG.OEUCAT
11:41:41.37 JA0 U050011 DELETE NON-VSAM U050011.HELLO.C CATALOG.OEUCAT
...
*** GRAND TOTAL ( 90 ITEMS)
Home |
Products |
Prices |
Documentation |
30-Day Trials |
Customer Reviews |
Company
| FAQ
| Sample Reports
| SMF Records
Send Your Comments or Questions
