PK14772: QM NOW BREAKS ON SPECIFIC SQL TEXT CLAUSES E.G. WHERE, FROM ETC.IN THE QM EXPORT DATASET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This fix changes the format of the SQL text in the QM export
  dataset. QM will now break on specific SQL text clauses e.g.
  WHERE, FROM etc. The very nature of QM breaking specific clauses
  on different output lines of the export dataset will result in
  an acceptable format that allows SQL/PA to continue processing
  that SQL.
  
  OTHER SYMPTOMS:
  Some SQL text displayed by QM, when passed to SQL/PA, can result
  in SQL/PA interpretation errors.
  
  The erroneous error message for the last query in the plan table
  and eof was reached on the ANREL file in product DB2 SQL/PA
  COMPID: 5697F5701
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Some SQL text displayed by QM, when     *
  *                      passed to SQL/PA, can result in         *
  *                      SQL/PA interpretation errors.           *
  *                      Code will be changed to reformat the    *
  *                      offending SQL text in an acceptable     *
  *                      format that allows SQL/PA to continue   *
  *                      processing that SQL.                    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  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:

  UK10296

Modules/Macros

•    CQM$TEXT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UK10296

     UP06/01/10 P F601

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.