The SYNC_RESET procedure resets the synchronization process for the specified table. This includes dropping all indexes (that exist) on the destination table and then truncating all the synchronization framework tables and the destination table then re-populating the destination table from the source table.
This procedure includes the following list of actions but can vary depending on which objects have been created as a result of previous executions of the UPTIME_STEPS procedure.
Disable the synchronization trigger
- Disable SYNC_TRG_DOC trigger
Reset the synchronization sequence
- Recreate the SYNC_SEQ_DOC sequence
Truncate the synchronization management tables
- Truncate the SYNC_STAGE_DOC table
- Truncate the SYNC_ERROR_DOC table
- Truncate the SYNC_STATE_DOC table
- Truncate the SYNC_HIST_DOC table
Drop indexes from the NEW_DOC table if they exist
- Drop index NEW_DOC_IDX10
- Drop index NEW_DOC_IDX11
- Drop index NEW_DOC_IDX12
- Drop index NEW_DOC_IDX2
- Drop index NEW_DOC_IDX5
- Drop index NEW_DOC_IDX6
- Drop index NEW_DOC_IDX7
- Drop index NEW_DOC_IDX81
- Drop index NEW_DOC_IDX82
- Drop index NEW_DOC_IDX83
- Drop index NEW_DOC_IDX84
- Drop index NEW_DOC_IDX85
- Drop index NEW_DOC_IDX9
- Drop index NEW_FKCS_D_DOC_TYPE_ID
- Drop index NEW_FKCS_DOC_DRAWER_ID
- Drop index NEW_FKCS_DOC_INSTANCE_ID
- Drop foreign key constraints to and from the NEW_DOC table
- Drop primary key constraint from the NEW_DOC table
- Drop Constraint PK_NEW_DOC
- Drop primary key index from the INUSER.NEW_DOC table
- Drop index PK_NEW_DOC
- Drop primary key case Insensitive Index from the INUSER.NEW_DOC table
- Drop index PKCI_NEW_DOC
- Truncate the NEW_DOC table
- Re-load of the INUSER.NEW_DOC table
- Enable the SYNC_TRG_DOC trigger
Re-populate the NEW_DOC table from the source table
- Create primary key on the INUSER.NEW_DOC table
- Create primary key constraint on the NEW_DOC table as disabled
- Create primary key index PK_NEW_DOC on the NEW_DOC table
- Enable and validate the PK_NEW_DOC primary key on the NEW_DOC table
- Create the case insensitive primary key index PKCI_NEW_DOC on the NEW_DOC table