ifx_replcheck question - table level restore is no
Posted in 2010
I ran across this in one of the manuals, does anybody know if this (You cannot perform a table-level restore on a table that contains the ifx_replcheck column.) is still a limitation in IDS 11.50.XC6 and beyond? Improving the Performance of Consistency Checking with an Index You can now increase the speed of a consistency check on a replicate by indexing a new shadow column, ifx_replcheck. You add the ifx_replcheck column to your replicated table using the WITH REPLCHECK clause and create a unique index on the ifx_replcheck column and your primary key columns. You can also alter an existing table to add the ifx_replcheck column. The replicated table must also have the CRCOLS shadow columns. ** You cannot perform a table-level restore on a table that contains the ifx_replcheck column. This feature is documented in the IBM Informix Dynamic Server Enterprise Replication Guide and IBM Informix Guide to SQL: Syntax. Parent topic: New Features in Version 11.50.xC5 of IBM Informix Dynamic Server