Resumes a component in a specified server. The command resumes a DSI thread, Replication Agent thread, queue, or route in a Replication Server, or a RepAgent thread in an Adaptive Server Enterprise.
resume {dsi | queue | rep agent | route} component_name
for {server_name | group_name} [skip transaction | execute transaction]
Specifies the component type to resume. The component is a database name, if resuming a RepAgent thread in an Adaptive Server Enterprise. Otherwise, the component is a connection, queue, or route name.
Specifies the name of the component to resume.
Specifies the name of a group. Each component in the group is resumed.
Specifies the name of either a Replication Server or an Adaptive Server Enterprise that contains the component.
If the option is provided for a DSI connection, instructs the Replication Server to resume execution with the second transaction in the connection’s queue. The first transaction is written to the database exceptions log.
If the option is provided for a queue, specifies that the SQM should skip the first large message encountered after restarting.
If this option is provided for a route, ignore the first transaction encountered with a wide message greater than 16K bytes.
Overrides the Replication Server restriction against the application of system transactions after a DSI start-up if the system transaction is the first transaction in the DSI queue.
Resumes the DSI thread for the connection “inventory_pds.vendor” in the Replication Server INVENTORY_RS. Does not wait for the current operation to complete:
resume dsi inventory_pds.vendor for INVENTORY_RS with nowait
Resumes the Replication Agent thread for the connection “inventory_pds.vendor” in the Replication Server INVENTORY_RS:
resume rep agent inventory_pds.vendor for INVENTORY_RS
Starts the RepAgent thread for the database vendor in the Adaptive Server Enterprise INVENTORY_PDS:
resume rep agent vendor for INVENTORY_PDS
The rep agent component type is used to resume either a Replication Agent thread for a connection in a Replication Server, or a RepAgent thread in an Adaptive Server Enterprise.
The skip transaction option is valid with a Replication Server DSI connection, queue, or route.
The execute transaction option is valid only for a Replication Server DSI connection.resume issues the sp_start_rep_agent when resuming a RepAgent thread in an Adaptive Server Enterprise.
resume returns the following result set.
Column |
Description |
|---|---|
Action |
The name of the action |
Result |
The result of the execution |
configure component, get component, get threads, suspend component
