Most system tables are row-locked for Adaptive Server release
15.0. During upgrade, most system tables are upgraded to the datarows-locking
mode.
Adaptive Server release 15.0 provides the necessary row-locked
catalog infrastructure to support enhanced, multi-user-concurrent
data-definition language (DDL) operations. However, this release
does not change the catalog locking behavior for DDL operations.
Applications that perform heavy multi-user DDL operations (for example,
by creating or dropping tables in tempdb, will
not see any change in behaviour in this release for catalog blocking,
or any increased DDL concurency.
Table 2-12: Changed system tables
Table
|
Change
|
|---|
syscolumns
|
New fields:
New columns:
encrtype – Type
of encryption
encrlen – Length
of encrypted column
encrkeydid – Encryption
key id
encrkeydb – Database
name containing encryption key
encrdate – Date
column was encrypted.
New bits in status2 field:
Hex: 0x00000010, Decimal 16 – the
column is a computed column.
Hex: 0x00000020, Decimal 32 – the column
is a materialized computed column.
Hex: 0x00000040, Decimal 64 – the column
is a computed column in a view.
|
sysconstraints
|
New internal bit in status field: Hex
0x0100, decimal 265 – indicates a computed column object.
|
sysdevices
|
New columns:
vdevno – device
identification number
crdate – date device
created
resizedate – date
size of device changed
status2 – Additional
status2 bits.
|
sysusages
|
New column: vdevno – device
identification number
|
sysstatistics
|
New columns:
indid – index
ID of the data partition. Always 0.
partitionid – ID of the data partition
ststatus – Internal
status bits
Unique placement index on id, indid, partitionid, statid, colidarry, formatid, sequence
|
systabstats
|
New columns:
partitionid – ID
of data or index partition
statmoddate – Date
when statistics were last modified on disk.
unusedpgcnt – Number
of unused pages.
oampagecnt – Number
of OAM pages for each partition.
|
syspartitions
|
syspartitions is
completely changed from the pre-15.0 version of the table. All columns
are new. syspartitions supports both semantic
and round-robin partitioning of tables and indexes.
|
syscomments
|
New column: partitionid – ID
of data or index partition
Table enhanced to store the text of computed column or function-based
index key expression.
|
sysindexes
|
New columns:
partitiontype – partitioning
strategy: 1 – range, 2 – hash, 3 – round-robin,
4 – list
conditionid – ID of
the partition condition
New rows: contains one row for each function-based index or
index created on a computed column.
One new internal status bit added to the status2 field: Hex
0x8000, decimal 32768 – the index is a function-based index.
|
syslocks
|
New columns:
|
sysobjects
|
New object in type column: N – partition
condition
New column:
identburnmax – For
an identity column, maximum burned identity value
spacestates – Number
of space states being tracked. (Only applies for DOL tables.)
erlchgts – Timestamp
when expected row length was last changed. (Only applies to DOL tables.)
New row: one row for each computed column and function-based
index key object
type field: type “C” added
to the type field, when the object is a computed column
status2 field: new bit added
to indicate that the table contains one or more function-based indexes.
|
sysprocedures
|
Stores a sequence tree for each computed
column or function-based index definition, in binary form
|
