sp_cluster logical, action

Modifies an outstanding action, such as canceling the action or changing the timing of the action.

sp_cluster logical, "action", lc_name, { 
	cancel, action_handle |
	modify_time, action_handle, wait_option[, timeout ] |
	release, action_handle }

lc_name – is the name of the logical cluster.

cancel – specifies an action to be canceled.

action_handle – is the action identifier.

modify_time – specifies that the time of the action is to be modified.

wait_option – is how the time of the action is to be modified. Values are:

• wait – indicates that existing connections are given a specified amount of time (or an infinite amount of time if no timeout is given) to migrate or disconnect.

• nowait – indicates that existing connections are migrated or disconnected immediately.

• until – indicates that existing connections are given until a specific time of day to migrate or disconnect.

timeout – is a specific amount of time (when used with wait) or a specific time (when used with until). The format is “hh:mm:ss” according to a 24-hour clock. For example, timeout records "11:30 p.m" (or "11:30pm") as "23:30:00".

release – specifies that all resources held by a completed action are to be released.

Example 17

sp_cluster logical, "action", SalesLC, cancel, "4390"

Example 18

sp_cluster logical, "action", SalesLC, modify_time, "5364", nowait

Example 19

sp_cluster logical, "action", SalesLC, release, "3456"

Example 20

sp_cluster logical, "action", SalesLC, release, "all"

• Retrieve an action handle by querying the monLogicalClusterAction table or executing:

  sp_cluster logical, "show", NULL, action
  

• Any client that does not support migration is disconnected when it completes a SQL batch and has no open transactions, or when the timeout period expires, which ever comes first.

• Any client remaining at the end of the timeout period is disconnected.

• Cancelling an action does not roll back the action. Additional tasks may be necessary to restore the configuration to the original state.

• Only completed actions can be released. Releasing an action removes the completed action from the system and from the monLogicalClusterAction table.