onmode -d command: Replicate an index with data-replication
>>-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 OneDB™ 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 OneDB 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 OneDB 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 OneDB 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.