Sybase has updated the system tables for Adaptive Server 15.0 to reflect the changes for semantic partitions and encrypted columns, adding new system tables and extending others to include partition information, and adding new objects to the object classes. These changes may affect third-party tools and custom scripts.
See What’s New in Adaptive Server Version 15.0? for more information.
Although earlier versions of Adaptive Server reported disk space allocations in sysindexes, Adaptive Server 15.0 reports disk space allocations in syspartitions. Table 5-2 describes the space pointers for earlier releases of Adaptive Server and their equivalents in syspartitions in Adaptive Server 15.0.
Type of space association |
Column names in sysindexes in earlier versions |
15.0 syspartitions equivalent |
|---|---|---|
Unique row |
id + indid |
id+indid+partionid |
First page |
first |
firstpage |
Root page |
root |
rootpage |
Data OAM page |
doampg |
datoampage |
Index OAM page |
ioampg |
indoampage |
You must change custom DBA scripts or previous dbcc commands that used these locations to reflect the current implementation. Sybase has already modified the published dbcc commands. If you used previously undocumented dbcc commands (such as dbcc pglinkage()), these may fail because they have been deprecated or simply not maintained. If a data corruption problem occurs, contact Sybase Technical Support for the correct procedures for Adaptive Server 15.0. Continuing to use undocumented dbcc commands from earlier versions may cause corruptions.
