Several new system tables have been added:
SYSCHECK and SYSCONSTRAINT apply to both the IQ Store and the Catalog Store. For more information, see “SYSCHECK system table” and “SYSCONSTRAINT system table” in Sybase IQ Reference Manual.
SYSHISTORY, SYSATTRIBUTE, and SYSATTRIBUTENAME contain information about Adaptive Server Anywhere features that relate to the Catalog Store only.
Databases can hold more procedures The primary key values for the SYSPROCEDURE, SYSPROCPARM, and SYSPROCPERM system tables have been changed from SMALLINT to UNSIGNED INT. This change increases the number of procedures that a database can hold.
For more information about the number of procedures a database can hold, see Chapter 8, “Physical Limitations” in Sybase IQ Reference Manual.
To use this feature, you must upgrade the database file format.