IBM Support

OA58495: DB2 NUMERIC TABLE IDENTIFIERS ARE NOT RESOLVED TO TABLE NAMES FOR IFCIDS 143 AND 144

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 numeric table identifiers are not resolved to table names
    for IFCIDs 143 and 144, even when the CKFREEZE contains DB2
    Unload data.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of zSecure Audit exploiting SMF        *
    *                 reports for DB2 (interactive option EV.4 or  *
    *                 a newlist with selection on DB2 SMF          *
    *                 records).                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: zSecure Audit fails to resolve DB2      *
    *                      table names (when available in the      *
    *                      system data (CKFREEZE)) from their      *
    *                      numeric identifiers for IFCID 143       *
    *                      (Audit first write) and 144 (Audit      *
    *                      first read) and reports the numeric     *
    *                      identifiers themselves.                 *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF provided.                      *
    ****************************************************************
    When a CKFREEZE data set processed by zSecure Audit contains all
    necessary DB2 information regarding DB2 tables, the program
    still does not resolve the DB2 table names while processing SMF
    reports and displays the numeric table identifiers from SMF
    records instead (the CARLa field concerned is DB2_OBJECT for
    newlist type SMF).
    

Problem conclusion

  • zSecure Audit has been modified so that it resolves the DB2
    table names properly for SMF reports. Please note that the
    RECORDDESC field still for the DB2 related events still might
    report the numeric table identifiers unless a DB2_OBJECT field
    is also referred by a newlist type SMF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    OA58495

  • Reported component name

    ZSEC BASE,ADMIN

  • Reported component ID

    5655T0100

  • Reported release

    231

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-15

  • Closed date

    2019-11-27

  • Last modified date

    2019-11-30

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

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

    UJ01445 UJ01446

Modules/Macros

  • CKADB2   CKRCFSU  CKRINMO  GKRCFSU  GKRDB2   GKRINMO
    

Fix information

  • Fixed component name

    ZSEC BASE,ADMIN

  • Fixed component ID

    5655T0100

Applicable component levels

  • R231 PSY UJ01445

       UP19/11/28 P F911

  • R240 PSY UJ01446

       UP19/11/28 P F911

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":"BU048","label":"IBM Software"}, "Product":{"code":"SSCE68R","label":"zSecure Admin"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"231","Edition":""}]

Document Information

Modified date:
30 November 2019