Some columns in the monitoring tables contain integer counter values which are incremented throughout the life of Adaptive Server. Once a counter reaches the highest value possible (2,147,483,647), it is reset to 0, which is called “wrapping.”
Because of wrapping, you should sample these counters over time and use the result of sampling instead of the returned value. For example, use the difference between the current value and the previous value instead of the return value.
The Indicators column of the monTableColumns table specifies which columns are prone to wrapping.
To display a list of columns that are counters, execute:
select TableName, ColumnName from monTableColumns where (Indicators & 1) = 1
