New system tables

Table 3-11 lists the system tables that are new in this release:

Table 3-11: New system tables

Table

Function

syscolumns

Adds the xtype and xdbid columns. These columns are used only for Adaptive Servers enabled for Java.

syscoordinations

(sybsystemdb database only.) Contains information about remote Adaptive Servers participating in distributed transactions (remote participants) and their coordination states.

sysdevices

status column utilizes a new control bit 0x4000 (16384 Decimal) to control the dsync setting for a database device file.

sysjars

Contains one row for each Java archive file retained in the database. This table is only used for Adaptive Servers enabled for Java.

syslocks

Adds the loid column.

sysprocesses

Adds the block_xloid column. The blocked column is renamed to block_xloid.

sysqueryplans

Stores query text and abstract plans for a query.

syssessions

Contains one row for each client that connects to Adaptive Server with the failover property (for example, isql -Q). This table is only used for Adaptive Servers that are configured for Sybase’s Failover in a high availability system.

systransactions

(master database only.) Contains information about Adaptive Server transactions

sysxtypes

Contains one row for each extended, Java-SQL datatype.This table is only used for Adaptive Servers enabled for Java.