Command Reference Guide

Object DS Commands
SQL/MX Connectivity Service Administrative Command Reference—526350-005
5-12
Considerations—ALTER DS
running servers using this DS and started by any service are affected by changing
any flag.
ConnInfoStat [OFF]
is a flag to turn ON, for this DS, the statistics gathering of session statistics at the
time a session is established. Use this flag without the OFF option to turn the
individual flag ON. This flag can follow the AllStat flag to reset only this flag.
Statistics are written to the collector specified when the service is started. Currently
running servers using this DS and started by any service are affected by changing
any flag.
Considerations—ALTER DS

ALTER DS is a sensitive command.

The asterisk (*) wild card is not supported fro the DS name.

Changes are immediately visible to all services.

The DS can be in any state.

Changing the StartAutomatic attribute does not change the current state of the
DS.

Omitting a parameter indicates no change to that attribute and does not reset that
attribute to its default value. Omitting all parameters results in an error.

The default value for all flags is the current value. To set it to on, specify the
attribute without the OFF option. To turn it off, specify the OFF option.

An error while changing one parameter does not stop or roll back changes to other
parameters.
Examples—ALTER DS

Modify two attributes of the DS TDM_Default_DataSource in all services, even
though the service $AS is specifically addressed:
CS>alter ds $as."TDM_Default_DataSource", MaxServer 10, ConnTimeout no_timeout;
-- ALTER DS \ODBC.$AS.TDM_Default_DataSource Begun
-- ALTER DS \ODBC.$AS.TDM_Default_DataSource Successful for basic settings

Turn on trace for all active MXCS servers started by the service $AS that are using
the DS TDM_Default_DataSource:
CS>alter ds $as."TDM_Default_DataSource", Trace;
-- ALTER DS \ODBC.$AS.TDM_Default_DataSource Begun
-- ALTER DS \ODBC.$AS.TDM_Default_DataSource Successful for trace

Turn off trace for all active MXCS servers started by any service that is using DS
TDM_Default_DataSource and also modify other parameters. Because failures
do not roll back or stop the actions, this output shows the progress of changes to
the DS attributes in the database and the trace results on each active service. In
this example, the DS name, TDM_Default_DataSource, is enclosed in quotes to