[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
SYSERRORS
This table is created in all databases. In a synchronization system, this table holds descriptions of consistency errors that occur in replicating user transactions. In a non-synchronization system, this table is empty.
Column Name |
Type |
Length |
Nullability |
Contents |
ERRORID |
CHAR |
36 |
false |
unique identifier for the error |
ERRORTIME |
TIMESTAMP |
|
false |
time error occurred |
TRANSACTIONDBID |
CHAR |
36 |
true |
ID of database in which transaction failed |
ERRORINFO |
SERIALIZE (COM.cloudscape.types. ErrorInfo) |
|
false |
description of the error |
PUBLICATIONID |
CHAR |
36 |
true |
The publication ID for a transaction that failed when being replayed |
STMTCOUNTERS |
SERIALIZE(int[]) |
|
true |
In the usual case, the array has one element, which holds the statement number (inside the transaction) where the error occurred. In the case of nested statements (statements inside statements), there may be many cells in the array. From left to right, the cells hold the statement number (from outermost to innermost) where the error occurred. |
TRANCONTENTS |
LONG BIT VARYING |
|
true |
Holds a bit stream, which is the serialized list of replicated statements in this transaction. |
Indexes
- SYSERRORS_INDEX1 unique BTREE index on (ERRORID)
- SYSERRORS_INDEX2 BTREE index on (ERRORTIME)
- SYSERRORS_INDEX3 unique BTREE index on (TRANSACTIONDBID)
|