New Replication Server Counters

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.