Displays information about active database users, the monitor
    log file specification, the number of monitor buffers available,
    and if after-image journal (AIJ) backup operations have been
    suspended. It allows you to see the user activity of specified
    databases on a specific node, and identifies the various nodes in
    the VMScluster where the database is currently open and available
    for use. In addition, if you are using Oracle Rdb for OpenVMS
    Alpha, this command indicates whether or not system space global
    sections are enabled.

    If you are interested in information on users for a cluster, use
    the RMU Dump command with the Users qualifier.

1  –  Description

    The RMU Show Users command displays information about all active
    database users or users of a particular database, the file
    specification for the monitor log file, the number of monitor
    buffers available, and if AIJ backup operations have been
    suspended.

    This command also displays global buffer information for the node
    on which the RMU Show Users command is issued and displays global
    buffer information for the specified database only if global
    buffers are enabled for that database.

2  –  Format

  (B)0   RMU/Show Users  [root-file-spec]

     Command Qualifier                  x Default
                                        x
     /Output[=file-name]                x /Output = SYS$OUTPUT

3  –  Parameters

3.1  –  root-file-spec

    The root file specification of the database for which you want
    information. This parameter is optional. If you specify it, only
    users of that database are shown. Otherwise, all users of all
    active databases on your current node are shown.

4  –  Command Qualifiers

4.1  –  Output

    Output[=file-name]

    Specifies the name of the file where output will be sent. The
    default is SYS$OUTPUT. The default output file extension is .lis,
    if you specify a file name.

5  –  Usage Notes

    o  To use the RMU Show Users command for a specified database,
       you must have the RMU$SHOW, RMU$BACKUP, or RMU$OPEN privilege
       in the root file access control list (ACL) of the database, or
       the OpenVMS WORLD privilege.

       To use the RMU Show Users command without specifying a
       database, you must have the RMU$SHOW, RMU$BACKUP, or RMU$OPEN
       privilege in the root file ACL of the database or databases,
       and the OpenVMS WORLD privilege.

    o  When the database monitor is completely idle, identified in
       the output of the RMU Show Users command by the "no databases
       accessed on this node" message, the number of available
       monitor messages should be 1 less than the maximum. During
       periods of monitor activity, it is normal for the number
       of available monitor buffers to be less than the maximum,
       depending on how much work remains for the monitor to process.

6  –  Examples

    Example 1

    The following command lists current users information in the file
    DBUSE.LIS:

    $ RMU/SHOW USERS/OUTPUT=DBUSE

    Example 2

    The following example shows all active users:

    $ RMU/SHOW USER

    Oracle Rdb V7.0-64 on node NODEA 27-JUN-2002 16:25:49.64
        - monitor started 26-JUN-2002 06:33:07.33 (uptime 1 09:52:42)
        - monitor log filename is "$DISK1:[LOGS]MON701_NODEA.LOG;12"

    database DISK2:[TEST]M_TESTDB.RDB;3
        - first opened 26-JUN-2002 23:24:41.55 (elapsed 0 17:01:08)
        * database is opened by an operator
        * After-image backup operations temporarily suspended from this node
        - current after-image journal file is DISK3:[TEST1]TEST3.AIJ;2
       - AIJ Log Server is active
        - 1 active database user
        - database also open on these nodes:
          NODEB
        - 23225948:1 - RDM_4 - non-utility server, USER1 - active user
            - image DISK4:[SYS1.SYSCOMMON.][SYSEXE]RDMALS701.EXE;567