IBM Support

PH29768: DB2 INCORRECT OUTPUT WHEN ACCESSING SYSTEM ASSESSMENT TABLES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 incorrect output when accessing system assessment tables
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2zAI users of Distributed Connection                   *
    * Control (DCC)                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When processing IFCID 402 traces for                         *
    * a default profile, some traces for                           *
    * varying IP addresses might not be                            *
    * processed correctly for DCC.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    A default profile can be associated with any number of IP
    addresses. However, Db2 only used the profile ID and did
    not include the IP address when determining what trace
    information to pass on to DCC.
    

Problem conclusion

  • Db2 was modified to use both the profile ID and IP address
    when determining what data to insert into the table used for
    DCC.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH29768

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-09-22

  • Closed date

    2020-10-26

  • Last modified date

    2020-12-01

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

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

    UI72243

Modules/Macros

  • DSNFCDIR DSNWDFND DSNXOSTM DSNWAKIS DSNXONFE DSNWAKI2 DSNFWDIR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI72243

       UP20/11/03 P F011

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0"}]

Document Information

Modified date:
02 December 2020