Use the disable jobs and enable jobs commands to control whether jobs that are performed by the following synchronization commands are allowed to run:
The disable jobs command is a safeguard that ensures that the actions performed by those jobs do not get issued in a peer-to-peer or high-availability configuration. The command prevents the primary (trusted source) data from being overwritten with un-trusted data if a copy, append, repair, or repair using command is issued on the secondary system.
Use the enable jobs command to enable jobs on the primary (trusted) system when it becomes the active system again.
Supported targets: | Oracle |
Authorization level: | Operator (2) |
Issues on: | source system |
Related commands: | copy, append, compare, compare using, repair, repair using |
Basic command |
Command options | Remote options |
---|---|---|
disable jobs |
for o.source_SID |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
Component | Description |
---|---|
for o.source_SID |
Use this option if there is no active configuration or if there are more than one active configurations against different Oracle source instances. Examples: sp_ctrl(SysA)>disable jobs for o.ora1 sp_ctrl(SysA)>enable jobs for o.ora1 |
These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.
Option | Description |
---|---|
on host |
Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on SysA |
on host:portnumber |
Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on SysA:8304 |
on login/password@host |
Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on john/spot5489@SysA |
on login/password@host:portnumber |
Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304 |
Use the edit command in the following ways:
The edit command opens a temporary text file in the default text editor from within the sp_ctrl interface. You enter the command in the file, and it automatically executes when you save the file.
To use the edit command
At the sp_ctrl prompt, issue the edit command to open a temporary text file.
sp_ctrl(sysA)> edit
Note: SharePlex provides keyboard shortcuts for the edit command in the for of the up arrow ( ) and the forward slash ( / ) keys.
Supported targets: | All |
Authorization level: | The user must have the previous command’s authorization level or higher. |
Issued for: | The system affected by the previous command |
Related commands: | none |
Basic command | Remote options |
---|---|
edit | ed | not available |
Use the edit config command to modify an inactive configuration file. This command opens the configuration in SharePlex’s default text editor. Modify and save the configuration using the tools provided by the editor.
You cannot directly edit an active configuration. You can copy an active configuration with the copy config command, and then edit the copy with the edit config command. When you activate the copy, the original configuration deactivates.
To view a list of configurations on a system, use the list config command. To view the contents of a configuration, use the view config command.
Supported targets: | All |
Authorization level: | Operator (2) |
Issued for: | source system |
Related commands: | activate config, copy config, create config, list config, remove config, rename config, verify config, view config |
Basic command | Remote options |
---|---|
edit config filename |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
Component | Description |
---|---|
filename |
The name of the configuration that you want to edit. Configuration names are case-sensitive. Example: sp_ctrl(sysA)> edit config sales |
These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.
Option | Description |
---|---|
on host |
Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on SysA |
on host:portnumber |
Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on SysA:8304 |
on login/password@host |
Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on john/spot5489@SysA |
on login/password@host:portnumber |
Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304 |
Use the exit command to close the current session of sp_ctrl. Closing sp_ctrl does not shut down replication; all replication processes continue without interruption unless they have been stopped by a user. This command merely discontinues your session with sp_ctrl on that system. To run sp_ctrl again, change to the directory containing the SharePlex binaries and enter the ./sp_ctrl command (for Unix and Linux systems) or double-click the sp_ctrl shortcut (Windows systems).
There are no [on host] options for the exit command. It must be issued on the system where you want to stop running sp_ctrl.
This command is the same as the quit command.
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source or target system |
Related commands: | quit |
Basic command | Remote options |
---|---|
exit | e | not available |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy