Upgrading to Sybase IQ 15.0 adds the following system tables:
ISYSDBSPACE
ISYSDBSPACEPERM
ISYSIQBACKUPHISTORY
ISYSIQBACKUPHISTORYDETAIL
ISYSIQDBSPACE
ISYSIQMPXLOGINPOLICYOPTION
ISYSIQMPXSERVER
ISYSIQPARTITIONCOLUMN
ISYSLOGINPOLICY
ISYSLOGINPOLICYOPTION
ISYSPARTITION
ISYSPARTITIONKEY
ISYSPARTITIONSCHEME
ISYSSUBPARTITIONKEY
ISYSUSER
See “ISYSIQMPXLOGINPOLICYOPTION system table” and “SYSIQMPXSERVER system view” in Chapter A, “Multiplex Reference,”in Using Sybase IQ Multiplex.
Upgrading to Sybase IQ 15.0 removes the following system tables:
IQ_USER_LOGIN_INTO_TABLE
IQ_SYSTEM_LOGIN_INFO_TABLE
IQ_LOGIN_PER_SERVER
IQ_MPX_SERVER_PROPERTIES
IQ_MPX_INFO
IQ_MPX_STATUS
IQ_MPX_VERSIONLIST
The system tables listed in Table 2-1 are replaced. Compatibility views with the same names as the replaced tables support older versions of Sybase IQ that supported these tables.
Removed/deprecated system table/ New compatibility view |
Replacement system tables |
Corresponding system views |
---|---|---|
SYSFILE |
ISYSDBSPACE and ISYSDBFILE |
SYSDBSPACE and SYSDBFILE |
SYSINDEX |
ISYSIDX |
SYSIDX |
SYSIQCOLUMN |
ISYSIQTABCOL |
SYSIQTABCOL |
SYSIQFILE |
ISYSIQDBFILE |
SYSIQDBFILE |
SYSIQINDEX |
ISYSIQIDX |
SYSIQIDX |
SYSIQJOININDEX |
ISYSIQJOINIDX |
SYSIQJOINIDX |
SYSIQTABLE |
ISYSIQTAB |
SYSIQTAB |