Termination for multiple systems

Termination for multiple systems is like termination for single systems, but with some additional considerations.

  • Using STOP DB2 MODE(FORCE) could create indoubt units of recovery for threads that are between commit processing phases. These indoubt threads are resolved after you reconnect to the coordinator.
  • Data that is updated by an indoubt unit of recovery is locked and unavailable for use by others. The unit could be indoubt when Db2 was stopped, or it could be indoubt from an earlier termination that is not yet resolved.
  • A Db2 system failure can leave a unit of recovery in an indoubt state if the failure occurs between phase 1 and phase 2 of the commit process.