PI31898: INCLUDE DECLARE CURSOR INFORMATION IN THE SQL STATEMENT WHEN EXPLAINING A DBRM

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When explaining a DBRM, if the SQL statement is extracted from a
  DECLARE CURSOR statement, the DECLARE CURSOR information is not
  displayed as part of the SQL statement.  This enhancement will
  display the DECLARE CURSOR information as part of the SQL
  statement in the output reports.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of SQL/PA v4.2.                    *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      This APAR addresses the enhancement     *
  *                      requested via RFE 57714 which is to     *
  *                      include DECLARE CURSOR information in   *
  *                      the SQL statement when explaining a     *
  *                      DBRM.                                   *
  *                      See the RFE text for details.           *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF to enable the enhancements.
  

APAR Information

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

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

  UI25303

Modules/Macros

• ANLCMACR ANLDPRM  ANLEEE   ANLGPRM  ANLICRE8
  ANLMAIN  ANLPRCR  ANLPRER  ANLQMF   ANLSQLPA ANLTSO
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R420 PSY UI25303

     UP15/02/26 P F502

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.