Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

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

ChaimBu
Frequent Advisor

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

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
11 REPLIES
Kris Clippeleyr
Honored Contributor

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

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)
I'm gonna hit the highway like a battering ram on a silver-black phantom bike...
Robert Gezelter
Honored Contributor

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

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
Frequent Advisor

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

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
Honored Contributor

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

You can use rsh to all cluster nodes.

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

Wim
Wim
ChaimBu
Frequent Advisor

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

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
Honored Contributor

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

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
Honored Contributor

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

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
Don't rust yours pelled jacker to fine doll missed aches.
Robert Gezelter
Honored Contributor

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

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
Honored Contributor

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

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
Wim
ChaimBu
Frequent Advisor

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

Thanks for all the replies!!

I have written a short command procedure which runs a DBO command on an execution queue on each of the nodes and creates an output file containing the node name. I issue a wait for 10 seconds and type the files.

Works like a charm!

I am closing the thread as this is a sufficient solution!

ChaimBu
Frequent Advisor

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

THANKS !!!!