PH12920: ENHANCE ADMIN_DS_LIST TO RETURN DATA SET ENCRYPTION KEY LABEL

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Enhance ADMIN_DS_LIST to return data set encryption key label
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of the                             *
  * Db2-supplied stored procedure                                *
  * SYSPROC.ADMIN_DS_LIST are affected                           *
  * by this change.                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Enhance SYSPROC.ADMIN_DS_LIST to                             *
  * return a flag indicating whether a                           *
  * data set is encrypted, and if it is                          *
  * encrypted, return its encryption key                         *
  * label too.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Enhance SYSPROC.ADMIN_DS_LIST to return a flag indicating
  whether a data set is encrypted, and if it is encrypted,
  return its encryption key label too.
  

Problem conclusion

Temporary fix

Comments

• SYSPROC.ADMIN_DS_LIST is enhanced to return a flag indicating
  whether a data set is encrypted, and if it is encrypted,
  return its encryption key label too.  These information are
  returned in the two new result table columns, ENCRYPT_TYPE
  and ENCRYPT_KEY_LABEL, as described in the Table 1.
  Table 1  ADMIN_DS_LIST Result Set Row CGTT SYSIBM.DSLIST
  ------------------------------------------------------------
  | Column            |    Data     |          Content       |
  |  Name             |    Type     |                        |
  ============================================================
  | ENCRYPT_TYPE      | CHAR(2)     | Encryption type.       |
  |                   | FOR BIT     | If the data set is     |
  |                   | DATA        | encrypted, x'0100'     |
  |                   |             | is returned.           |
  |                   |             | Otherwise, x'FFFF'     |
  |                   |             | is returned.           |
  | ENCRYPT_KEY_LABEL | CHAR(64)    | Encryption key label.  |
  |                   |             | If the data set is not |
  |                   |             | encrypted, 64 bytes of |
  |                   |             | hex '40' are returned. |
  ------------------------------------------------------------
  Db2-supplied job DSNTESR (DDL and BIND statements used by
  job DSNTIJRT) is also updated to add the two new encryption
  columns in CGTT SYSIBM.DSLIST:
  CREATE GLOBAL TEMPORARY TABLE SYSIBM.DSLIST
    ( DSNAME                    VARCHAR(44)   NOT NULL
    , CREATE_YEAR               INTEGER       NOT NULL
    , CREATE_DAY                INTEGER       NOT NULL
    , TYPE                      INTEGER       NOT NULL
    , VOLUME                    CHAR(6)       NOT NULL
    , PRIMARY_EXTENT            INTEGER       NOT NULL
    , SECONDARY_EXTENT          INTEGER       NOT NULL
    , MEASUREMENT_UNIT          CHAR(9)       NOT NULL
    , EXTENTS_IN_USE            INTEGER       NOT NULL
    , DASD_USAGE                CHAR(8)       FOR BIT DATA
                                              NOT NULL
    , HARBA                     CHAR(6)       FOR BIT DATA
                                              NOT NULL
    , HURBA                     CHAR(6)       FOR BIT DATA
                                              NOT NULL
    , ERRMSG                    VARCHAR(256)
    , ENCRYPT_TYPE              CHAR(2)       FOR BIT DATA
    , ENCRYPT_KEY_LABEL         CHAR(64)
    )
    CCSID EBCDIC ;
  

APAR Information

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

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

  UI67417

Modules/Macros

• DSNADMDL DSNTESR  DSN@RIN  DSN@DMDL DSNADMDT DSNTRIN  DSNADMAB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI67417

     UP20/01/25 P F001

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.