Table 3-11 lists the system tables that are new in this release:
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. |