delete capture queue
Use the delete capture queue command to remove a capture queue that is left over from a deprecated replication route.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Operator (2) |
| Issues on: |
source system |
| Related commands: |
delete export queue, delete post queue, delete export process |
Syntax
|
delete capture queue for datasource |
None |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| datasource |
The datasource of the capture queue as shown in the Queue Name field of the lstatus command output: sp_ctrl (mysys)> lstatus on sys102 Type # Msgs Size (Mb) Age (mn) Oldest Msg Time Newest Msg Time
------- --------- ---------- -------- ------------------ ------------------
Capture 0 2 0 11-Jan-16 11:16:02 11-Jan-16 11:16:02
Queue Name: o.ora112
Export 0 9 0 10-Jan-16 23:44:54 10-Jan-16 23:44:54
Queue Name: sysl02
DataSrc-DataDst: o.ora112-o.ora112
|
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.
| 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 |
delete export process
Use the delete export process command to remove an Export process that is left over from a deprecated replication route.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Operator (2) |
| Issues on: |
source system |
| Related commands: |
delete capture queue, delete export queue, delete post queue |
Syntax
|
delete export process to host |
queue queuename |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| host |
The name of the target system. |
| queue queuename |
Use if there are multiple Export processes on the system through the use of named export queues. For queuename, specify the name of the export queue that is linked to the Export you want to delete.
To view the Export processes and their queues, use the show export command, as shown in this example: sp_ctrl (sys1:8567)> show export Host : sysl
Queue : expquel
Kbytes
Target Status Exported Since Total Backlog
---------- --------------- ------------ ------------------ ---------- ----------
sys2 Idle 245690 05-Feb-16 18:17:39 245690 0
Deleting an Export process also deletes the post queue and Post process that are associated with it on the target system. |
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.
| 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 |
delete export queue
Use the delete export queue command to remove an export queue that is left over from a deprecated replication route.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Operator (2) |
| Issues on: |
source system |
| Related commands: |
delete capture queue, delete post queue, delete export process |
Syntax
|
delete export queue queuename |
None |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| queuename |
The name of the export queue, as shown in the Queue Name field of the lstatus command:
sp_ctrl (mysys)> lstatus on sys102 Type # Msgs Size (Mb) Age (mn) Oldest Msg Time Newest Msg Time
------- --------- ---------- -------- ------------------ ------------------
Capture 0 2 0 11-Jan-16 11:16:02 11-Jan-16 11:16:02
Queue Name: o.ora112
Export 0 9 0 10-Jan-16 23:44:54 10-Jan-16 23:44:54
Queue Name: sysl02
DataSrc-DataDst: o.ora112-o.ora112
|
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.
| 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 |
delete post queue
Use the delete post queue command to remove a post queue that is left over from a deprecated replication route.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Operator (2) |
| Issues on: |
source system |
| Related commands: |
delete capture queue, delete export queue, delete export process |
Syntax
|
delete post queue queuename for datasource-datadest |
cleartrans |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| queuename |
The name of the post queue, as shown in the Queue Name field of the lstatus command output:
sp_ctrl (mysys)> lstatus on sys103 Queues:
Type # Msgs Size (Mb) Age (mn) Oldest Msg Time Newest Msg Time
------- --------- ---------- -------- ------------------ ------------------
Post 0 5 0 10-Jan-16 23:44:54 10-Jan-16 23:44:54
Queue Name: sysl03
DataSrc-DataDst: o.ora112-o.ora112
|
| for datasource-datadest |
The route specification, as shown in the DataSrc-DataDst field of the lstatus command output:
sp_ctrl (mysys)> lstatus on sys103 Queues:
Type # Msgs Size (Mb) Age (mn) Oldest Msg Time Newest Msg Time
------- --------- ---------- -------- ------------------ ------------------
Post 0 5 0 10-Jan-16 23:44:54 10-Jan-16 23:44:54
Queue Name: sysl03
DataSrc-DataDst: o.ora112-o.ora112
|
| cleartrans |
Delete the specified post queue and remove the related rows from the SHAREPLEX_TRANS table. |
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.
| 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 |
