Use the hostinfo command to view information about a system’s hardware, including the operating system, machine name, OS version and revision. This is an example of the command’s output:
HP-UX sys1 B.11 A 9000/861
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source or target system |
Related commands: | none |
Basic command | Remote options |
---|---|
hostinfo |
[ 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 job status command to view the status of the last compare, compare using, repair, repair using, copy or append job, and for any other jobs that are still running. The job status command can be used to view detailed status on a job or a portion of a job, or to view status on all jobs for which SharePlex has history. SharePlex retains the history for all jobs as specified by the SP_SYS_JOB_HISTORY_RETENTION parameter. See the clear history and remove log commands for information on actively removing history and/or job process logs.
sp_ctrl (sysA) > job status
Job ID | : 861 |
PID | : 20571 |
Host | : sysa.domm.com |
Started | : 06-NOV-12 11:07:05 |
Job Type | : Compare |
Status | : Processing - 4 objects completed |
ID | Tablename | Status | Time | Total rows | %Comp | Total time |
---|---|---|---|---|---|---|
--- | ------------------------- | -------- | --------- | ------------------ | ------ | ----------- |
1 | "SCOTT"."SRC_TEST1" | Out Sync | N/A | 19 | 100 | 0:05 |
4 | "SCOTT"."SRC_TEST4" | WaitMarker | 0:02 | 27392 | 0:04 | |
5 | "SCOTT"."SRC_TEST5" | Init | 0:01 | 27498 | 0:01 |
To view a summary of all jobs for which SharePlex has history:
sp_ctrl (alvspxl11:8567)> job status all
Job ID | Type | filename/tablename | Status | Started | Completed |
---|---|---|---|---|---|
------- | ------ | ------------------ | -------- | --------------- | ----------------- |
3441 | Compare | prod.conf | Done - errors | 16-DEC-11 15:39 | 16-DEC-11 15:40 |
3442 | Repair | scott.src_test4 | Done | 16-DEC-11 15:50 | 16-DEC-11 15:50 |
3443 | Repair | prod.conf | Done | 19-DEC-11 10:42 | 19-DEC-11 10:42 |
3444 | Copy | "SCOTT"."SRC_TEST5" | Done | 19-DEC-11 10:43 | 19-DEC-11 10:43 |
3445 | Compare | scott.src_test33 | Done - errors | 20-DEC-11 12:02 | 20-DEC-11 12:03 |
To view the status of a job with detail:
sp_ctrl (alvspxl11:8567)> compare status detail
Job ID | : 3448 |
PID | : 763 |
Host | : sysa.domm.com |
Started | : 20-DEC-11 12:40:46 |
Job Type | : Compare |
Status | : Done - 6 objects completed |
Table ID | : 3448.3 |
Table | : "SCOTT"."SRC_TEST3" |
From | : sysa.domm.com@o.w111a64f |
To | : "SYSPROD"."SRC_TEST3" sysb.domm.com@o.w111a64f |
Started | : 20-DEC-11 12:40:55 |
Percent complete | : 100% |
Total Rows | : 234452 |
Rows processed | : 234452 |
Rows out-of-sync | : 2 |
Status | : Out Sync |
Status Elapsed | : N/A |
Total Elapsed | : 0:07 |
Inserts | : 2 |
Updates | : 0 |
Deletes | : 0 |
Supported targets: | Oracle |
Authorization level: | Operator (2) |
Issued for: | source system |
Related commands: | copy status, append status, compare status, repair status |
Basic command | Command options | Remote options |
---|---|---|
job status |
[job_id] [job_id.table_id] [all] [full] [detail] [status] |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
Component | Description |
---|---|
job_id |
Displays status history for the job with the specified SharePlex-assigned job ID. Example: sp_ctrl(sysA)> job status 2828.2 |
job_id.table_id |
Displays status history for the job with the specified SharePlex-assigned job ID and table. Example: sp_ctrl(sysA)> job status 2828.HR.SRC_TEST3 |
all |
Displays a summary line for every job with history in the database. Example: sp_ctrl(sysA)> job status all |
full |
Displays the status of every object in the job. By default, the job status command displays the status of those objects not completed, or completed with an exceptional status. Example: sp_ctrl(sysA)> job status2828 full |
detail |
Displays detail information for every object reported upon. By default, the job status command displays a summary line for every object reported upon. Note that the detail information is the same as is displayed for the job_id.table_id option. Example: sp_ctrl(sysA)> job status detail |
status |
Displays status history for previous jobs with the specified status. sp_ctrl(SysA)> job status “Error” |
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 list config command to view a list of all active and inactive configurations on a source system. The command displays the following information:
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source system |
Related commands: | view config, show config |
Basic command | Remote options |
---|---|
list config |
[ 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 list param command to display SharePlex tuning parameters. Without options, the command displays the basic (user configurable) parameters and their current settings. Options are available for displaying:
Either of the preceding options filtered according to the SharePlex module.
Parameters are grouped by module, each module representing a functional component of the software. The following table lists the modules that contain user-configurable parameters (which can be changed without guidance from Quest).
Module | Naming convention | Function controlled |
---|---|---|
analyze | SP_ANL | analyze config command |
capture | SP_OCT | Capture process |
compare | SP_DEQ | compare commands |
config | SP_OCF | configuration activation process |
cop | SP_COP | sp_cop |
export | SP_XPT | Export process |
import | SP_IMP | Import process |
logging | SP_SLG | the SNMP feature |
post | SP_OPO | Post process |
open | SP_OPX | Open Target Post process |
queue | SP_QUE | the SharePlex queues |
read | SP_ORD | Read process |
SNMP | SP_SNMP | SNMP support |
sync | SP_OSY | the copy/ append commands |
system | SP_SYS | system-related items |
Each list param display provides the parameter’s:
See Descriptions of user-configurable parameters for more information about SharePlex parameters.
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source or target system |
Related commands: | set param, reset param |
Basic command | Command options | Remote options |
---|---|---|
list param |
[basic | all | modified] [module] |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
Component | Description |
---|---|
basic |
This option displays parameters that can be set by users without guidance from a Quest support engineer or technical specialist. Example: sp_ctrl(sysA)> list param basic |
all |
This option displays all of the SharePlex parameters, including basic (user-configurable) parameters and internal parameters (whose settings you should not change without guidance from Quest). Example: sp_ctrl(sysA)> list param all |
modified |
This option lists the user-configurable and internal parameters that have been modified from their default values. Example: sp_ctrl(sysA)> list param modified |
module |
This option constrains the output to parameters for a specific module. See SharePlex parameter modules. This option, if used, must appear after the list param [all | modified] syntax. Example: sp_ctrl> list param all post In this example, SharePlex displays all parameters for the Post process. |
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 |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy