Monitoring Tables

New and changed monitoring tables for Adaptive Server 15.0.3

New monitoring tables

Table

Description

monSQLRepActivity

Provides statistics for all open objects on DML statements replicated using SQL statement replication.

monSQLRepMisses

Provides statistics for replicated operations for which SQL statement replication was not used. The threshold, querylimitation and configuration columns indicate the number of times that one of these factors prevented SQL statement replication for the object

Changed monitoring tables

Monitoring table

Description of change

monSysStatement, monSysPlanText, and monSysSQLText

The values of the columns BatchID, ContextID, ProcedureID, and PlanID have been modified.

monSysStatement

Supports two new columns: ProcNestLevel and StatementNumber.

See the Reference Manual: Tables.