SYSTEM.COUNTER is a pseudotable that contains internal
system counters. While the statistics are primarily
for SQLCore's internal use, you can use these statistics
to monitor DBEnvironment use and make appropriate
changes to your DBEnvironment and/or application programs.
For example, you can use the DEADLOCK
counter to determine if the number of deadlocks is
excessive, and the CHECKPTS counter to determine if you
need to change the size of the log file.
Values in SYSTEM.COUNTER are continually incremented
from the time of a START DBE
until you issue the RESET statement, which sets all
counter values to 0.
The counters are automatically reset each time the DBE is started.
Some of the rows in this system view
are reserved. They are designated as
'UNUSED' when you select all entries from the
table, and can be deleted from your query with the following statement:
isql=> SELECT * FROM System.Counter
> WHERE NAME <> 'UNUSED';
|
SYSTEM.COUNTER supports an unlimited number of users,
transactions, and sessions.
Table 8-11 System.Counter
|
Column Name | Type | Length | Description |
|---|
| NAME | CHAR | 8 | Name of counter
|
| VALUE | INTEGER | 4 | Counter value (time values
are in milliseconds)
|
| DESCRIPTION | CHAR | 20 | Description of the counter
|
Example |
 |
SELECT * FROM System.Counter;
--------+-----------+--------------------
NAME |VALUE |DESCRIPTION
--------+-----------+--------------------
TRANSBEG| 6|Transactions begun
TRANSEND| 4|Transactions ended
TRANSABT| 0|Transactions abort
CHECKPTS| 0|Checkpoints
LOCKREQS| 86|Lock requests
SHLTREQS| 69|Shared latch reqs
EXLTREQS| 537|Excl latch reqs
DEADLOCK| 0|Deadlocks
PAGEACCS| 152|Page accesses
PAGEREAD| 30|Page reads
PAGEWRTE| 0|Page writes
LGBLKRD | 17|Log block reads
LGBLKWR | 0|Log block writes
LGRECWR | 0|Log record writes
ERRORLG1| 0|Errors on log ds 1
ERRORLG2| 0|Errors on log ds 2
---------------------------------------------------------------------------
First 16 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> b
--------+-----------+--------------------
NAME |VALUE |DESCRIPTION
--------+-----------+--------------------
UNUSED | 0|------------------
UNUSED | 0|------------------
TIMEOUTS| 0|Expired timeouts
UNUSED | 0|------------------
UNUSED | 0|------------------
UNUSED | 0|------------------
UNUSED | 0|------------------
UNUSED | 0|------------------
RESETS | 1|Number of Resets
DBCALL | 117|DBCORE calls
SHLTWAIT| 0|Share latch waits
EXLTWAIT| 0|Excl latch waits
LOCKWAIT| 0|Lock waits
IO | 79|I/O s
SERVREQS| 0|Service requests
---------------------------------------------------------------------------
Number of rows selected is 31
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
