Changes for version 11.70

Version 11.70 contains new sysadmin, sysuser, and system catalog tables. Version 11.70 also contains some system catalog table changes.

The system catalog now contains the following table:

  • sysfragdist

The sysadmin database contains the following new table:

  • storagepool

The sysuser database contains the following new tables:

  • sysintauthusers
  • syssurrogategroups
  • syssurrogates
  • systcxattributes
  • systcxusers
  • systrustedcontext
  • sysusermap

The sysprocedures table contains a new column, procflags.

The sysfragdist, sysdistrib, sysfragments, and sysindices tables contain new columns with information about new features, such as changes to data distribution statistics and fragmentation strategies.

The sysaudit table also contains six new columns: succ6, succ7, succ8, fail6, fail7, and fail8

The sysams system catalog table has a new column, am_expr_pushdown.

The am_param column in the systabamdata table is now an LVARCHAR(8192) data type.

The sysopclstr table is deprecated because the Informix® Optical Subsystem feature was deprecated in 11.70.xC4.


Copyright© 2018 HCL Technologies Limited