Command Reference Guide
MXCS Commands and Objects
SQL/MX Connectivity Service Administrative Command Reference—526350-005
2-11
Related Commands
NonStop TCP/IP address (-TCP = driver process name), the initial port number
(-PN 15000), the trace detail level (-E 0), and the port range (-PR 250):
MXOAS /name $AS, nowait, term $zhome/ -TCP $ZTC0 -PN 15000 -E 0 -PR 250
When SQL/MX is initialized, the TDM_Default_DataSource is created with these
defaults:
MaxServer: 5
IdleServer: 1
InitServer: 1
IdleTimeout: SYSTEM_DEFAULT
ConnTimeout: SYSTEM_DEFAULT
StartAutomatic: OFF
<No Resource Statistics>
<No Resource Management Policy EVARs>
<No Control EVARs>
<No Define EVARs>
<No Set EVARs>
A sample configuration of a new DS normally entered for testing is:
Data source name: TDM_Default_DataSource
MaxServer: 20
IdleServer: 5
InitServer: 10
IdleTimeout: SYSTEM_DEFAULT
ConnTimeout: 60 minutes
StartAutomatic: Manual
Trace: Off
SQLStmtStat: On
SQLPrepareStat: On
SQLExecuteStat: On
SQLExecDirectStat: On
SQLFetchStat: On
ConnInfoStat: On
SessionInfoStat On
RM: Estimated Cost: STOP_LOG_WITH_ERROR
Define: =EMPLOYEE CLASS MAP, FILE $DATA01.PERSNL.EMPLOYEE
Define: =DEPT CLASS MAP, FILE $DATA02.PERSNL.DEPT
Control: QUERY DEFAULT HIST_NO_STATS_ROWCOUNT '123456789'
Control: QUERY DEFAULT HIST_NO_STATS_UEC '99'
Control: TABLE * TIMEOUT '3000'
Control: TABLE PERSNL.JOB MDAM 'OFF'
Sets: CATALOG TANDEM_SYSTEM_NSK
Sets: SCHEMA PUBLIC_ACCESS_SCHEMA
Related Commands
You can use several related commands, outside of the MXCS administrative command
library, in conjunction with commands supported by the library:
MXCI Mode Command on page 2-12
Session Variables on page 2-12
MXCI Comment on page 2-12