Command Reference Guide

Example Commands and Objects
SQL/MX Connectivity Service Administrative Command Reference—526350-005
A-3
SessionInfoStat...................OFF SQLExecDirectStat..................ON
SQLStmtStat.......................OFF SQLFetchStat.......................ON
CS>info evar *, type all;
-- INFO EVAR \
ODBC.$AS.TEST_DSN.* Report
Resource Management Policies:
ESTIMATED COST Limit: 500 Action: STOP
Defines:
ADD DEFINE =EMP, CLASS MAP, FILE $DATA01.PERSNL.EMPLOYEE
Controls:
CONTROL QUERY DEFAULT TIMEOUT 'RESET'
CONTROL QUERY DEFAULT SCRATCH_DISKS '$data01, $data02, \ODBC.$data03'
Sets:
None
This example displays all DSs on the system:
CS>info ds *;
-- INFO DS \ODBC.$AS.* Begun
Start Server Limits Server Usage
Name State Auto Max Init Idle Con Avl Tot
TDM_Default_DataSource STARTED ON 5 1 1 0 1 1
TEST_DSN STOPPED OFF 5 2 3 0 0 0
-- Cmd processed 2 objects, 0 failed.
This example starts the service and the DS in the service $AS:
CS>start service;
-- START SERVICE \ODBC.$AS Successful
CS>start ds Test_DSN;
-- START DS \ODBC.$AS.TEST_DSN Successful
This example verifies the results of starting the service and DS. Because servers are
not connected to clients yet, all servers are in shown the AVL state, and all connected
client information is listed as Not Avail in the displays.
CS>info service, detail;
-- INFO SERVICE \ODBC.$AS Report
PName State SPid TCP/IP PN Port Last Updated Type
$AS AVL 1,386 $ZTC0 21000 Mar 26 13:49 AS
$Z3445 AVL 1,394 $ZTC0 21001 Mar 26 13:37 CFG
DS Name (active only) DS State Svr: Con Avl Tot
TDM_Default_DataSource STARTED 0 1 1
TEST_DSN STARTED 0 3 3
-------------------- ----- ----- -----
Totals For Service 0 4 4
CS>info ds, detail;
-- INFO DS \
ODBC.$AS.TEST_DSN Report, detailed
Name: \ODBC.$AS.TEST_DSN
CpuList: 0,1
InitPri...........................140 CurrentState..................STARTED
ConnectedServers....................0 AvailableServers....................3
LastStateChg.............Mar 26 14:07 LastUpdate...............Mar 26 13:39
IdleServer..........................3 IdleTimeout................NO_TIMEOUT
MaxServer...........................5 ConnTimeout................NO_TIMEOUT
InitServer..........................2 StartAutomatic....................OFF
Trace.............................OFF SQLPrepareStat.....................ON
ConnInfoStat......................OFF SQLExecuteStat....................OFF
SessionInfoStat...................OFF SQLExecDirectStat..................ON
SQLStmtStat.......................OFF SQLFetchStat.......................ON
CS>info server *;
-- INFO SERVER \
ODBC.$AS.* Report
DS Name: TDM_Default_DataSource
PName State SPid TCP/IP PN Port Last State Chg Remote System Name
$Z3471 AVL 1,375 $ZTC0 21002 Mar 26 13:49
DS Name: TEST_DSN
PName State SPid TCP/IP PN Port Last State Chg Remote System Name