PM23243: DISPLAY GROUP COMMAND OUTPUT CHANGES 10/12/08 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DISPLAY GROUP command output changes
  
  DB2MIGV10/K  DB2COEXIST/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users *
  *                 that:                                        *
  *                                                              *
  *                 (1) Use the -DISPLAY GROUP command           *
  *                                                              *
  *                 or                                           *
  *                                                              *
  *                 (2) Use the following DB2-supplied           *
  *                     stored procedures:                       *
  *                      (a) SYSPROC.ADMIN_COMMAND_DB2           *
  *                      (b) SYSPROC.ADMIN_INFO_SYSPARM          *
  *                      (c) SYSPROC.ADMIN_INFO_HOST             *
  *                      (d) SYSPROC.GET_CONFIG                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DISPLAY GROUP command output        *
  *                      displayed an incorrect MODE value       *
  *                      when the data sharing group is in       *
  *                      coexistence.                            *
  *                                                              *
  *                      In a data sharing group with mixed      *
  *                      releases, when SYSPROC.ADMIN_COMMAND_   *
  *                      DB2 and SYSPROC.ADMIN_INFO_SYSPARM are  *
  *                      executing in a DB2 version 8 or 9       *
  *                      member, and the request is to be        *
  *                      executed at a V10 member, the request   *
  *                      is not processed. Message DSNA601I is   *
  *                      returned by ADMIN_COMMAND_DB2 to        *
  *                      indicate that the DB2 member is         *
  *                      invalid, and DSNA635I is returned by    *
  *                      ADMIN_INFO_SYSPARM to indicate that     *
  *                      the DB2 version is not supported.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a DISPLAY GROUP command is issued on any subsystem, the
  MODE of the subsystem itself could be displayed.  This may be
  misleading in data sharing groups with members at different
  DB2 releases.
  
  In a data sharing group with mixed releases, when
  SYSPROC.ADMIN_COMMAND_DB2 and SYSPROC.ADMIN_INFO_SYSPARM are
  executing in a DB2 version 8 or 9 member, these procedures
  check the DB2 version of the member where the request is to be
  executed. If the version of the target DB2 member is not 8 or
  9, the request is rejected.
  

Problem conclusion

• This APAR will change the output of the DISPLAY GROUP command
  in 3 ways:
  
  (1) The MODE field will now display "X " under these scenarios:
  
      (a) If not all members of the data sharing group are on the
          same DB2 release level (i.e. the group is in
          coexistence)
  
      (b) If a DB2 subsystem was previously at a higher DB2
          release level.  (i.e. a fallback was performed)
  
  (2) The GROUP LEVEL field name will be changed to CATALOG LEVEL
  
  (3) The CATALOG LEVEL field will now display a meaningful value
      such as '910' (for DB2 9) when the DISPLAY GROUP command is
      issued on non data sharing subsystems.  Previously, a value
      of '...' was displayed.
  
  For more information on the DISPLAY GROUP changes, please refer
  to the information about -DISPLAY GROUP in the Information
  Management Software for z/OS Solutions information center.
  
  This APAR also contains changes to the following DB2-supplied
  stored procedures:
  
  (1) SYSPROC.ADMIN_COMMAND_DB2 and SYSPROC.ADMIN_INFO_SYSPARM
      to support DB2 10 for z/OS
  
  (2) SYSPROC.ADMIN_COMMAND_DB2 and SYSPROC.GET_CONFIG to handle
      the change of the GROUP LEVEL field name to CATALOG LEVEL
      in the -DISPLAY GROUP output.
  
  ADDITIONAL KEYWORDS: MSGDSNA601I , MSGDSNA635I , DB2DSHR
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• DSN@DMCD DSN@DMGW DSN@DMIZ DSNADMCD DSNADMGW
  DSNADMIZ DSNFMDIR DSNF7DIR DSNF7DTA DSNWZIFA DSNXLDBD DSN7GCMD
  HDB8810J HDB9910J
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK59282

     UP10/12/29 P F012

• R910 PSY UK59283

     UP10/12/29 P F012

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.