Scrolling might be necessary to view the entire output of certain sp_ctrl commands. If your Command Prompt window does not have a scroll bar, you can change the window properties to produce one.
In the Command Prompt Properties dialog box, click the Layout tab.
In the Screen Buffer Size option box, increase the Height value until it produces a scroll bar in the Command Prompt window.
In the Apply Properties To Shortcut dialog box, select one of the options, either to apply the new properties to the current command session or to apply them as the new default for all sessions.
SharePlex parameters control and tune various aspects of replication.
A SharePlex Administrator (defined as a member of the SharePlex Admin group) can change parameters that are designated as user-configurable and is the only user authorized to do so.
Use the list param command in sp_ctrl to view user-configurable SharePlex parameters. It displays parameter names, current settings, default values (if the parameter has been changed), and set-at points. The set-at point indicates when changes to a parameter will take effect. Possible set-at points are:
Additional options are available for viewing:
To view descriptions of the SharePlex parameters, see the SharePlex Reference Guide.
Parameters can be set in the following ways:
Parameters for the Capture, Read, Export, Import, and Post processes can be set on a per-process basis when there are multiple instances of a process for an instance of SharePlex.
The recommended way to change a SharePlex parameter is to use the set param command in sp_ctrl.
To restore a parameter’s setting to its default value, use the reset param command.
On Unix and Linux, a SharePlex parameter can be set as an environment variable. The environment variable overrides the setting in the param-defaults files, but only for the session of sp_cop for which it was set. If you shut down sp_cop and restart it without resetting the environment variable, SharePlex uses the default setting in the param-defaults file.
Note: On Windows systems, SharePlex environment variables must be set through the Windows Registry. See the SharePlex Administrator’s Guide for more information.
To set a SharePlex parameter as an environment variable on Unix and Linux systems, use one of the following commands. Set the environment variable before starting sp_cop or, if sp_cop is running, restart sp_cop for the new setting to take effect.
$ export parameter_name=value
$ setenv parameter_name value
Because of the temporary nature of environment variables, avoid using them if possible; instead make your changes with the set param command. When you rely on environment variables, especially when there are multiple users of SharePlex, you incur the risk of someone forgetting to set them (or using an incorrect value) when they restart sp_cop. That can have a significant, negative impact on replication and can result in the need to resynchronize the data.
The following files store SharePlex parameter settings:
The param-defaults file stores default settings that were set by developers for optimal replication performance under most conditions. The param-defaults file resides in the data sub-directory of the SharePlex product directory. The data in this file does not change unless a new version of SharePlex is installed.
Important:Never edit this file. To change a parameter’s value, see View and set parameters
The paramdb file stores user-defined parameter settings — values that were changed from their defaults by a SharePlex Administrator using the set param command. Also stored in this file are the SharePlex license key for the local system, the Share- Plex Oracle user, and the SharePlex user’s password.
The paramdb resides in the data sub-directory of the SharePlex variable-data directory. It starts out empty, and as SharePlex Administrators change parameter values, those values are added to it. User-defined parameter values override SharePlex default values when SharePlex is running. All of the settings in the paramdb file remain intact when a new version of SharePlex is installed.