Download IBM Informix Migration Guide

Other sysmaster database table and column changes in
Version 9.30
Dynamic Server Version 9.30 contains a new sysmaster database table. In addition,
some tables were removed and new columns were added to a few tables.
The following tables have been added to the sysmaster database:
logmessage syscdrack_buf
syscdrack_txn syscdrctrl_buf
syscdrctrl_txn syscdrprog
syscdrq syscdrrecv_buf
syscdrrecv_txn syscdrtx
The following arc_change_log table has been deleted from the sysmaster database:
One or more columns have been added to the following system catalog tables:
sysams sysdistrib
sysprocedures sysroutinelangs
Several columns have been added to the sysdbstab system catalog table.
Remote queries on system catalog tables between Version 7.31 and
later versions
Certain system catalog tables use data types that are not supported in Dynamic
Server Version 7.31. Remote queries that issue a SELECT * statement on these
system catalog tables from Version 7.31 to later versions will fail.
For example, the following queries that originate on Version 7.31 fail if you try to
run them on a later version of the server:
SELECT * FROM dbname@remoteserver:sysindices;
SELECT * FROM dbname@remoteserver:sysindexes;
Instead of using an asterisk as the Projection clause, specify the required column
names explicitly. You cannot specify any columns that have user-defined types.
Difference in sysindexes between Version 7.31 and later versions
In Version 7.31, sysindexes is a table. In Dynamic Server Version 11.50, 11.10, 10.0,
9.40, 9.30, and 9.21, sysindexes is a view.
The ALTER TABLE statement fails for sysindexes because this statement is not
valid for altering a view.
E-6
IBM Informix Migration Guide