PH32412: DYNAMIC EXPLAIN IN SQL PA GETS -199 ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Dynamic explain in SQL PA gets -199 error
  SQL199
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 SQL Performance Analyzer             *
  *                 users of component                           *
  *                 - ISPF/BATCH Process packages from the DB2   *
  *                   system catalog                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLPA not being able to explain a       *
  *                      package in which statement start with   *
  *                      phrase INSERT INTO ... ;                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTFs                               *
  ****************************************************************
  SQLPA not being able to explain a
  package in which statement start with
  phrase INSERT INTO ... ;
  

Problem conclusion

• Code logic was corrected to fix the issues described.
  
  
  Search Keywords:
  Code -199 when statement start with INSERT INTO ... ;
  

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:

  UI73271

Modules/Macros

• ANLCLOB  ANLCSV   ANLDB2X  ANLDCRE8 ANLEEE   ANLMAIN  ANLPLAN
  ANLSERV  ANLSQ2M  ANLSQLPA ANLTABS  ANLTSO   ANLVER8
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI73271

     UP20/12/25 P F012

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.