IT30512: DPF INDOUBT RESOLUTION WILL ONLY RESOLVE 1 INDOUBT PER NODE REGARDLESS OF THE NUMBER OF INDOUBTS THAT EXIST AT DATABASE START

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• DPF Indoubt resolution will only resolve 1 indoubt transaction
  per node regardless of the number of indoubt transactions that
  exist at database startup.   If there are more than one
  transaction that needs to be resolved it can require multiple
  RESTART DATABASE invocations to resolve all of them.  If they
  are not resolved, it can eventually lead to a LOG FULL condition
  and force the database to shut down.
  

Local fix

• Issue the RESTART DATABASE multiple time to resolve all indoubt
  transactijons
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Mod 4 Fixpack 5
  

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:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP