PI68024: ORDER OF RECORDS NOT PRESERVED IN DB2 COMMAND ACTIVITY AND SQL CODE SUMMARY PANEL NAV IN DATA SHARING VIEW WHEN SORTING DISABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The order of records is not preserved in the DB2 Command
  Activity and SQL Code Summary panel navigation in the
  data sharing view when sorting is disabled.
  Without sorting, the records in the DB2 Command Activity
  and SQL Code Summary displays should be preserved in the
  correct order.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The order of records is not preserved   *
  *                      in the DB2 Command Activity and SQL     *
  *                      Code Summary panel navigation in the    *
  *                      data sharing view when sorting is       *
  *                      disabled. Without sorting, the records  *
  *                      in the DB2 Command Activity and SQL     *
  *                      Code Summary displays should be         *
  *                      preserved in the correct order.         *
  ****************************************************************
  * 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:

  UI42375 UI42376

Modules/Macros

•    CQM$DB2C CQM$SQCM
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI42375

     UP16/11/14 P F611

• R330 PSY UI42376

     UP16/11/16 P F611

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.