PM83995: A DB2 -913 ERROR (DEADLOCK) OCCURRED WHILE USER PROCESS MESSAGES IN MER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When messages were processed in MER, messages would be routed to
  the backout queue with a DB2 -913 error in trace file.
  

Local fix

• create an index on the system and do a RUNSTATS after
  applied the index :
  
  
    CREATE UNIQUE INDEX DNIvSN.DNQW9EMS
       ON DNIvSN.DNQE_MESSAGES
    (
       EXTERNALID                ASC
    )
    USING STOGROUP DNQvSG01 PRIQTY 12 SECQTY 12
    PCTFREE 10 FREEPAGE 0
    BUFFERPOOL DNIvBP2
  
  Runstats :
  
    RUNSTATS TABLESPACE DNIvDB01.DNQEMSG REPORT NO UPDATE NONE
  
    //where DNIvDB01 needs to be substituted by the name of the
    WBIFN runtime//
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A DB2 -913 ERROR (DEADLOCK) OCCURRED    *
  *                      WHILE USER PROCESS MESSAGES IN MER      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Formerly, there was a chance that running several MER
  routing flows could cause a deadlock on DNQE_MESSAGES table.
  

Problem conclusion

• Now, an automatic retry for MER routing flows has been
  implemented which can circumvent temporary failures like this.
  

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:

  PM84140

Modules/Macros

• DNQ00000
  

Fix information

• Fixed component name

  MESSAGE MANAGEM

• Fixed component ID

  5655FIN03

Applicable component levels

• R11M PSY UK94573

     UP13/05/30 P F305

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.