IC84343: CATALOG NODE FAILURE CAN LEAD TO SYSTEM APPICATIONS NOT TERMINATING AND CAUSE SQL1229N ON NON-CATALOG NODES.

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• A catalog node failure can lead to a timing issue on non-catalog
  nodes where certain system applications are concurrently being
  interrupted by a node failure interrupt and a force interrupt
  causing the force interrupt to be lost. If the catalog node
  failure interrupt happens and the agent does not process it
  completely before the force interrupt comes in, (due to the last
  user connection on a db forcing off all applications) the force
  interrupt will be lost and the system application will return to
  its waitpost. The last user connection will be waiting in
  TermDbConnect on lastSysApplOut forever. Any other applications
  attempting to connect to this db will get -1229.
  
  The stack of the last user connection will be in this state:
  
  thread_wait
  sqloWaitEDUWaitPost
  TermDbConnect
  AppStopUsing
  sqlesrspWrp
  sqleUCagentConnectReset
  sqljsCleanup
  sqljsDrdaAsInnerDriver
  sqljsDrdaAsDriver
  RunEDU
  EDUDriver
  sqloEDUEntry
  
  And the fast writer system application will be in this state:
  
  thread_wait
  sqloWaitEDUWaitPost
  executeFastWriter
  sqleIndCoordProcessRequest
  RunEDU
  EDUDriver
  sqloEDUEntry
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Version 10.1 Fix Pack 1                       *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 Version 10.1 Fix Pack 1
  

Temporary fix

Comments

APAR Information

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

  IC83094

• 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

• RA10 PSN

     UP