Neoview Command Interface (NCI) Guide (R2.5)

ALTER DS STATS Command
The ALTER DS STATS command adds or alters the statistics flags for the specified data source.
The statistics flags determine whether SQL statement statistics are written to the alternate EMS
collector when an SQL operation is performed. The statistics attribute is stored as an environment
value of type ENV_STATISTICS.
Syntax
ALTER DS data-source-name[, ALLSTAT {ON | OFF}]
[, SQLPREPARESTAT {ON | OFF}]
[, SQLEXECUTESTAT {ON | OFF}]
[, SQLEXECDIRECTSTAT {ON | OFF}]
[, SQLFETCHSTAT {ON | OFF}]
[, SQLSTMTSTAT {ON | OFF}]
[, SESSIONINFOSTAT {ON | OFF}]
[, CONNINFOSTAT {ON | OFF}]
data-source-name
is the name of the data source. data-source-name is case-sensitive and cannot be the
asterisk (*) wild card.
ALLSTAT {ON | OFF}
turns on or off all the statistics flags.
SQLPREPARESTAT {ON | OFF}
determines whether the SQLPrepare statistics are written to the alternate EMS collector when
a PREPARE statement is received.
SQLEXECUTESTAT {ON | OFF}
determines whether the SQLExecute statistics are written to the alternate EMS collector when
an EXECUTE statement is received.
SQLEXECDIRECTSTAT {ON | OFF}
determines whether the SQLExecDirect statistics are written to the alternate EMS collector
when an EXECDIRECT statement is received.
SQLFETCHSTAT {ON | OFF}
determines whether the SQLFetch statistics are written to the alternate EMS collector when
a statement is closed.
SQLSTMTSTAT {ON | OFF}
determines whether the SQL statement statistics are written to the alternate EMS collector
when a PREPARE statement is received.
SESSIONINFOSTAT {ON | OFF}
determines whether session information statistics are gathered by the alternate EMS collector
when a session is terminated.
CONNINFOSTAT {ON | OFF}
determines whether connection information statistics are gathered by the alternate EMS
collector when a connection is terminated.
Considerations
• To run this command in SQL mode, you must first run the CMDOPEN command. This
command does not run in CS mode.
• The command requires an SQL terminator.
• Only users associated with roles that have OPERATOR privileges can execute this command.
For more information, see the “ADD USER Command” (page 158) or “ALTER USER
Command” (page 167).
• The wild card (*) is not supported for the data source name, and the data source name is
case-sensitive.
ALTER DS STATS Command 163