IBM Support

PM20417: DISABLE THE BUILD OF TRUSTED CONTEXT CACHE WHEN DB2 IS STARTED WITH ZPARM DEFER ALL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • DB2DDF DDFL09
    Disable the build of Trusted Context cache when DB2 is started
    with ZPARM DEFER ALL.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 9 for z/OS users of the RECOVER utility  *
    *                 for DB2 directory and catalog objects for    *
    *                 disaster recovery, that start DB2 with       *
    *                 DEFER ALL specified.                         *
    *                                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: MSGDSNT376I                             *
    *                      CORRELATION-ID=022.TCCBLD02             *
    *                      RC00C900BA TYPE00002000                 *
    *                      NAME DSNDB01 .DBD01 encountered by      *
    *                      RECOVER utility with the PARALLEL       *
    *                      option specified on directory           *
    *                      table space DSNDB01.DBD01, when DB2     *
    *                      is started with DEFER ALL.              *
    *                      This happens after DELETE/DEFINE        *
    *                      CLUSTER for DSNDB01.DBD01               *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DB2 was started with DEFER ALL to recover the DSNDB01.DBD01
    table space. The RECOVER utility with the PARALLEL option
    specified to recover table space DSNDB01.DBD01 triggered the
    trusted context cache to be built, which resulted in the
    message like the following:
        DSNT376I CORRELATION-ID=022.TCCBLD02 RC00C900BA TYPE2000
    This occurred in a disaster recovery situation after the
    clusters for the directory and catalog objects were deleted
    and defined.
    
    The trusted context cache build service tried to access the
    trusted context catalog tables to build the cache, which
    requires access to DSNDB01.DBD01. However, the RECOVER utility
    had previously acquired a drain of all readers and writers on
    DSNDB01.DBD01, this resulted in the timeout condition.
    

Problem conclusion

Temporary fix

Comments

  • The trusted context cache will not be built if the DB2
    subsystem has been started with the DSNZPARM option to
    DEFER ALL objects. Hence, trusted connections will not
    be available.
    

APAR Information

  • APAR number

    PM20417

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-11

  • Closed date

    2010-10-19

  • Last modified date

    2011-03-18

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

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

    UK61478

Modules/Macros

  • DSNLTACC DSNXACTM DSNXATCI DSNXECNT DSN3ID30
    DSN3TC30
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK61478

       UP10/11/04 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.

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

Document Information

Modified date:
18 March 2011