Insufficient Storage Managers (SMs) to Start Transaction

Symptom

There is an error message such as the following: Insufficient Storage Managers to start transaction: require 1, have 0.

Cause

If the commit remote database option is enabled, there must be at least the specified number of SMs running.

This error is generated because the Transaction Engine (TE) is unable to persist the transaction on the desired number of SMs.

Solution

Ensure that the number of running SMs for the database matches the commit remote value. See .