Replicate an Index with Data-Replication

Home | Previous Page | Next Page Administrative Utilities > Changing Modes and Shared Memory with the onmode Utility >

Replicate an Index with Data-Replication

Replicate an Index:
 
|-- -d--+-idxauto--+-on--+------------------------+-------------|
        |          '-off-'                        |
        '-index--database:-+--------+-table#index-'
                           '-owner.-'

Element	Purpose	Key Considerations
-d	Specifies how indexes are replicated to a High-Availability Data-Replication (HDR) secondary server when an index on the secondary server becomes corrupt	You can use the onmode -d idxauto and -d index commands while the server is in online mode.
idxauto	Enables automatic index replication when an index on a secondary server becomes corrupt	Use onmode -d idxauto to overwrite the value of the DRIDXAUTO configuration parameter within a session. References: For more information on DRIDXAUTO, see DRIDXAUTO. For more information on replicating indexes, see the chapter on using HDR in the IBM Informix Administrator's Guide.
index	Replicates an index from a primary to a secondary server	If you detect a corrupt index on a secondary server, use the onmode -d index command to start replication of the index from the primary to the secondary server.
database	Specifies the database containing the index to replicate	References: Syntax must conform to the Identifier segment; see IBM Informix Guide to SQL: Syntax.
index	Specifies the name of the index to replicate	Restrictions: Index must exist on table and in database specified. References: Syntax must conform to the Identifier segment; see IBM Informix Guide to SQL: Syntax.
owner	Specifies the owner of a table	Restrictions: You must specify the current owner of the table. References: Syntax must conform to the Table Name segment; see IBM Informix Guide to SQL: Syntax.
table	Specifies the name of the table on which the index is based	References: Syntax must conform to the Table Name segment; see IBM Informix Guide to SQL: Syntax.

The -d idxauto and the -d index options provide methods to replicate an index to a secondary server containing a corrupted index. The base table will be locked during the transfer of an index. The alternative to using these options is to drop and rebuild the corrupt index on the primary server.

In the case of a fragmented index with one corrupt fragment, the -d idxauto option only transfers the single affected fragment, whereas the -d index option transfers the whole index.