PM16617: DSNT4081 SQLCODEN104 EXPLAIN ON PACKAGE OR PLANS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• From Panel ANLPPLAN or ANLPPKGE issuing EXPLAIN on Plan or
  Package may generate error message :
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ")"
  Additional Symptom:
  Error may occur with ANLCSPA Edit Macro
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of SQLPA.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      From Panel ANLPPLAN or ANLPPKGE issuing *
  *                      EXPLAIN on Plan or Package may generate *
  *                      error message :                         *
  *                                                              *
  *                      (DSNT408I SQLCODE = -104,               *
  *                       ERROR:  ILLEGAL SYMBOL ")"             *
  *                                                              *
  *                      Additional Symptom:                     *
  *                                                              *
  *                      Error may occur with ANLCSPA Edit Macro *
  *                                                              *
  ****************************************************************
  * 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:

  UK61620

Modules/Macros

• ANLMAIN
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R320 PSY UK61620

     UP10/10/27 P F010

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.