Applies to upgrades with a starting schema version less than 7.5.0.0.
You can query or manually update the IN_DB_UPGRADE_CONTROL_SYNC table to view or change the default values used during the synchronization related procedures.
Note: You can also update the default synchronization parameters by
re-executing the SYNC_SETUP procedure using either the default values or by specifying
the desrired values for the respective parameters.
- To view the current parameter defaults, execute the following query.
SELECT * FROM INUSER.IN_DB_UPGRADE_CONTROL_SYNC;
- The following is an example of updating default values.
Note: Not all columns in this table should be modified. Updating some
columns can lead to unintended behavior or prevent the package from functioning
properly. Ensure to only update the following parameters as needed.
The values used in the following example are not the defaults in some cases. See the parameter descriptions for each procedure in the Synchronization and Upgrade Procedures section.
UPDATE INUSER.IN_DB_UPGRADE_CONTROL_SYNC SET DEFAULT_MAX_MINUTES = 60 ,DEFAULT_BATCH_SIZE = 50000 ,DEFAULT_BULK_LIMIT = 10000 ,DEFAULT_DATA_TS_NAME = 'DATA' ,DEFAULT_INDX_TS_NAME = 'INDX' ,SAVE_TABLE_NAME = 'IN_DOC_SAVE' ,KEEP_SRC_TABLE = 'YES' ,VALIDATE_FK = 'YES' ,SOURCE_TABLE_DEGREE = 1; COMMIT;