PI54473: TEST DBRM WILDCARD INCORROUT REPORTS NOMATCH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer reports that when specifying a wildcard character on
  the TEST DBRM command, Path Checker generates inconsistent
  results when the specific DBRM is specified
  on the TEST DBRM command.
  
  For example the following two scenarios:
  Running Path Checker with the following command:
  
    TEST DBRM * AS PACKAGE VERCOL1.* IN SYSADM.PLAN_TABLE
  
  The SYSPRINT show ACCESS PATH changes for
      COLLID - VERCOL1           .PGMV1T2
  
  But running Path Checker specifying DBRM PGMV1T2 as
  follows:
  
    TEST DBRM PGMV1T2 AS PACKAGE VERCOL1.* IN
                           SYSADM.PLAN_TABLE
  
  The SYSPRINT shows no ACCESS PATH changes for
  

Local fix

• Until PTF is applied, do not use "TEST DBRM *" as a wild card
  test of all DBRMs.
  Instead use explicit TESTs, specifying the DBRM name in full.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Path Checker z/OS.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Customer reports that when specifying   *
  *                      a wildcard character on the TEST DBRM   *
  *                      command, Path Checker generates         *
  *                      inconsistent results when the specific  *
  *                      DBRM is specified on the TEST DBRM      *
  *                      command.                                *
  *                      For example the following two           *
  *                      scenarios:                              *
  *                      Running Path Checker with the           *
  *                      following command:                      *
  *                                                              *
  *                        TEST DBRM * AS PACKAGE VERCOL1.* IN   *
  *                       SYSADM.PLAN_TABLE                      *
  *                                                              *
  *                      The SYSPRINT show ACCESS PATH changes   *
  *                      for                                     *
  *                          COLLID - VERCOL1           .PGMV1T2 *
  *                                                              *
  *                      But running Path Checker specifying     *
  *                      DBRM PGMV1T2 as follows:                *
  *                                                              *
  *                        TEST DBRM PGMV1T2 AS PACKAGE          *
  *                       VERCOL1.* IN  SYSADM.PLAN_TABLE        *
  *                                                              *
  *                      The SYSPRINT shows no ACCESS PATH       *
  *                      changes.                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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

•    CKPPTHCK
  

Fix information

• Fixed component name

  DB2 PATH CHECKE

• Fixed component ID

  5655E3901

Applicable component levels

• R420 PSY UI34832

     UP16/01/29 P F601

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.