Summary of instance status information from the db2instance -list command

This topic provides a summary overview of the states returned by the db2instance -list command, which you can use to look up troubleshooting information.

Use the following table to obtain more information about output from the db2instance -list command.
Table 1. Permutations based on the output of thedb2instance -list command
Member State Member Alert Host State Host Alert Further information
WAITING_FOR_FAILBACK YES INACTIVE YES See Member WAITING_FOR_FAILBACK, alert, corresponding host is in INACTIVE state with alert
WAITING_FOR_FAILBACK NO INACTIVE YES See Member WAITING_FOR_FAILBACK, no alerts, corresponding host is in INACTIVE state with alert
WAITING_FOR_FAILBACK NO ACTIVE YES See Member WAITING_FOR FAILBACK, no alerts, the corresponding host is in ACTIVE state with an alert
STARTED YES ACTIVE NO See Member shows alert while in STARTED state, all hosts are in ACTIVE state with no alerts
STARTED NO ACTIVE NO The output of the "db2instance -list" command shows the primary cluster caching facility switched state from PRIMARY to PEER, and the secondary cluster caching facility switched state from PEER to PRIMARY. See Primary role moves between cluster caching facility hosts
ERROR YES ACTIVE NO See Member is in ERROR state