Table changes

sysindexes has the following new columns:

• partitiontype

• conditionid

• status3

The following sysindexes columns are now maintained in syspartitions:

• doampg

• ioampg

• first

• root

These columns display 0 after you upgrade. The b_partition column is now obsolete and displays 0 after you upgrade.

The syspartitions table is renamed to sysslices during the upgrade process, then the new table is empty and unused.

syscomments gains a new column called partitionid.

systabstats gains the following new columns:

• partitionid

• plldegree

• statmoddate

The systabstats columns spare2 and spare4 have been replaced with:

• pioclmdata

• pioclmindex

• piocsmdata

• piocsmindex

The following columns in systabstats have been renamed:

• spare5 has been renamed to warmcachepgcnt

sysstatistics gains a new column called partitionid.

There is a new type of object called a partition condition object, which has a row in sysobjects. A 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:

• identburnmax

• spacestate

• erlchgts

sysstatistics stores the data change counters with formatid=108. The space required by sysstatistics increases due to the additional rows stored.

sysoptions is a new fake system table has the following columns:

• spid

• scope

• name

• category

• currentsetting

• defaultsetting

• no indexes

sysattribute has the following new classes:

• password security class=14

• password downgrade clas=31

• password complexity checks class=27

• login policy class class=32

• Archive database Access class=28

The length of systypes has been modified to maxpagesize for the following datatypes: char, varchar, binary, varbinary, nchar, nvarchar, unichar and univarchar.

syslogins changes include:

• password – maximum length changed from 30 to 128.

• The following new columns:

  • lastlogindate

  • crdate

  • locksuid

  • lockreason

  • lockdate

Most system catalogs have been converted to the datarows-locking scheme. However, in Adaptive Server 15.0.2 these table locks are now shared or EX-intent locks to allow more concurrency. The row locking of the system catalogs can require an increase in the configuration parameter number of locks, depending on the DDLs in the application.

The system catalogs converted to the datarows-locking scheme do not have a clustered index with indid equal to 1. The clustered indexes now have index ID greater than or equal to 2.

syssrvroles password length has changed from 30 to 128.