PK23809: SQLPA GENERATES SQLCODE -204 204 ( 71114 )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLPA generates SQLCODE -204 204 and -104. ( 71114 74080 89753 )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 SQL Performance Analyzer.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLPA generates SQLCODE -204 and        *
  *                      -104. ( 71114 74080 89753 )             *
  *                      Additional Symptoms:                    *
  *                      1. erroneous "no stats, defaults used"  *
  *                       ANL5006I, ANL5007I, ANL5008I under V7, *
  *                       and V8 Compat                          *
  *                      2. allows Precise ALL to generate       *
  *                      Predicate Report under V7 TSO and       *
  *                      batch                                   *
  *                      3. corrects some synonym detection      *
  *                      cases                                   *
  *                      4. corrects Qualifier insert when       *
  *                      "SELECT INTO :H" used in SQL            *
  ****************************************************************
  * 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:

  UK15294

Modules/Macros

• ANLPGM3N ANLPGM31 ANLPRC3C ANLPRC3R ANLPRE3C
  ANLPRE3R ANLQMF31
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R310 PSY UK15294

     UP06/06/13 P F606

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.