Using the onstat -g bus_sm Option

The onstat -g bus_sm option shows the current storage-manager configuration, what storage managers are assigned to each coserver, and what work each storage manager is currently performing.

Sample onstat -g bus_sm Output When ON-Bar Is Idle

The following example shows the storage-manager version, storage-manager name, the number of onbar-worker processes, the number of coservers, the maximum number of onbar-worker processes started, and the ON–Bar idle time-out:

onstat -g bus_sm 

    Configured storage managers
    ---------------------------

    BAR_SM             1
    BAR_SM_NAME        ism
    BAR_WORKER_COSVR   1
    BAR_DBS_COSVR      1,2
    BAR_LOG_COSVR      1,2
    BAR_WORKER_MAX     1
    BAR_IDLE_TIMEOUT   5
    END

Sample onstat -g bus_sm Output During a Dbspace Backup

When a backup or restore session is active, onstat -g bus_sm also displays information about the active onbar-worker processes, as the following example shows:

onstat -g bus_sm 

    Configured storage managers
    ---------------------------

    BAR_SM              1
    BAR_SM_NAME         ism
    BAR_WORKER_COSVR    1
    BAR_DBS_COSVR       1,2
    BAR_LOG_COSVR       1,2
    BAR_WORKER_MAX      1
    BAR_IDLE_TIMEOUT    5
    END

Active workers:
     
   Worker 2 Coserver 1 Pid 4590 State BUSY "dbsl.2.0"

The onbar-worker process is backing up dbslice dbsl.2.0.