PQ91520: DSNTIAR TEXT MISSING IF SQL EXECUTED VIA CONNECT EXTERNAL SYMPTOM CODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a user requests execution of an SQL statement across a
  remote connection, in certain circumstances the 'plain text'
  description for DSNTIAR text against a non-zero SQLCODE may
  not be collected and displayed.
  .
  All other fields in the SQLCODE display panel are displayed
  properly.
  .
  An example of the remote processing request that may trigger
  this behavior is the 'Remote Connection' option in SPUFI.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user requests execution of an    *
  *                      SQL statement across a remote           *
  *                      connection, in certain circumstances    *
  *                      the 'plain text' description for        *
  *                      DSNTIAR text against a non-zero SQLCODE *
  *                      may not be collected and displayed.     *
  *                      All other fields in the SQLCODE         *
  *                      display panel are displayed properly.   *
  *                      An example of the remote processing     *
  *                      request that may trigger this behavior  *
  *                      is the 'Remote Connection' option in    *
  *                      SPUFI.                                  *
  ****************************************************************
  * 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.