How are SharePlex commands issued remotely using “on host” option? (4298738)

How are SharePlex commands issued remotely using “on host” option?

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.

General information.

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.

*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.