Cloudscape System Tables
Page 8 of 17

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)