PQ91522: Statement Descriptions incorrect in DB2 v8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QM not resolving the target of the EXECUTE statement for DB2
  Version 8 like it does for V7. Take the example query:
  
  PREPARE - GRANT SYSADM TO userid
  EXECUTE prepared grant statement.
  
  Now in V7 QM is showing the call type as "GRANT" instead of
  "EXECUTE"
  for the statement at the statement number of the actual execute
  statement. In V8 there was a bug in the process that resolves
  the target
  of EXECUTE SQL calls and it was just reporting "EXECUTE".
  
  Code has been changed to resolve this problem.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: QM not resolving the target of the      *
  *                      EXECUTE statement for DB2 Version 8     *
  *                      like it does for V7. Take the example   *
  *                      query:                                  *
  *                                                              *
  *                      PREPARE - GRANT SYSADM TO userid        *
  *                      EXECUTE prepared grant statement.       *
  *                                                              *
  *                      Now in V7 QM is showing the call type   *
  *                      as "GRANT" instead of "EXECUTE" for the *
  *                      statement at the statement number of    *
  *                      the actual execute statement. In V8     *
  *                      there was a bug in the process that     *
  *                      resolves the target of EXECUTE SQL      *
  *                      calls and it was just reporting         *
  *                      "EXECUTE".                              *
  *                                                              *
  *                      Code has been changed to resolve this   *
  *                      problem.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

Modules/Macros

•    CQMCAE
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UQ93292

     UP04/10/13 P F410

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.