PK01169: PANEL CQM$QLCA - "COLL" FIELD CAN DISPLAY INCORRECT VALUE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The Coll field on panel CQM$QLCA may show an incorrect value.
  If the customer first views an exception - then backs out to the
  main menu and chooses option 'N' (for SQLCODES)...then selects a
  SQLCODE and then enters option 'C' on the detail line - it is
  possible that the Coll field will incorrectly show a value from
  the last-viewed exception.  Code will be changed to display the
  correct value in the instance just described.
  

Local fix

• Once the customer has navigated into the CQM$QLCA panel - an an
  incorrect COLL field value is shown, the customer can exit the
  panel (via PF3) - then immediately re-enter the panel again and
  the field will be displayed correctly.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Coll field on panel CQM$QLCA may    *
  *                      show an incorrect value. If the         *
  *                      customer first views an exception -     *
  *                      then backs out to the main menu and     *
  *                      chooses option 'N' (for SQLCODES)...    *
  *                      then selects a SQLCODE and then enters  *
  *                      option 'C' on the detail line - it is   *
  *                      possible that the Coll field will       *
  *                      incorrectly show a value from the       *
  *                      last-viewed exception.  Code will be    *
  *                      changed to display the correct value    *
  *                      in the instance just described.         *
  *                      LOCAL FIX:                              *
  *                      Once the customer has navigated into    *
  *                      the CQM$QLCA panel - an incorrect COLL  *
  *                      field value is shown, the customer can  *
  *                      exit the panel (via PF3) - then         *
  *                      immediately re-enter the panel again    *
  *                      and the field will be displayed         *
  *                      correctly.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR fixes an incorrect display where the COLLID specified
  on the CQM$QLCA panel does not match the negative SQL code
  SQLCA that is being displayed.
  

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:

  UK00919

Modules/Macros

•    CQM$SQCE CQM$SQCL
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UK00919

     UP05/03/03 P F503

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.