IBM Support


A fix is available


You can track all active APARs for this component.


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
    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


APAR Information

  • APAR number


  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID


  • Reported release


  • Status


  • PE




  • Special Attention


  • Submitted date


  • Closed date


  • Last modified date


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

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




Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID


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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 March 2011