Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Plugge, Joe — — source: IIUG Forums & Mailing Lists
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.