Command Reference Guide

SQL/MX Connectivity Service Administrative Command Reference—526350-005
A-1
A
Example Commands and Objects
The appendix provides examples to:

Start an MXCS ODBC service named $AS

Create and start a DS named TEST_DSN

Review the resulting MXCS configuration

Stop and delete the DS

Stop the service

Delete the service
Because example object names are not case-sensitive, they appear in lowercase.
However, they appear in uppercase in reports. To protect the case of a DS name,
enclose it in double quotes (“). Service names are automatically translated to
uppercase.
Commands in these examples use the defaulting feature for component names, where
component names are retained from previous commands.
These MXCI commands appear in the order that they appear in this example.

mode mxcs;

info service $as;

add ds Test_DSN, ... ;

add evar "ESTIMATED COST", ... ;

add evar timeout, ... ;

add evar sratch_disks, ... ; Misspelled EVAR name to demonstrate an error

add evar scratch_disks, ... ;

add evar EMP, type define, ... ;

info ds, detail;

info evar *, ... ;

info ds *;

start service;

start ds Test_DSN;

info service, detail;

info ds, detail;

info server *;

info server *, ... ;

stop ds, ... ;

delete ds;

stop service $as, ... ;
This is an example of running the commands and messages that result. Operator
permissions are required to execute add, start, stop, and delete, so it is assumed
the user has this permission. No security permissions are necessary to run info.
This example starts the service object $AS using the MXOAS command at the TACL
prompt, where -i indicates that the service enters the stopped state after initialization
(no servers start until the DS and service are started):
volume $system.zmxodbc
run mxoas /name $as, nowait, term $zhome/ -tcp $ztc0 -i -pn 21000