PM27872: SMF DECOMPRESSION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SMF decompression                                       (DM1495)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 Version 10 for z/OS who     *
  *                 generate compressed DB2 SMF records.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: This PTF provides a SMF decompression   *
  *                      sample program.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Version 10 for z/OS, the subsystem parameter SMFCOMP can
  be used to turn on compression of DB2 SMF records.  The default
  value for SMFCOMP is OFF.
  
  This PTF adds DSNTSMFD to V10.  DSNTSMFD is a DB2-supplied
  sample application for decompressing compressed DB2 SMF
  records. It accepts an SMF data set in standard SMF format and
  produces an output SMF data set.  All SMF record types are
  accepted, but only compressed type 100 (DB2 Statistics), type
  101 (DB2 Accounting), type 102 (DB2 Performance) records
  generated by DB2 are decompressed. All other records (including
  uncompressed DB2 records) are copied unchanged to the output
  SMF data set.
  
  ==============
  About DSNTSMFD
  ==============
  DSNTSMFD can process input SMF records that contain records
  from up to 512 DB2 subsystems.
  
  DSNTSMFD accepts SMF records from any release of DB2.  Only
  systems with the z/OS CSCESRV macro available will be able to
  use DSNTSMFD to decompress records.  Only compressed SMF
  records from DB2 V10 and beyond are eligible for decompression.
  
  DSNTSMFD produces an end-of-job summary, which is written to
  the SYSPRINT DD:
    * Total SMF records read
    * Total DB2 records read
    * Total DB2 compressed records read
    * Total DB2 compressed records decompressed
    * Total non-DB2 records read
    * Aggregate size of all input records
    * Aggregate size of all input DB2 records
    * Aggregate size of all input DB2 compressed records
    * Aggregate size of all output DB2 records
    * Aggregate size of all DB2 expanded records
    * Aggregate size of all non-DB2 input records
    * Percentage saved using compression
    * Details of records by DB2 subsystem
  
  The SYSPRINT DD is also the destination for diagnostic and
  warning messages generated by DSNTSMFD.
  
  DSNTSMFD requires the following DD statements:
    * SMFINDD (input)
        The SMFINDD DD must specify one or more data sets that
        contain DB2 trace records in standard SMF format.  All
        SMF records are acceptable, but DSNTSMFD will only
        attempt to decompress SMF type 100, 101, and 102 records.
    * SMFOUTDD (output)
        The SMFOUT DD specifies the output data set.  Non-type
        100, 101, and 102 SMF records are written to this data
        set; if the decompression service (CSRCESRV) is not
        available, the compressed records are copied and a
        warning message is produced.
    * SYSPRINT (output) Contains the end of job summary report
      plus diagnostic messages for any DSNTSMFD processing
      exceptions.  All messages are documented in the DB2 for
      z/OS Messages manual.
  
  ================
  Running DSNTSMFD
  ================
  DSNTSMFD is designed for execution in the z/OS batch process.
  It has no dependency on DB2 other than as a source of the SMF
  records.
  
  ===================
  Sample job DSNTEJDS
  ===================
  For convenience, sample job DSNTEJDS provides the basic JCL
  framework needed to assemble and execute DSNTSMFD.  DSNTEJDS
  is not intended to be run as part of the DB2 Installation
  Verification Procedure (IVP).  Note that DB2 does not provide
  sample SMF records.
  
  See the DSNTEJDS prolog for directions on how to customize it
  for use at your site.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK64597

Modules/Macros

• DSNTEJDS DSNTSMFD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK64597

     UP11/02/22 P F102

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.