PK75094: SQL CODE -104 WHEN INVOKING SQL/PA VIA QUERY MONITOR EXPORT SQL FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Code is being changed to correct SQL text parsing in the Query
  Monitor export SQL function, that may result in SQLcode -104
  -104 when invoking SQL/PA.
  

Local fix

• The EDIT option of SQL/PA can be used to edit the file before
  SQL/PA analyzes the text.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM DB2 Query Monitor.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Code is being changed to correct SQL    *
  *                      text parsing in the Query Monitor       *
  *                      export SQL function, that may result in *
  *                      SQLcode -104 -104 when invoking SQL/PA. *
  *                      LOCAL FIX:                              *
  *                      The EDIT option of SQL/PA can be used   *
  *                      to edit the file before SQL/PA          *
  *                      analyzes the text.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made to address these issues.
  

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:

  UK41871

Modules/Macros

•    CQM$TEXT CQM#YDAT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK41871

     UP08/12/02 P F812

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.