The following MDA tables have new columns:
monEngine
monCachedObject
monProcessObject
monCachedObject now tracks the cached pages based on indid, and partitionid.
sysindexes has the following new columns:
partitiontype
conditionid
status3
The following sysindexes columns are now maintained in syspartitions:
doampg
ioampg
first
root
These columns will have 0 after upgrade. The column base_partition is obsolete and will have 0 after upgrade.
The syspartitions table that existed prior to upgrade is renamed to sysslices during upgrade. This new table will be empty and unused.
syscomments gains new columns partitionid
systabstats gains the following new columns:
partitionid
plldegree
statmoddate
sysstatistics gains one new column called partitionid.
There is a new type of object called partition condition object. This object will have a row in sysobjects. Partition condition object is the representation of a tree for the partition table boundary conditions. The tree is stored in sysprocedures.
sysobjects has the following new columns:
identityburnmax
spacestate
erlchgts
sysstatistics stores the data change counters with formatid=108. sysstatistics space requirement increases due to the additional rows stored.
Most system catalogs have been converted to data rows lock scheme. The DDLs however continue to use the table level locks. The row locking of the system catalogs may require a increase in the configuration parameter number of locks, depending on the DDLs in the application.
The system catalogs converted to datarows lock scheme do not have a clustered index with indid equal to 1. The clustered indices now have index id greater than or equal to 2.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
