No access to SYSMAN - run a CP on both nodes of cluster

[ChaimBu]

Sometimes I need to check one of our databases if there are any blocking locks. The DBO command (DBO/SHOW LOCKS/MODE+BLOCKING) to do this is NOT cluster wide so I need to run it on both nodes of our cluster. If I had enough privs, I would run SYSMAN with /ENV=CLUSTER and issue the command procedure.

Is there any OTHER way that I can accomplish what I am attemting?

Thanks,

Chaim

[Kris Clippeleyr]

Chaim,
There are several ways.
One method that comes to mind is creating 2 identical batch queues (executor), one on each node, and submit the command proc to each of the queues.
Regards,
Kris (aka Qkcl)

[Robert Gezelter]

Chaim,

Two possibilities:

- Two batch queues, one on each member of the cluster
- Use the DECnet TASK object to execute a command file that does the DBO command.

- Bob Gezelter, http://www.rlgsc.com

[ChaimBu]

Guys,

Thanks for your replies.

I do NOT have the privs to create the queues, and this method would require reading two log files etc. Not a very elegant solution.

The suggestion running a DECNET task sounds more interesting! Could some remind me how to do this?

Chaim

[Wim Van den Wyngaert]

You can use rsh to all cluster nodes.

In decnet :
$ type node"us pw"::"task=wim.com"

Wim

[ChaimBu]

Wim,

The idea sounded good, however I suspect I don't have access to use this method. Tried what you suggested, and here's what I received:

RMS-E-ACC, ACP file access failed
SYSTEM-F-LINKEXIT, Network partner exited

Any other suggestions?

Chaim

[Volker Halle]

Chaim,

if you are limited by insufficient privileges, maybe use the batch job idea.

Write a small DCL procedure to submit a .COM file with the DBO command to 2 existing batch queues on both systems. The logfiles will end up in your SYS$LOGIN directory. Use $ SYNCH to wait for both jobs to be completed and then post-process the 2 .LOG file (minimum would be TYPE/PAGE job.LOG;0,;-1)

Volker.

[Jan van den Ende]

Chaim,

- first, check that your account has REMOTE ACCESS
- if so, check your (SY)LOGIN,COM to NOT do interactive commands in NETWORK mode (use if f$mode() .eqs. "NETWORK" , or .NES. "INTERACTIVE" - that type of construct.

- in your "wim.com" (mine would typically be jpe.com :-) ) begin with DEFINE SYS$OUTPUT SYS$NET.

.. and if this does not give the desired results, check SYS$LOGIN:NET$SERVER.LOG

hth

Proost.

Have one on me.

jpe

[Robert Gezelter]

Chaim,

Also check your LOGIN.COM (and related files) for any conditions that would generate an error on a non-network device.

Another question that should be asked is: Can you do file operations over DECnet (e.g., DIRECTORY, COPY)?

- Bob Gezelteer, http://www.rlgsc.com

[Wim Van den Wyngaert]

Your command was executed but the output was not shown (see other replies).
But if you add /out=file you can inspect the result after that.

I woul go for the rsh but I myself have a complicated T2T running that shows the output correctly, whatever the procedure that is executed.

Wim