PH51896: EXPLAIN STATEMENT TYPE INCORRECT

APAR status

• Closed as program error.

Error description

• EXPLAIN statement type incorrect
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. EXPLAIN statement type incorrect     *
  *                      2. Empty exceptions screen when         *
  *                      corrname collection enabled             *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. QM was not resolving the EXPLAIN type for when EXPLAIN was
  the target of a dynamic EXECUTE SQL call.
  2. Drill down via corrname to
  exceptions leads to empty screen
  

Problem conclusion

• 1. Problem was resolved by checking for the EXPLAIN verb in the
  SQL text
  2. Fixed CORRNAME initialization error
  

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:

  UI91604

Modules/Macros

• CQM#FEXS CQMBLOB  CQMCAESV CQMCFPAX CQMCHMOD CQMCPXPT CQMJAR
  CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX
  CQMMECSX CQMMEDCX CQMMEDPX CQMMEDRX CQMMEDSX CQMSSV   CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI91604

     UP23/05/02 P F305