get status descriptions

Retrieves the list of status descriptions for a server or component. Components are monitored objects within a server. The state of a server or component consists of a state integer constant and a list of description strings. The get server and get component commands return the first description in the list and a flag that indicates whether the description list contains more than one string.

Client applications can use get server or get component to display the state of all servers monitored by the RMS. If more information is needed, the application can display all descriptions.

Syntax

get status descriptions {[for {connection | logical connection | route | queue | 
		rep agent | partition}
	component_name] for server_name | for group_name}

Parameters

connection, logical connection, route, queue, rep agent, partition – Returns status descriptions for the specified server or component.
component_name – Specifies the name of the component for which to return status descriptions. Components are monitored objects within a server. Replication Server components are connections, logical connections, routes, queues, and partitions. Adaptive Server Enterprise components are RepAgent threads.
server_name – Specifies the name of the server for which to return status descriptions. The server name is also used when returning status descriptions for components.
group_name – Specifies the name of the group for which to return status descriptions.

Examples

Example 1 – Retrieves all description strings for the server name INVENTORY_RS:
```
get status descriptions for INVENTORY_RS
```
Example 2 – Retrieves all description strings for the group name “group1”:
```
get status descriptions for group1
```
Example 3 – Retrieves all description strings for the connection “inventory_pds.pdb1” in the server INVENTORY_ASE:
```
get status descriptions 
    for connection inventory_pds.pdb1 for INVENTORY_ASE
```

Usage

get status descriptions returns all strings in the description list (including the first description).
You can use get status descriptions to return the status descriptions for the RMS.
get status descriptions returns a result set that contains a single string column that contains one status description. The result set returns multiple rows, one for each description.