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

Using DBO/SHOW USER in a cluster

SOLVED
Go to solution
ChaimBu
Frequent Advisor

Using DBO/SHOW USER in a cluster

We have a cluster of two nodes.

When we need to see if a particular database has users attached to it we would like to know if the DBO command can be used within the cluster environment without having to issue the command on each node. I might add that issuing the command via SYSMAN is not an option as the operator who has to issue the command does NOT have permissions to run SYSMAN.

Thanks,

Chaim
4 REPLIES
Volker Halle
Honored Contributor
Solution

Re: Using DBO/SHOW USER in a cluster

Chaim,

welcome to the OpenVMS ITRC forum.

I've found a link to the VAX DMBS V4.2 release notes:

http://www.sysworks.com.au/disk$cddoc04jan11/decw$book/aa%2dy304j%2d01%5fb01%5fb2.decw$book

Chapter 3.1.34 states, that the DBO/SHOW USER command only works on the local node and - as one of the alternatives - suggests to use DBO/DUMP/USERS instead, if you want to know about the clusterwide users of the database.

Volker.
ChaimBu
Frequent Advisor

Re: Using DBO/SHOW USER in a cluster

BRAVO !!!

Thanks a million !!
ChaimBu
Frequent Advisor

Re: Using DBO/SHOW USER in a cluster

This solution is almost complete. There is however a very slight problem that this command does NOT list the process name but only the PID. Is there a way to get the process name listed as well?
Volker Halle
Honored Contributor

Re: Using DBO/SHOW USER in a cluster

Chaim,

you can easily get the process name from the PID (even cluster-wide) with:

$ write sys$output F$GETJPI("pid-value","PRCNAM")

Volker.