Command Reference Guide

Object DS Commands

SQL/MX Connectivity Service Administrative Command Reference—526350-005

5-21

STOP DS

This command stops one DS on all services or all DSs on one service. The actual

termination occurs at different times, depending on the stop-mode attribute you

specify. The DS goes to the stopped state only after all servers are stopped.

Command syntax is:

obj-name

[[[\system-name.][$service-name | *].]ds-name | *]

system-name

is the name of the current system of up to 16 CPUs with the same Expand

address and where the target MXCS process is running. system-name and

service-name identify one service instance.

service-name

is the name of the MXCS association server that handles or processes the

command where this DS should be stopped. Using the asterisk (*) wild card

indicates to stop all services and is valid only when a specific DS is selected.

This value allows the DS to be stopped on all services on one system in one

command, so a subsequent delete is possible.

ds-name

is the name of the DS to be stopped. It can be the asterisk (*) wild card,

provided a specific service is selected.

AFTER stop_mode

specifies the termination time of the server with one of these key values:

NOW

terminates the server abruptly (abort as fast as possible). A client connected to

the server receives the communication link failure error on the next

action that accesses the server. The client is expected to either disconnect and

connect to another server or to quit. Incomplete transactions are rolled back.

Note. Use INFO DS to determine when a DS is in the STOPPED state.

STOP DS [obj-name], REASON text, [AFTER stop-mode];

Note. ds-name is an SQL identifier and is therefore case-sensitive. When using lowercase

characters, enclose ds-name in quotes to preserve the lowercase characters. Failure to do so

causes ds-name to be automatically uppercased during command execution, which can cause

errors. Enter the default ds-name as

"TMD_Default_DataSource".