PK54582: EXPLAINS DB2 V8 NFM PACKAGES WHEN RUNNING DB2PE V210 FPEY0374I NO PACKAGES FOUND FOR: DM_NMLPROD_COLLID...

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running Batch explain as follows:
  EXPLAIN
              PACKAGE(DBP2.DM_NMLPROD_COLLID.DMVWNRD.(-0))
              SSID(DBP2)
              LEVEL(DETAIL)
              INDEX(ALL)
              HOSTVAR(YES)
              ACCTYPE(ALL)
              FORCE(YES)
              FORMAT(YES)
  EXEC
  results in message:
  FPEY0374I  NO PACKAGES FOUND FOR: DM_NMLPROD_COLLID...
  when running db2 v8 in NFM
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 - Explain                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running the Batch Explain command       *
  *                      EXPLAIN PACKAGE(collid.package.(-0))    *
  *                      with a full qualified package name      *
  *                      in a DB2 V8 NFM environment             *
  *                      results in message:                     *
  *                      FPEY0374I NO PACKAGES FOUND FOR: *      *
  *                      This error is caused by trailing blanks *
  *                      in the system catalog table SYSPACKAGE  *
  *                      in columns COLLID and NAME.             *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  Running the Batch Explain command
  EXPLAIN PACKAGE(collid.package.(-0))
  with a full qualified package name in a DB2 V8 NFM environment
  results in message:
  FPEY0374I NO PACKAGES FOUND FOR: *
  This error is caused by trailing blanks in the system catalog
  table SYSPACKAGE in columns COLLID and NAME.
  

Problem conclusion

• Trailing blanks in the system catalog table SYSPACKAGE are
  taken into consideration.
  
  KEYWORDS: EXPLAIN DB2-V8-NFM SYSPACKAGE TRAILING-BLANKS
            FPEY0374I
  

Temporary fix

Comments

APAR Information

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

  PK54552

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

  UK30276 UK30277

Modules/Macros

•    DGO@TPG1 DGO@TPG2 DGO@TPG3 DGO@TPG4 DGO@TPG5
  DGO@TPM1 DGO@TPM2 DGO@TPM3 DGO@TPM4 DGO@TPM5 DGO@TSM4 DGOYTPG1
  DGOYTPG2 DGOYTPG3 DGOYTPG4 DGOYTPG5 DGOYTPM1 DGOYTPM2 DGOYTPM3
  DGOYTPM4 DGOYTPM5 DGOYTSM4
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK30276

     UP07/10/16 P F710

• R410 PSY UK30277

     UP07/10/16 P F710

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.