Rarely a parameter from old versions is replaced with another one with a different name (and settings as applicable) in higher versions, but it does occur at times. This article delves on how SharePlex deals with such parameters if they are set to a value other than the default from the past settings (as they existed prior to upgrade).
If a parameter is replaced with another one with a different name during upgrade and if the old parameter still exists in the paramdb file due to its non-default value, SharePlex will set it to ‘DEPRECATED’. SharePlex will not attempt to change its name in the paramdb file. The users need to do it manually after the upgrade and replace the deprecated parameter with the newly replaced one.
The following is an example:
In SharePlex 9 the parameter SP_OCT_TARGET_COMPATIBILITY is now substituted with SP_SYS_TARGET_COMPATIBILITY. When an upgrade is done from a lower version to version 9 with the parameter SP_OCT_TARGET_COMPATIBILITY set to a non-default value (8.6.2 in our case), the “list param modified” after the upgrade shows that the parameter though set is in a ‘DEPRECATED’ state:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- -
--------------
SP_OCT_TARGET_COMPATIBILITY 8.6.2 DEPRECATED
The paramdb still lists it but SharePlex will ignore the paramdb entry for that parameter as program code will not act on it:
.
.
SP_COP_TPORT 5438
SP_COP_UPORT 5438
SP_OCT_TARGET_COMPATIBILITY "8.6.2" # Replicate data according to compatibility rules for a target of this version
If the user still wants the functionality of the original parameter to be in place, then the user needs to set the new parameter to the non-default value of 8.6.2 as below:
sp_ctrl (alvsupu15:5438)> set param SP_SYS_TARGET_COMPATIBILITY 8.6.2
The list param modified shows the substitute parameter as now set though the deprecated one still shows up:
Oracle Capture parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- -
--------------
SP_OCT_TARGET_COMPATIBILITY 8.6.2 DEPRECATED
SP_SYS_TARGET_COMPATIBILITY 8.6.2 Restart Process
Default Value: 9.0.0
For the sake of tidiness one may want to remove the entry of deprecated parameter from the paramdb altogether by:
sp_ctrl (alvsupu15:5438)> reset param SP_OCT_TARGET_COMPATIBILITY
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center