Go to Home Page
Questions?
Call 1-800-572-5517
 
  Go to Home Page  
  See all products
  See price schedules
  See manuals, tutorials, articles
  Download a free 30-day trial
  See user testimonials
  About Pacific Systems Group
 
 
SMF Tools
  See SMF Record Layouts
  See Sample SMF Reports
  Learn How to Export SMF Data
  Download Free SMF Reporting Software (30 days)
 
One of the greatest SMF record parsing programming languages I've ever seen. Chief, Large Systems Services Branch, NIH
  Choose Spectrum Writer to add 4GL to your product
  Free 60-Page Book (PDF) - How to Make an SMF Report
Spectrum DCOLLECT Reporter - the 4GL DCOLLECT Report Writer.

Spectrum SMF Writer - the 4GL SMF Report Writer.

SMF Type 61 Record

This table shows the record layout for type 61 SMF records
(Integrated Catalog Facility Define Activity).

List of other SMF record layouts available.
List of sample SMF reports.

Purpose: Record type 61 is written during any processing that results in a DEFINE request to Catalog Management Services, such as:

  • IDCAMS DEFINE
  • IEHPROGM CATLG

One type 61 record is written for each record inserted or updated in a catalog. Record type 61 identifies the entry being defined and the catalog in which the catalog record is written and gives the new or updated catalog record. It identifies the job by job log and user identifiers.

It's easy to report on SMF 61 data! (Jump to sample reports)

SMF Spectrum Writer
We have a low-cost 4GL report writer especially for SMF files. It's called Spectrum SMF Writer.

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 can export SMF data as comma delimited files to use on your PC.
 
Try It FREE Now!

SMF Type 61 Record -- Integrated Catalog Facility Define Activity
Offset
(Dec.)
Offset
(Hex)
NameLengthFormatDescription
00SMF61LEN2binary
Record length. This field and the next field (total of four bytes) form the RDW (record descriptor word). See “Standard SMF Record Header” on page 13-1 for a detailed description.
22SMF61SEG2binary
Segment descriptor (see record length field).
44SMF61SYS1binary
System indicator: Bit Meaning When Set 0-2 Reserved 3-6 Version indicators* 7 Reserved.*See “Standard SMF Record Header” on page 13-1 for a detailed description.
55SMF61RTY1binary
Record type 61 (X'3D').
66SMF61TME4binary
Time since midnight, in hundredths of a second, that the record was moved into the SMF buffer.
10ASMF61DTE4packed
Date when the record was moved into the SMF buffer, in the form 0cyydddF. See “Standard SMF Record Header” on page 13-1 for a detailed description.
14ESMF61CPU4EBCDIC
System identification (from the SID parameter).
1812SMF61SBS4--
Reserved.
2216SMF61SUB2EBCDIC
The action taken on the catalog entry; valid values are: IN (INSERT) DE (DELETE) UP (UPDATE)
2418SMF61POF4binary
Offset of product section from start of record, including record descriptor word (RDW).
281CSMF61PLN2binary
Length of product section.
301ESMF61PNO2binary
Number of product sections.
3220SMF61DOF4binary
Offset of data section from start of record, including record descriptor word (RDW).
3624SMF61DLN2binary
Length of data section.
3826SMF61DNO2binary
Number of data sections.
4028SMF61VER2EBCDIC
Version of the type 61 records.
422ASMF61PNM8EBCDIC
Catalog management product identifier.
5032SMF61JNM8EBCDIC
Job name. The job log identification consists of the job name, time, and date that the reader recognized for the JOB card (for this job). If a system task caused the record to be written, the job name and user identification fields contain blanks and the time and date fields contain zeros.
583ASMF61RST4binary
Time since midnight, in hundredths of a second, the reader recognized the JOB card (for this job).
623ESMF61RDT4packed
Date reader recognized the JOB card for this job, in the form 0cyydddF. See “Standard SMF Record Header” on page 13-1 for a detailed description.
6642SMF61UID8EBCDIC
User-defined identification field (taken from common exit parameter area, not from USER=parameter on job statement).
744ASMF61FNC1--
Reserved.
754BSMF61CNM44EBCDIC
Name of catalog in which entry is defined.
11977SMF61TYP1EBCDIC
Entry type identifier. For a description of this field, see the SMF60TYP field on page 13-255.
12078SMF61ENM44EBCDIC
Entry name.
164A4SMF61NNM44--
Reserved.
208D0SMF61CRCvariablebinary
New catalog record for defined entry (the length of this record is contained in the first two bytes of this field).

The table above is based on the description provided by IBM in its "MVS Systems Management Facilities (SMF)" manual.

Sample Report from SMF 61, 65 and 66 Records
Showing Integrated Catalog Activity


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:

  • SMF 61 record - Integrated Catalog Facility Define Activity
  • SMF 65 record - Integrated Catalog Facility Delete Activity
  • SMF 66 record - Integrated Catalog Facility Alter Activity

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!

These Spectrum SMF Writer Statements:

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'           
    

 

Produce This SMF Report:

                                            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)

See other sample SMF reports.

Copyright 2017.
Pacific Systems Group.
All rights reserved.


Spectrum Writer 4GL - the economical alternative to SAS, Easytrieve, DYL-280...

Home | Products | Prices | Documentation | 30-Day Trials | Customer Reviews | Company | FAQ | Sample Reports | SMF Records
Send Your Comments or Questions