IBM Support

PI94055: DB2 NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • DB2 new function
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 11 for z/OS data sharing users       *
    *                 who use the GDPS Continuous Availability     *
    *                 Zero Data Loss solution.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides new function to      *
    *                      print the Compression Dictionary Data   *
    *                      Set (CDDS).                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The Compression Dictionary Data Set (CDDS) is a VSAM KSDS that
    contains the compression dictionaries for compressed table
    spaces in Db2.  In the source Db2 data sharing group,
    the compression dictionaries are written to the CDDS.
    The CDDS is synchronously mirrored by Peer-to-Peer Remote Copy
    (PPRC) to the proxy Db2 data sharing group.  On the proxy
    Db2 data sharing group, the compression dictionaries are
    read from the CDDS to decompress log record content before
    returning log records to IFI 306 callers.
    
    This APAR provides a new stand-alone utility called DSNJU008
    to print the CDDS.
    
    ________________________________________________________________
    
    
     DSNJU008 (Print CDDS)
    
     The DSNJU008 (Print CDDS) stand-alone utility prints
     the CDDS.
    
     ---------------------------------------------------------------
    
    
     Environment
    
     The DSNJU008 program runs as a batch job.
    
     This utility can be executed either when Db2 is running and
     when it is not running.   It can be executed on the source
     Db2 data sharing group and the proxy Db2 data sharing group.
    
     ---------------------------------------------------------------
    
    
     Authorization required
    
     The user ID of the DSNJU008 job must have requisite RACF
     authorization.
    
     ---------------------------------------------------------------
    
    
     Required data sets
    
     DSNJU008 recognizes DD statements with the following DD names:
    
     SYSUT1
        Specifies and allocates the Compression Dictionary Data Set.
        This statement is required.  It allocates the CDDS.  If the
        CDDS must be shared with a concurrently executing Db2
        online subsystem, use DISP=SHR on the DD statement.
        If the CDDS must be shared on the proxy Db2 data sharing
        group, also specify ROACCESS=(ALLOW,TRKLOCK).
    
     SYSPRINT
        Specifies a data set or print spool class for print output.
        This statement is required.  The logical record length
        (LRECL) is 132.
    
     SYSIN
        Contains the control statement for the print CDDS utility.
    
    
     ---------------------------------------------------------------
    
    
     Running the DSNJU008 utility
    
     Use the following EXEC statement to execute this utility:
     //       EXEC PGM=DSNJU008
    
    ________________________________________________________________
    
    
    
    
    
    
     Syntax and options of the DSNJU008 control statement
    
    
     The DSNJU008 control statement specified in the SYSIN data
     set allows you to specify the records that are printed and
     how they are formatted.
    
    
     DSNJU008 (Print CDDS) syntax diagram
    
    
    
    
      >>-------------------------------------------------------->
         |                      |   |                      |
         ---DBID(hex-constant)---   ---PSID(hex-constant)---
    
    
      >--------------------------------------------------------->
         |                      |   |                      |
         ---PART(hex-constant)---   ---VER(hex-constant)----
    
    
    
            ---DUMP(NO)------         ---SYSTEM(NO)-----
            |               |         |                |
      >--------------------------------------------------------->
            |               |         |                |
            ---DUMP(YES)-----         ---SYSTEM(YES)----
                                      |                |
                                      ---SYSTEM(ONLY)---
    
    
      >--------------------------------------------------------><
         |                            |
         ---LIMIT(integer-constant)----
    
    
    
     Option descritions
    
     The following keywords can be used in the control statement:
    
    
     DBID(hex-constant)
        Specifies a hexadecimal database identifier (DBID).
        DSNJU008 prints only the compression dictionary records
        that are associated with that DBID.  Specify this keyword
        only once in the job.
    
        hex-constant is a hexadecimal value that consist of one
        to 4 characters.  Leading zeros are not required.
    
        You can find the DBID in any of the following ways:
        - The DBID is displayed in many DB2 messages.
        - You can find the DBID in the Db2 catalog for a specific
          objects (for example, in the column that is named DBID
          of the SYSIBM.SYSTABLESPACE catalog table).
    
        - When you select a DBID from a catalog table, the value
          is displayed in decimal format.  Use the SQL HEX function
          in a SELECT statement to convert a DBID to hexadecimal
          format.  The following SQL statements show this use
          of the HEX function:
    
          SELECT NAME, DBNAME, HEX(DBID), HEX(PSID)
          FROM SYSIBM.SYSTABLESPACE
          WHERE NAME = 'table space name'
    
        - You can use the DSN1PRNT utility to format the data sets
          for tables or indexes, and find the DBID in the first
          2 bytes of HPGOBID.
    
     PSID(hex-constant)
        Specifies a hexadecimal page set ID identifier (PSID)
        of a table space.  If you specify PSID, you must also
        specify DBID.  DSNJU008 prints only the compression
        dictionary records that are associated with the DBID and
        the PSID.  Specify this keyword only once in the job.
    
        hex-constant is a hexadecimal value that consist of one
        to 4 characters.  Leading zeros are not required.
    
        Whenever Db2 changes the data, the log record that
        describes the change identifies the database by DBID
        and the table space by page set ID (PSID).  You can find
        the PSID column in the SYSIBM.SYSTABLESPACE catalog table.
    
        When you select the PSID from a catalog table, the value
        is displayed in decimal format.  Use the SQL HEX function
        in your select statement to convert them to hexadecimal.
    
        Alternatively, you can use the DSN1PRNT utility to format
        the data sets for tables and find the PSID in the last
        2 bytes of HPGOBID.
    
        If you specify PSID, you must also specify DBID.
    
     PART(hex-constant)
        Specifies a hexadecimal part number identifier, which is
        associated with a database identifier (DBID) and a data
        page set identifier (PSID).  DSNJU008 prints only the
        records that are associated with the specified part number
        for that identifier.
    
        hex-constant is a hexadecimal value that consist of one
        to 4 characters.  Leading zeros are not required.
    
        Specify this keyword only once in the job.  You must also
        specify the DBID and the PSID keywords that correspond
        to those partitions. If this keyword is not specified,
        records for all partitions associated with the DBID and
        PSID will be printed.
    
    
     VER(integer-constant)
        Specify either 1, 2 or 3 for the CDDS version number.
        Up to 3 versions of the compression dictionary are kept
        in the CDDS for an object.  Version 1 is the most recent
        compression dictionary.  DSNJU008 prints only the
        records that are associated with the specified CDDS version
        number.
    
        Specify this keyword only once in the job.  If this
        keyword is not specified, records for all CDDS version
        numbers will be printed.
    
    
     DUMP(YES|NO)
        Specify whether to generate a hexadecimal output of each
        compression dictionary record.
    
        Specify this keyword only once in the job.
    
        The default value is DUMP(NO)
    
        (YES)
            Generates a hexadecimal output of the compression
            dictionary record.
    
        (NO)
            Generates only a summary line of the compression
            dictionary record.
    
    
     SYSTEM(YES|NO|ONLY)
        Specify whether to generate a hexadecimal output of
        system records in the CDDS.
    
        Specify this keyword only once in the job.
    
        The default value is SYSTEM(NO)
    
        (YES)
            Generates a hexadecimal output of the system records
            in the CDDS.
    
        (NO)
            The system records in the CDDS are not printed.
    
        (ONLY)
            Generates only the hexadecimal output of the sytem
            records in the CDDS.  No compression dictionary
            records will be printed.
    
    
     LIMIT(integer-constant)
        Specifies an integer-constant to limit the number of lines
        of output that is generated by DSNJU008.
    
        integer-constant is an integer value that consists of one
        to 10 characters.  The maximum value that can be specified
        is 4294967295.  Leading zeros are not required.
    
        The default value is LIMIT(4294967295).
    
    
    ________________________________________________________________
    
    
    
    
    
    
     Sample DSNJU008 control statement
    
        Use the sample control statements as models for developing
        your own DSNJU008 control statements.
    
    
        //PLM8   EXEC PGM=DSNJU008
        //STEPLIB  DD DSN=USER.TESTLIB,DISP=SHR
        //         DD DSN=DB2A.SDSNLOAD,DISP=SHR
        //SYSPRINT DD SYSOUT=*
        //SYSUT1 DD DSN=TEST.CDDS,DISP=SHR
        //SYSIN  DD *
    
          DBID(011D) PSID(0002) VER(1)
    
    
    ________________________________________________________________
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI94055

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-02-20

  • Closed date

    2018-03-14

  • Last modified date

    2018-04-03

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

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

    UI54457

Modules/Macros

  •    DSNFMNFM DSNFPMSG DSNFSAMG DSNJUMT0 DSNJU008
    DSNJU08A DSNJU08E DSNRJTCV HDBBB10J
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI54457

       UP18/03/15 P F803

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":"11.0","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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 April 2018