IBM Support

PI65468: CHANGE MANAGEMENT DB SET TO NO: ENABLE CM NOT SET TO NO.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Even though the product was configured with CM set to N, the
    option to use CM is still shown in the primary panel.
    If creating the CM database is set to N in the TCz
    configuration set up, the AdminTool Proclib field is still a
    required field.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool for         *
    *                 z/OS who use IBM Tools Customizer            *
    *                 for z/OS.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: A SQLCODE = -204 / SQLCODEN204 is       *
    *                      observed because the CM objects         *
    *                      do not exist.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When setting parameter 'Change Management database'
    to 'NO' and 'Enable CM on DB2 Admin Tool primary menu'
    to 'YES' during the customization process, the option
    'CM' appears on panel ADB2 'DB2 Administration
    Menu' which will result in SQLCODE = -204 /
    SQLCODEN204 because the CM objects do not exist:
    
    
    DSNT408I SQLCODE = -204, ERROR:  >schema<.ADBCHG
    IS AN UNDEFINED NAME
    DSNT418I SQLSTATE   = 42704
    SQLSTATE RETURN CODE
    

Problem conclusion

  • The problem has been resolved. When setting the product
    parameter 'Change Management database' to 'NO', the values
    of product/DB2 parameter 'Enable CM on DB2 Admin Tool
    primary menu' are set to 'NO' and the ADBCUST job will put
    'NO' values into the ADBTPARM table regardless of the value
    entered for the 'Enable CM on DB2 Admin Tool primary menu'
    setting.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI65468

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    B20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-07

  • Closed date

    2017-01-04

  • Last modified date

    2017-02-01

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

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

    UI43664 UI43665

Modules/Macros

  •    ADBCUST
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB10 PSY UI43664

       UP17/01/07 P F701

  • RB20 PSY UI43665

       UP17/01/07 P F701

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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021