IBM Support

IZ75602: DEADLOCK EVENT MONITOR MAY GET STUCK IN "PENDING REMOTE" STATUS IF GLOBAL EVENT MONITOR RUNS OUT OF DATABASE MONITOR HEAP.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • For DPS system , if  global event monitor run out of "Database
    Monitor Heap" memory during event monitor activation.  It can
    stuck in "Pending remote" status.
    
    Here is the example of the "db2 list applications global show
    detail"
    
    CONNECT Auth Id
    
    Application Name     Appl.      Application Id
                                  Seq#  Number of  Coordinating DB
    Coordinator     Status                         Status Change
    Time         DB Name  DB Path
                     Handle
                                    Agents     partition number
    pid/thread------------------------------------------------------
    ----------------------------------------------------------------
    ----------
    -------------------- ----------
    --------------------------------------------------------------
    ----- ---------- ---------------- ---------------
    ------------------------------ --------------------------
    -------- --------------------
    DB2INST1
    
    
    db2taskd             53         *N0.DB2.100416004033
                                  00001 1          0
    26       Connect Completed              Not Collected
      SAMPLE   /export/home/db2inst1/db2inst1/NODE0000/SQL00001/
    
    DB2INST1
    
    
    db2wlmd              54         *N0.DB2.100416004034
                                  00001 1          0
    27       Connect Completed              Not Collected
      SAMPLE   /export/home/db2inst1/db2inst1/NODE0000/SQL00001/
    
    DB2INST1
    
    
    db2evmg_DB2DETAILDEA 58         *N0.DB2.100416004113
                                  00002 3          0
    34       Pending remote request         Not Collected
      SAMPLE   /export/home/db2inst1/db2inst1/NODE0000/SQL00001/
    
    DB2INST1
    
    
    db2evmg_DB2DETAILDEA 59         *N0.DB2.100416004116
                                  00004 3          0
    35       Pending remote request         Not Collected
      SAMPLE   /export/home/db2inst1/db2inst1/NODE0000/SQL00001/
    
    DB2INST1
    
    
    db2evmg_DB2DETAILDEA 60         *N0.DB2.100416004119
                                  00006 3          0
    36       Pending remote request         Not Collected
      SAMPLE   /export/home/db2inst1/db2inst1/NODE0000/SQL00001/
    

Local fix

  • INCREASE EVENT MONITOR HEAP.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 v9.5 users with a fixpak lower than fixpack 6.           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * For DPS system , if  global event monitor run out            *
    * of"DatabaseMonitor Heap" memory during event monitor         *
    * activation.  Itcanstuck in "Pending remote" status.Here is   *
    * the example of the "db2 list applications                    *
    * globalshowdetail"CONNECT Auth IdApplication Name    Appl.    *
    *   Application IdSeq#  Number of  CoordinatingDBCoordinator   *
    *  Status                        Status ChangeTime        DB   *
    * Name  DB PathHandleAgents    partition                       *
    * numberpid/thread----------------------------------------------
    * --------------------------------------------------------------
    * ---------- ----------------                                  *
    * ---------------------------------------------                *
    * ----------------------------------                           *
    * --------------------DB2INST1db2taskd            53           *
    * *N0.DB2.10041600403300001 1          026      Connect        *
    * Completed              Not CollectedSAMPLE                   *
    * /export/home/db2inst1/db2inst1/NODE0000/SQL00001/DB2INST1db2wl
    *              54        *N0.DB2.10041600403400001 1           *
    * 027      Connect Completed              Not CollectedSAMPLE  *
    * /export/home/db2inst1/db2inst1/NODE0000/SQL00001/DB2INST1db2ev
    * 58        *N0.DB2.10041600411300002 3          034           *
    * Pending remote request        Not CollectedSAMPLE            *
    * /export/home/db2inst1/db2inst1/NODE0000/SQL00001/DB2INST1db2ev
    * 59        *N0.DB2.10041600411600004 3          035           *
    * Pending remote request        Not CollectedSAMPLE            *
    * /export/home/db2inst1/db2inst1/NODE0000/SQL00001/DB2INST1db2ev
    * 60        *N0.DB2.10041600411900006 3          036           *
    * Pending remote request        Not CollectedSAMPLE            *
    * /export/home/db2inst1/db2inst1/NODE0000/SQL00001/            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Uprade to v9.5 fixpak 6                                      *
    ****************************************************************
    

Problem conclusion

  • Fix included in v9.5 fixpak 6. With this fix, global event
    
    monitors will not be stuck in "pending remote status"if
    
    Database monitor heap is exhausted.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ75602

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-04

  • Closed date

    2010-06-24

  • Last modified date

    2010-06-24

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

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

    IC68720 IC68721

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 June 2010