PK75096: 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 SQL code -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 *
  *                      SQL code - 104 when invoking SQL/PA.    *
  *                      LOCAL FIX:                              *
  *                      None                                    *
  ****************************************************************
  * 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:

  UK42174 UK42175

Modules/Macros

•    CQM$TEXT CQM#YDAT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK42174

     UP08/12/12 P F812

• R221 PSY UK42175

     UP08/12/12 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.