IBM Support

PM19583: DB2 QUERY MONITOR AGENT INSTALL FAILURE MAY OCCUR

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If both Query Monitor and DB2 Audit Management Expert monitor a
    common DB2 subsystem Query Monitor may issue the DB2 QUERY
    MONITOR AGENT INSTALL FAILURE FOR nnnn message and
    be unable to monitor the DB2 subsystem.
    
    This can occur when Audit Management Expert and Query Monitor
    are active on one DB2 and Query monitor is also monitoring an
    additional DB2. If the additional DB2 subsystem is deactivated
    after the DB2 subsystem both products share then
    DB2 QUERY MONITOR AGENT INSTALL FAILURE FOR nnnn occurs on the
    additional DB2.
    

Local fix

  • Cycle both Query Monitor and Audit Management Expert if they
    monitor a common DB2 susbsystem and either product must be
    recycled.   Stop Audit Management expert before stopping Query
    Monitor.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Query Monitor.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: If both Query Monitor and DB2 Audit     *
    *                      Management Expert monitor a common DB2  *
    *                      subsystem Query Monitor may issue the   *
    *                      DB2 QUERY MONITOR AGENT INSTALL FAILURE *
    *                      FOR nnnn message and be unable to       *
    *                      monitor the DB2 subsystem. This can     *
    *                      occur when Audit Management Expert and  *
    *                      Query Monitor are active on one DB2 and *
    *                      Query monitor is also monitoring an     *
    *                      additional DB2. If the additional DB2   *
    *                      subsystem is deactivated after the DB2  *
    *                      subsystem both products share then      *
    *                      DB2 QUERY MONITOR AGENT INSTALL         *
    *                      FAILURE FOR nnnn occurs on the          *
    *                      additional DB2.                         *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM19583

  • Reported component name

    DB2 QUERY MONIT

  • Reported component ID

    5655E6701

  • Reported release

    230

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2010-07-30

  • Closed date

    2010-09-02

  • Last modified date

    2010-10-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  •    CQMMINST
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R230 PSY UK60263

       UP10/09/10 P F009

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"230"}]

Document Information

Modified date:
31 March 2021