PI51655: SQLCODE199 OR SQLOCDE104 OR INCOMPLETE EXPLAIN OF NSP PACKAGE CREATED BY DATA STUDIO AND ENHANCED COMPARE & TEST

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR addresses the following:
  
  * Dynamic or static EXPLAIN from DB2 catalog of a
    NSP (Native Stored Procedure) package created in
    Data Studio is incomplete or fails with SQLCODE199
    or SQLCODE104. A SQL TEXT could be truncated.
  
    SQL code -104 -199
  
  * Enhanced ISPF interface COMPARE & TEST support.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of SQL Performance Analyzer z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses the following:      *
  *                      * Dynamic or static EXPLAIN from DB2    *
  *                       catalog of a NSP (Native Stored        *
  *                       Procedure) package created in Data     *
  *                       Studio is incomplete or fails with     *
  *                       SQLCODE199 or SQLCODE104. A SQL TEXT   *
  *                       could be truncated.                    *
  *                        SQL code -104 -199                    *
  *                      * Enhanced ISPF interface COMPARE &     *
  *                       TEST support.                          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UI33925

Modules/Macros

•    ANLBATCH ANLBNDGR ANLCBTCH ANLCHECK ANLCIGO
  ANLCMIGR ANLCORPT ANLCVSET ANLDPRM  ANLEEE   ANLGPRM  ANLGPST
  ANLH03   ANLH04   ANLH05   ANLJB003 ANLJCRE8 ANLMAIN  ANLPBTCH
  ANLPHE00 ANLPHE12 ANLPHE13 ANLPHE15 ANLPHE16 ANLPHE17 ANLPHH00
  ANLPHI01 ANLPHI02 ANLPH011 ANLPH021 ANLPH022 ANLPH023 ANLPH024
  ANLPH025 ANLPH026 ANLPH027 ANLPH028 ANLPH202 ANLPH219 ANLPH220
  ANLPICP  ANLPITP  ANLPMAIN ANLPMAN1 ANLPORPT ANLPPKGE ANLPRCR
  ANLPRER  ANLPTCMP ANLPTTST ANLPWIFQ ANLQMF   ANLSQLPA ANLTSO
  ANL10    ANL11    H1D0510J
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI33925

     UP15/12/25 P F512

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.