Using DBO/SHOW USER in a cluster

[ChaimBu]

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

[Volker Halle · Accepted solution]

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]

BRAVO !!!

Thanks a million !!

[ChaimBu]

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]

Chaim,

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

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

Volker.