PK56140: GEN ON QUOTED VIEW NAMES RESULTS WITH RC=16 UNRESOLVED SYMBOL. INDEX =001

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN on SYSIBM.SYSJARDATA - gives errors
  The definition of table SYSIBM  .SYSJARDATA is not complete in
  DB2. The table will be skipped.
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: In R710 and R720, when User runs GEN on      *
  *                 quoted view names results in unresolved      *
  *                 symbol.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN on quoted view names results in     *
  *                      'Unresolved  symbol  Index = 0001',     *
  *                      parsing error.                          *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Unresolved symbol, parsing error occurs because of view name /
  creator are  not unquoted which  in turn result in not finding
  object in  SYSIBM.SYSCOLUMNS.  Changes are done so that object
  names/object  creators are  unquoted before  doing a select on
  SYSCOLUMNS.
  

Problem conclusion

• The problem is been fixed both  in V7.1 & V7.2.
  

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

•    ADB2PRP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK33038

     UP08/01/25 P F801

• R720 PSY UK33039

     UP08/01/25 P F801

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.