Object DS Commands
SQL/MX Connectivity Service Administrative Command Reference—526350-005
5-6
Considerations—ADD DS
Statistics are written to the collector specified when the service is started. The
default value is OFF when the attribute is not used.
SQLPrepareStat [OFF]
is a flag to turn ON, for this DS, the statistics gathering of SQLPrepare statistics at
the time a PREPARE statement is received. 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. The
default value is OFF when the attribute is not used.
SessionInfoStat [OFF]
is a flag to turn ON, for this DS, the statistics gathering of session statistics at the
time a session is terminated. 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. The
default value is OFF when the attribute is not used.
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. The
default value is OFF when the attribute is not used.
Considerations—ADD DS
ADD DS is a sensitive command.
The asterisk (*) wild card is not supported for DS name.
Parameters are optional and have default values.
Default value for all flags is ON. Specifying the OFF option with the flag is
permitted but is unnecessary. The OFF option is most useful with ALTER DS and is
better omitted with ADD DS.
Statistics parameters are processed as they occur on the command-line. For
example, the AllStat flag sets all statistics flags to ON, with successive
commands on the same command-line setting individual flags to OFF.
Services see the DS as soon as it is created. After creation, the DS has no EVARs
defined unless the COPY parameter creates them.
The DS is created in the stopped state and must be explicitly started on one or
more services. Specifying the StartAutomatic attribute starts the target DS
when its associated server process starts.
Except for errors when setting the trace flag during an ADD command, an error
causes the DS to be removed completely.
Komentarze do niniejszej Instrukcji