Chat now with support
Chat with Support

SharePlex 10.2.1 - Administration Guide

About this Guide Conventions used in this guide Overview of SharePlex Run SharePlex Run multiple instances of SharePlex Execute commands in sp_ctrl Set SharePlex parameters Configure data replication Configure named queues Configure partitioned replication Configure replication to a change history target Configure a replication strategy Configure DDL replication Configure error handling Configure data transformation Configure security features Start replication on your production systems Monitor SharePlex Prevent and solve replication problems Repair out-of-sync data Tune the Capture process Tune the Post process Make changes to an active replication environment Apply an Oracle application patch or upgrade Back up Oracle data on the source or target Troubleshooting Tips Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

Define a default port for sp_ctrl

If there is only one instance of SharePlex on a system, sp_ctrl detects the port number. However, if you configured more than one SharePlex instance on a system (where each one runs on a different port number) you must use the port command to set the session of sp_ctrl to the instance for which you want to issue commands.

sp_ctrl > port number

For more information, see Run multiple instances of SharePlex.

For more information about the port command, see the SharePlexReference Guide.

Define a default host for sp_ctrl

To define a default machine for all interactive sp_ctrl sessions, use the host command. This command enables you to enter a series of commands without using the onhost option for each one.

sp_ctr >host hostname

The command changes the sp_ctrl prompt to include the host name:

sp_ctrl (sysA) >

The host setting applies only to the sp_ctrl session in which it is set.

Set a default editor for sp_ctrl

You can set the default editor that sp_ctrl runs when you issue a command that requires input to an ASCII text file, such as a configuration file. By default, sp_ctrl runs WordPad on Windows.

The default text editors are tested and proven to work with SharePlex. If you change the default editor, the new editor must be a native ASCII text editor. Do not use a word processing program or other non-ASCII program, even if you can save a file to ASCII from that program.

Change the editor

To change the text editor for sp_ctrl on a Windows system, you must add the EDITOR variable in the Windows Registry.

Important! Incorrect Registry settings can adversely affect the operation of SharePlex. Consult a System Administrator if you need help with this procedure.

  1. Shut down the SharePlex service.
  2. Open the Run dialog. The location varies with the Windows version.
  3. In the Run dialog, type regedit to run the Registry Editor.
  4. Expand the SharePlex node:

    \HKEY_LOCAL_MACHINE\Software\Wow6432node\Quest Software\SharePlex

  5. Right click the port number of the SharePlex instance to which you want to add a variable, then select New, then String Value.
  6. Under the Name column, right click the new variable, then select Rename.
  7. Type the correct name.
  8. Double click the new variable.
  9. Under Value Data, enter the string for the new variable and then click OK.
  10. Exit the Registry.

Command guidelines

Observe the following when issuing commands:

  • To issue commands for a machine, sp_cop must be running on that machine.
  • Enter the syntax exactly as shown in the command description in the SharePlex Reference Guide.
  • The maximum string length of a SharePlex command is 255 characters, including spaces. To work around this operating-system limitation, use the edit command.

  • Use the redo command to execute the previous command again without having to retype it. This command is useful when you are making frequent status checks with the information commands, for example using the qstatus command to monitor changes in queue volume.

  • To view descriptions and syntax for SharePlex commands from within the sp_ctrl interface, issue the help command. To view just the syntax for a command, issue the usage command.

  • Use the usage command to view the syntax for a SharePlex command. You can enter the entire command or just the first few keywords. For example, type usage compare to view syntax for both the compare using and compare commands.

  • Use the edit command to edit a previously issued command.

  • Use the authlevel command to determine your authorization level for issuing SharePlex commands on a system.

For more information, see About the SharePlex security groups.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating