The verify config command is intended for use as a preventive measure to avoid certain activation and replication problems. It is intended to be used to test activation to ensure that it will complete successfully.
The verify config command verifies tables and sequences only.
This command can be used to:
The verify config command does not:
To verify objects that you want to add to an active configuration or objects that you want to change (such as routing changes), it is suggested that you copy and modify the active configuration and then run the verify command against that copy.
You can use the verify config command for configurations containing tables that use partitioned replication. While SharePlex supports the use of verify config with partitioned replication, it does not include any additional functionality for verifying partitions or their definition.
The verify config command retains control of the sp_ctrl interface until the verification is completed.
The command will read the entire config file, logging errors and duplicates, and expanding objects falling under wildcards.
The results of the verify are displayed to the screen within sp_ctrl. If you would like to view detailed results you may:
Supported sources: | Oracle |
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source system |
Related commands: | activate config, copy config, create config, edit config |
Basic command | Command options | Remote options |
---|---|---|
verify config filename | detail |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
Component | Description |
---|---|
filename |
filename is the name of the configuration to be verified. |
detail |
This option will display a greater level of detail to the screen. Example: sp_ctrl(sysA)> verify config myconfig detail In this example, the myconfig file will be verified and the results will be displayed with a higher level of detail. |
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 version command to view the version number of the SharePlex software on a system.
Supported sources: | Oracle |
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source or target system |
Related commands: | none |
Basic command | Remote options |
---|---|
version |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
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 view config command to view the contents of an active or inactive configuration file from within the sp_ctrl interface.
Use it when:
Note: To edit a configuration, use the edit config command. To change an active configuration, it is recommended that you copy it with the copy config command and then edit the copy.
Supported sources: | Oracle |
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source system |
Related commands: | activate config, copy config, deactivate config, edit config, list config, remove config, rename config, verify config |
Basic command | Remote options |
---|---|
view config filename |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
Component | Description |
---|---|
filename |
The name of the configuration file that you want to view. Configuration names are case-sensitive. Example: sp_ctrl(sysB)> view 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 view log options command to view the default values for the show log command.
Example display:
sp_ctrl(sysA)> view log options
Log current display options:
direction = reverse
maxlines = 50
lpp = 30
These parameters can be changed with the set log command, or with options within the show log command itself.
Supported sources: | Oracle |
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source or target system |
Related commands: | set log, show log |
Basic command | Remote options |
---|---|
view log options |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
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 |
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center