Command Reference Guide

Object DS Commands
SQL/MX Connectivity Service Administrative Command Reference—526350-005
5-17
Considerations—INFO DS
The output report contains a column of state values with these definitions:
Considerations—INFO DS

INFO DS is a nonsensitive command.

The asterisk (*) wild card is valid for $service-name and ds-name, but no state
information is displayed when $service-name is an asterisk (*).

Most attributes are configured attributes, but state and server counts are also
shown.

The operator can change any attributes.

None of the servers or the EVARs are shown in this display. Use INFO on those
objects directly if that information is desired.
Examples—INFO DS
These commands display the attributes of all DSs on the system. This first example
has four DSs and is invoked without the detail option:
CS>info ds $AS.*;
-- INFO DS \ODBC.$AS.* Report
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
DS2 STOPPED OFF 5 3 3 0 0 0
ThisDataSourceNameIsLongerThan32CharactersButLessThan79Characters
STOPPED OFF 1 0 0 0 0 0
Mixed Case DSN STARTING OFF 20 7 1 1 1 2
Unused_DS_with_32_Character_Name STOPPED OFF 247 150 7 0 0 0
-- Cmd Processed 5 objects, 0 failed.
This second example appears with the detail option but was done at a time different
than the preceding one. This example has two DSs.
CS>INFO DS $AS.*, detail, active;
-- INFO DS \ODBC.$AS.* Report, detailed
Name: \ODBC.$AS.TDM_Default_DataSource
CpuList: 0,1,2,3,4
InitPri........................140 CurrentState..................STARTED
ConnectedServers.................1 AvailableServers....................1
LastStateChg..........Feb 14 10:08 LastUpdate....................Not Set
IdleServer.......................1 IdleTimeout............SYSTEM_DEFAULT
MaxServer........................5 ConnTimeout............SYSTEM_DEFAULT
InitServer.......................1 StartAutomatic.....................ON
Trace..........................OFF SQLPrepareStat....................OFF
ConnInfoStat...................OFF SQLExecuteStat....................OFF
SessionInfoStat................OFF SQLExecDirectStat.................OFF
SQLStmtStat....................OFF SQLFetchStat......................OFF
STARTING Data source initializing (starting first server)
STARTED Data source started
STOPPING Data source stopping (all servers not down)
STOPPED Data source stopped