PQ73728: MSG CQM910E DURING ADD OPERATION FROM "SETUP" PANELS FOR DB2 QUERY MONITOR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During the setup of the parameters relating a DB2 subsystem ID,
  the datasets required for that DB2 ssid and the
  DB2 Query Monitor (CQM) application plan name, the user
  sometimes receives MSG CQM910E, even though the CQM product's
  control file is properly defined and the user has the requisite
  authorization.
  
  This message can be received if the ISPF user, after adding a
  new record to the control file, presses the "ENTER" key a second
  time without first exiting from the panel (via use of PF3) and
  reentering the panel for viewing.
  
  This message may occur within both the PLAN name definition and
  DB2 dataset definition panels.
  
  If the panel is not first exited, the CQM ISPF interface code
  is still set to perform an "ADD" to the control file with the
  data specified, thus causing an attempt to add a record with a
  duplicate key.
  
  A code change will address this deficiency.
  

Local fix

• After adding a record to either of the definition panels
  accessed after selecting option "S" from the CQM main menu,
  exit the panel, by use of the PF3 key, before using the "ENTER"
  key a second time. This second viewing of the definition panel
  (s) causes the panel to be set up for an UPDATE process, rather
  than an ADD.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: During the setup of the parameters      *
  *                      relating a DB2 subsystem ID, the        *
  *                      datasets required for that DB2 ssid and *
  *                      the DB2 Query Monitor (CQM) application *
  *                      plan name, the user sometimes receives  *
  *                      MSG CQM910E, even though the CQM        *
  *                      product's control file is properly      *
  *                      defined and the user has the requisite  *
  *                      authorization.                          *
  *                                                              *
  *                      This message can be received if the     *
  *                      ISPF user, after adding a new record to *
  *                      the control file, presses the "ENTER"   *
  *                      key a second time without first exiting *
  *                      from the panel (via use of PF3) and     *
  *                      reentering the panel for viewing.       *
  *                                                              *
  *                      This message may occur within both the  *
  *                      PLAN name definition and DB2 dataset    *
  *                      definition panels.                      *
  *                                                              *
  *                      If the panel is not first exited, the   *
  *                      CQM ISPF interface code is still set to *
  *                      perform an "ADD" to the control file    *
  *                      with the data specified, thus causing   *
  *                      an attempt to add a record with a       *
  *                      duplicate key.                          *
  *                                                              *
  *                      A code change will address this         *
  *                      deficiency.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A code change has been made 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:

  UQ80798

Modules/Macros

•    CQM$ADMN CQM$ADM1
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R110 PSY UQ80798

     UP03/10/09 P F310

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.