-
Title
How are SharePlex commands issued remotely using “on host” option? -
Description
A number of SharePlex commands can be executed remotely via sp_ctrl interface from another server. The “on host” option is used when running commands this way. This article delves on what is involved when using this option.
-
Cause
General information. -
Resolution
Most SharePlex commands can be issued remotely using “on host” option provided the user executing such commands has the requisite privileges to issue the command. There are 3 users configured to manage SharePlex. They are spadmin, spopr and spview with magnitude of privileges in that order, meaning spadmin is the most privileged and spview is the least privileged user. For every command, there is a para named ‘Usage” followed by the para named “Syntax”. The “Usage” lists the user who can issue that command which also means that a user with higher privileges can also issue that command. The User para mentions spadmin. Spopr and spview as Administrator, Operator and Viewer respectively. For example, the following is the Usage para for qstatus command:
Usage
Supported targets: All
Authorization level: Viewer (3)
As an example my source machine is called source_server and my target machine is called target_server.
The qstatus on my target shows the following:
sp_ctrl (target_server:2100)> qstatus
Queues Statistics for target_server
Name: post_queue_name(o.ORA11GR2-o.syam) (Post queue)
Number of messages: 1 (Age 0 min; Size 1 mb)
Backlog (messages): 1 (Age 0 min)
Now I want to get qstatus for my target while I am logged in to the source. Here is what I need to do:
sp_ctrl (source_server:2100)> qstatus on target_server
Please supply a login and password for target_server:
login: oracle
password:
Queues Statistics for source_server
Name: post_queue_name(o.ORA11GR2-o.syam) (Post queue)
Number of messages: 1 (Age 0 min; Size 1 mb)
Backlog (messages): 1 (Age 0 min)
In the above, note that for the command to execute successfully I have to provide login and password of any user with appropriate privilege that exists on target. Moreover, the output is titled “Queues Statistics for source_server” which may be a misnomer as it is providing me the output of qstatus for the target server.
Likewise any command that allows “on host” option can be issued remotely by providing the appropriate credentials of a user on that remote machine who is authorized to issue that command.
-
Additional Information
*The Reference Guide states that you are prompted for login credentials for the remote system but does not tell credentials for which user or does not illustrate its use. * Wherever the “on host” option is available to remotely issue the command, the Authorization level is also specified for that command. So depending on what privileges are required for issuing that command, you can provide the credentials of that remote user.