New counters have been added for REPAGENT, RSIUSER, SQM, DSI, and DSIEXEC:
Counter |
Description |
|---|---|
RepAgentExecTime |
The amount of time, in milliseconds, that the RepAgent user thread is scheduled by Open Client/Server™. |
RSIUExecTime |
The amount of time, in milliseconds that the RSI user thread is scheduled by Open Client/Server. |
SQMWaitSegTime |
The amount of time waiting for allocating segments. |
DSINoDsqlNULL |
Number of commands that cannot use dynamic SQL statements because of NULL value in where clauses. |
DSINoDsqlDatatype |
Number of commands that cannot use dynamic SQL statements because of text, image, java and ineligible UDDs |
DSINoDsqlRepdef |
Number of commands excluded from dynamic SQL by replication definition. |
DSINoDsqlColumnCount |
Number of commands excluded from dynamic SQL because the number of parameters exceeds 255. |
DSINoDsqlMissingCols |
Number of commands excluded from dynamic SQL because some columns are not available at DSI. This can be caused by minimal columns feature. |
DSIEDsqlPrepared |
Dynamic SQL statements prepared at target database by a Data Server Interface executor (DSI/E). |
DSIEDsqlDealloc |
Dynamic SQL statements deallocated at target database by a DSI/E. |
DSIEDsqlExecuted |
Dynamic SQL statements executed at target database by a DSI/E. |
DSIEDsqlDeallocSchema |
Dynamic SQL statements deallocated at replicate database by a DSI/E because of schema change. |
DSIEDsqlDeallocExecFail |
Dynamic SQL statements deallocated at replicate database. |
See “rs_helpcounter” in Chapter 6 “Adaptive Server Stored Procedures” in the Replication Server Reference Manual for commands to retrieve information about counters.
