onmode -d command: Replicate an index with data-replication

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onmode-- -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 onmode -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 the onmode -d idxauto command to overwrite the value of the DRIDXAUTO configuration parameter within a session.
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 Syntax must conform to the Identifier segment; see the HCL Informix® Administrator's Guide.
index Specifies the name of the index to replicate Index must exist on table and in database specified.

Syntax must conform to the Identifier segment; see the HCL Informix Administrator's Guide.

owner Specifies the owner of a table You must specify the current owner of the table.

Syntax must conform to the Table Name segment; see the HCL Informix Administrator's Guide.

table Specifies the name of the table on which the index is based

Syntax must conform to the Table Name segment; see the HCL Informix Administrator's Guide.

The onmode -d idxauto and the onmode -d index commands 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 onmode -d idxauto command only transfers the single affected fragment, whereas the onmode -d index command transfers the whole index.


Copyright© 2019 HCL Technologies Limited