Insufficient Storage Managers 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 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 Description of Values for Commit Database Option.