IBM Support

PH50072: CODE TO SUPPORT NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Code to support new function
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS and Db2 13 for z/OS                      *
    * users looking for migration readiness                        *
    * information and users of the Db2-supplied                    *
    * stored procedure SYSPROC.GET_CONFIG.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * It is not easy for Db2 users to                              *
    * determine the migration readiness                            *
    * status of a stand-alone Db2 subsystem                        *
    * or a Db2 data sharing group.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Customers have long expressed the desire to be able to easily
    determine if their Db2 subsystems or groups are 'ready' to
    migrate to the next release of Db2. They can easily
    tell if their systems are at the right function level for a
    release migration but that is not the case for maintenance and
    code levels.
    Db2 users are told that the fallback SPE (System Program
    Enhancement) APAR must be on a subsystem and each
    member in a data sharing environment with Db2 started before
    they'll be eligible to migrate to the n+1 release of Db2. But
    determining if the fallback SPE APAR is on everywhere it needs
    to be can be a time consuming and error prone process.
    

Problem conclusion

Temporary fix

Comments

  • This APAR modifies the -DISPLAY GROUP DETAIL Db2 command
    output as follows:
    o Adds a MIGRATION READINESS REPORT.
    o Removes obsolete Sysplex Query Parallelism information
    (PARALLEL COORDINATOR and PARALLEL ASSISTANT).
    This APAR also modifies the Db2-supplied stored procedure
    SYSPROC.GET_CONFIG to support the modified -DISPLAY GROUP
    DETAIL command output.
    The new MIGRATION READINESS REPORT in the modified -DISPLAY
    GROUP DETAIL command output aims to provide real-time
    information about the migration readiness of the subsystem
    or data sharing group. This report indicates if a subsystem
    and if each member in a data sharing group has on the right
    level of code and fallback SPE APAR to be able to migrate to
    the next Db2 release. After the subsystem and active data
    sharing group member information, a summary 'MIGRATION
    READINESS STATUS:' line will indicate if a sybsystem or a
    data sharing group is ready for the migration. If a
    subsystem or data sharing group is not ready to migrate to
    the next Db2 release, an additional 'REASON:' line will be
    displayed in the output to indicate the reason that the
    subsystem or data sharing group is not yet ready to migrate.
    In a data sharing environment, the -DISPLAY GROUP DETAIL
    command output differs depending on whether this APAR
    is applied on a member where the command was executed.
    o When the -DISPLAY GROUP DETAIL command is executed on a
      member with this APAR applied, the MIGRATION READINESS
      REPORT in the command output will show complete and
      accurate results for all of the active members in the data
      sharing group, even those that do not have this APAR
      applied.
    o On the other hand, when the -DISPLAY GROUP DETAIL command
      is executed on a member where this APAR is not applied,
      the command will continue to return the prior -DISPLAY
      GROUP DETAIL output (before this APAR), which does not
      have the MIGRATION READINESS REPORT and which contains the
      obsolete Sysplex Query Parallelism information
      (Parallel Coordinator and Parallel Assistant).
    Because the -DISPLAY GROUP DETAIL output is changed by this
    APAR, the SYSPROC.GET_CONFIG stored procedure is modified
    with the following changes to the output XML document that it
    returns:
    o Information contained in the new MIGRATION READINESS REPORT
      of the -DISPLAY GROUP DETAIL command output added.
    o Obsolete Parallel Coordinator and Parallel Assistant
      entries removed.
    These changes affect the following sections of the GET_CONFIG
    XML output document:
    o Common Data Sharing Group Information section:
      The following two new dictionary entries will be inserted
      before the SCA Structure Size dictionary entry. These
      new dictionary entries are derived from the MIGRATION
      READINESS REPORT found in the -DISPLAY GROUP DETAIL command
      output.
      o Migration Readiness Status
      o Migration Readiness Reason
    o DB2 Subsystem Status Information section:
      New dictionary entries for migration readiness will replace
      the following two obsolete dictionary entries:
      o Parallel Coordinator
      o Parallel Assistant
      The following new dictionary entries for migration
      readiness are derived from the new MIGRATION READINESS
      REPORT in the -DISPLAY GROUP DETAIL command output:
      o Non-data sharing group, major_version = 2, and
        minor_version = 0:
        o Code Level
        o SPE Apar
        o Migration Eligible
        o Migration Readiness Status
        o Migration Readiness Reason
      o Otherwise:
        o Code Level
        o SPE Apar
        o Migration Eligible
    For more information, see the online product documentation:
    o Db2 12 for z/OS:
    https://www.ibm.com/docs/en/db2-for-zos/12?topic=12-2023-
    new-function-apars#db2z_12_newfunctionapars2023__ph50072
    o Db2 13 for z/OS:
    https://www.ibm.com/docs/en/db2-for-zos/13?topic=13-2023-
    new-function-apars#db2z_13_newfunctionapars2023__ph50072
    

APAR Information

  • APAR number

    PH50072

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-10-09

  • Closed date

    2023-06-02

  • Last modified date

    2023-07-03

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

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

    UI92094 UI92095

Modules/Macros

  • DSNUECM2 DSNXIENF DSNADMGC DSNGEDLC DSNXKFUN DSNFMDIR DSNUECM0
    DSNURORG DSNUECMJ DSNUECMI DSNUGCCA DSN@DMGW DSN@DMGC DSNFCDIR
    DSNADMGW DSNRRPRC DSN7GCMD DSNF7DIR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI92094

       UP23/06/13 P F306

  • RD10 PSY UI92095

       UP23/06/13 P F306

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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M","label":"DB2 for z\/OS"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"12.0"}]

Document Information

Modified date:
03 July 2023