Chat now with support
Chat with Support

SharePlex 9.2.5 - Reference Guide

About this guide Conventions used in this guide SharePlex commands SharePlex parameters General SharePlex utilities Database Setup utilities SharePlex environment variables

repair status

Use the repair status command to view the status of the last compare or repair job run. The repair status command can be used to view detailed status on a compare or repair job or a portion of a compare or repair job, or to view status on all compare and repair jobs for which SharePlex has history.

For details and examples about using the repair status command, see the job status command

Usage

Supported sources: Oracle
Supported targets: Oracle
Authorization level: Operator (2)
Issued for: source system
Related commands: copy status, append status, compare status, job status

Syntax

Basic command Command options Remote options
repair 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 ]

Syntax description

Component Description
job_id

Displays status history for the job with the specified SharePlex-assigned job ID.

Example:

sp_ctrl(sysA)> repair 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)> repair status 2828.HR.SRC_TEST3

all

Displays a summary line for every job with history in the database.

Example:

sp_ctrl(sysA)> repair 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)> repair 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)> repair status detail

status

Displays status history for previous jobs with the specified status.

Example:

sp_ctrl(SysA)> repair status “Error”

Remote options

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

report

Use this command to display the copy/append history for a table.

Usage

Supported sources: Oracle
Supported targets: Oracle
Authorization level: Viewer (3)
Issued for: source system
Related commands: copy/append

Syntax

Basic command Command options Remote options
report

source_owner.source_table

[copy | append]

[toeditor]

[for o.source_sid]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax Description

Component Description
source_owner.source_table

This option specifies a source table for the synchronization report. Allow no spaces between components of the source owner and table name.

Examples:

sp_ctrl(SysA)> report s_user1.sync_single_tbl

copy | append

This option returns results specific to either copy or append.

Examples:

sp_ctrl(SysA)> report copy s_user1.sync_single_tbl

sp_ctrl(SysA)> report append s_user1.sync_single_tbl

toeditor

This option sets the target.

Examples:

sp_ctrl(SysA)> report s_user1.sync_single_tbl toeditor

sp_ctrl(SysA)> report copy s_user1.sync_single_tbl toeditor

for o.source_sid

This option is used for specifying results specific to the provided source SID.

Examples:

sp_ctrl(SysA)> report s_user1.sync_single_tbl for o.source_sid1

sp_ctrl(SysA)> report copy s_user1.sync_single_tbl for o.source_sid1

Remote options

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

reset encryption key

Use the reset encryption key command to remove the AES encryption key that is being used by SharePlex to encrypt data.

For detailed instructions for configuring SharePlex encryption, see the SharePlex Administration Guide.

Usage

Supported sources: Oracle and SQL Server
Supported targets: All
Authorization level: Operator (2)
Issues on: source system
Related commands: create encryption key, set encryption key, show encryption key

Syntax

Basic command Remote options
reset encryption key

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Remote options

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

reset param

Use the reset param command to restore a parameter to its default value. The change takes effect based on the parameter’s set-at point:

  • For a set-at point of Live, the change takes effect immediately.
  • For a set-at point of Restart Process, the change takes effect the next time the affected SharePlex process is started.
  • For a set-at point of Restart Cop, the change takes effect the next time sp_cop is started (do not reboot the system).

Using command options

The following are guidelines for resetting SharePlex parameters.

  • To reset a parameter that was set with the set param command on a global basis (without process-specific options), use the reset param command without options.
  • To reset a parameter that has a process-specific value (set with one of the set param process-specific options), use one of the reset param process-specific options. Process- specific options can be used for parameters in the following modules:
Module Naming convention Function controlled
export SP_XPT Export process
import SP_IMP Import process
capture SP_OCT Capture process
post SP_OPO Post process
read SP_ORD Read process
     

Viewing current parameter settings

To view the names of SharePlex parameters, their values and set-at points, and whether or not process-specific values are in effect, use the list param command, as shown in the following example which shows both a global value for the Export process and a process-specific value for Export to sysB.

 

 

Parameter name Actual value Unit Set at
---------------------- --------------------- ------------ ------------
SP_XPT_SO_SNDBUF 0 bytes Restart Process

SP_XPT_SO_SNDBUF

1024 bytes Restart Process

To sysB.ABC.com

Default Value: 0

     

Usage

Supported sources: Oracle and SQL Server
Supported targets: All
Authorization level: Administrator (1)
Issued for: source or target system
Related commands: list param, set param

Syntax

Basic command Process-specific options Remote options
reset param {paramname

[to host]

[from host]

[for datasource]

[for datasource-datadest]

[queue queuename]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Important: Before you begin using this command, please review all of this documentation. Improper use could result in lost target data and out-of-sync conditions.

Syntax description

Component Description
paramname

The name of the parameter that you want to restore to its default value. This argument is not case-sensitive.

Example:

sp_ctrl(sysA)> reset param SP_XPT_SO_SNDBUF

This resets the parameter for all Export processes on the system.

Process-specific command options

Option Description
to host

This option resets an Export parameter (SP_XPT_) for the Export processes to a designated target system. To restrict the command’s effect to the Export process associated with a named export queue, follow this option with the [queue queuename] option.

Example:

sp_ctrl(sysA)> reset param sp_xpt_so_sndbuf to sysB

In this example, the parameter is reset for Export to sysB, but other Export processes are not affected.

from host

This option resets an Import parameter (SP_IMP_) for the Import processes from a designated source system. To restrict the command’s effect to the Import process associated with a named export queue, follow this option with the [queue queuename] option.

Example:

sp_ctrl(sysD)> reset param sp_imp_wcmt_msgcnt from sysC

In this example, the parameter is reset for Import from sys C, but other Import processes are not affected.

fordatasource

This option resets a Capture or Read parameter (SP_OCT_ or SP_ORD_) for a designated source Oracle instance.

  • datasource is expressed as o.SID, where SID is the ORACLE_SID of the source instance.

Example:

sp_ctrl(sysA)> reset param sp_oct_replicate_dload for o.oraA

In this example, the parameter is reset for the Capture process for instance oraA, but other Capture processes are not affected.

for datasource-datadest

This option resets a Post parameter (SP_OPO_) for all Post processes posting data from one database to another. To restrict the command’s effect to the Post process associated with a named post queue, follow this option with the [queue queuename] option.

  • datasource is expressed as o.SID, where SID is the ORACLE_SID of the source instance.
  • datadest is expressed as o.SID, where SID is the ORACLE_SID of the target instance.

Example:

sp_ctrl(sysC)> reset param sp_opo_cont_on_err for o.oraA-o.oraC

In this example, the parameter is reset for the Post process for instance oraA replicating to oraC, but other Post processes are not affected.

queue queuename

This option resets a parameter for an Export, Import or Post process associated with a designated named queue.

Example:

sp_ctrl(sysA)> reset param sp_opo_poster_delay queue QA

In this example, the parameter is reset for the Post process associated with named post queue QA, but other Post processes are not affected.

Remote options

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

Related Documents