topic Re: Using DBO/SHOW USER in a cluster in Operating System - OpenVMS

Using DBO/SHOW USER in a cluster

ChaimBu — Sun, 23 Apr 2006 07:57:51 GMT

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

Re: Using DBO/SHOW USER in a cluster

Volker Halle — Sun, 23 Apr 2006 12:34:05 GMT

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.

Re: Using DBO/SHOW USER in a cluster

ChaimBu — Mon, 24 Apr 2006 04:43:50 GMT

BRAVO !!!

Thanks a million !!

Re: Using DBO/SHOW USER in a cluster

ChaimBu — Tue, 02 May 2006 01:51:42 GMT

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?

Re: Using DBO/SHOW USER in a cluster

Volker Halle — Tue, 02 May 2006 01:55:20 GMT

Chaim,

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

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

Volker.