The sysbusmworker table lists the coserver IDs of onbar-worker processes that are configured for a storage manager. To display the list of active onbar-worker processes for a storage manager, join the sysbuworker table with the sysbusmworker table (sysbusmworker.id = sysbuworker.sm). This table contains the same list of storage managers as the BAR_WORKER_COSVR parameter. For example, use the SELECT * FROM sysbusmworker WHERE id = 1 command to display information on the storage manager listed in BAR_SM 1.
Column | Type | Description |
---|---|---|
id | INTEGER | Storage-manager ID. |
cosvr_id | INTEGER | Coserver on which the onbar-worker is running. |