PI30470: OCCURRED DB DEADLOCK WHILE PERFORM THE AUTOCLEANUP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A db deadlock occurred after a msif autoclean up.
  
  DNFO3462E 11/11/14 4:34:08 AM DNFSYSOU DNF_O_CMD   Database
  deadlock or timeout. SQLState: '57033', SQLCode: -913,
  Message:{DB2 FOR OS/390} {ODBC DRIVER}{DSN10015}
   DSNT408I SQLCODE = -913, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
    BY DEADLOCK OR TIMEOUT. REASON CODE 00C90088, TYPE OF
    RESOURCE 00000302, AND RESOURCE NAME WBBASE  .DNFOMD
    .X'000002'
  
   DSNT418I SQLSTATE   = 57033 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNXRSDL SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = -190  13172746  13172872  13817319
    -470675451 536870912 SQL DIAGNOSTIC INFORMATION
   DSNT416I SQLERRD = X'FFFFFF42'  X'00C9000A'  X'00C90088'
    X'00D2D5E7' X'E3F21005'  X'20000000' SQL DIAGNOSTIC
    INFORMATION ERRLOC=1:13:2
  

Local fix

• n
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB DEADLOCK WHILE PERFORMING THE        *
  *                      AUTOCLEANUP                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Formerly, in a multi-server environment when MSIF performed
  the cleanup of old transfers a DB2 deadlock occurred
  occasionally. Such a deadlock caused the processing to stop
  for some seconds before it was automatically resolved. No
  manual intervention was required.
  

Problem conclusion

• Now, the nested SQL statement in the cleanup processing that
  caused the deadlock was reworked and the cleanup of old
  transfers should be performed without deadlocks.
  

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:

  PI30711

Modules/Macros

• DNF10056
  

Fix information

• Fixed component name

  MS FOR SN IA AN

• Fixed component ID

  5655FIN02

Applicable component levels

• R11F PSY UI26033

     UP15/03/24 P F503

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.