PH58425: QUERY MONITOR COULD SHOW OBJECTS NOT IN QUERY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• There are times where Query Monitor could show an object in the
  objects display not in the SQL statement
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Query Monitor may show an object in the Objects Display that
  might not be in the SQL statement.
  

Problem conclusion

• A situation was identified where, when collecting the Object
  information for the SQL statement, if the Db2 control block
  called the FILE PAGE SET, CONTROL BLOCK has the bit on for
  PSFISEG, QM should look in an SQL-related control block for
  the CUB which contains the OBD.
  

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

• CQC#REST CQCISMPX CQCMCLC5 CQCMCLD5 CQCMESC5 CQCMESD5 CQCMSTRM
  CQCOXGC5 CQCOXGD5
  

Fix information

• Fixed component name

  COMMON COLLECTO

• Fixed component ID

  5639OLC00

Applicable component levels

• R110 PSY UI95068

     UP23/12/29 P F312

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.