Example 1

    The following example directs the results of the RMU Show
    Statistics command to an output file:

    $ RMU/SHOW STATISTICS MF_PERSONNEL/OUTPUT=PERS.LOG

    Example 2

    The following example formats the binary results created in the
    previous example and produces a readable display:

    $ RMU/SHOW STATISTICS/INPUT=PERS.LOG

    Example 3

    The following DCL script shows a complete example of how to
    create an excessive stall notification server using the operator
    notification facility. To execute this script, submit it to any
    queue on the node from which you want to run the script. Supply
    the parameters as follows:

    o  P1 is the database pathname.

    o  P2 is the completion time.

    o  P3 is the set of operators to be notified. You must enclose
       the list of operators in quotes.

    $ VERIFY = F$VERIFY(0)
    $ SET NOON
    $!
    $! Get the database name.
    $!
    $ IF P1 .EQS. "" THEN INQUIRE P1 "_database"
    $!
    $! Get the termination date/time.
    $!
    $ IF P2 .EQS. "" THEN INQUIRE P2 "_until"
    $!
    $! Get the operator classes.
    $!
    $ IF P3 .EQS. "" THEN INQUIRE P3 "_operators"
    $!
    $ RMU/SHOW STATISTICS/TIME=1/NOBROADCAST -
          /NOINTERACTIVE /UNTIL="''P2'" /ALARM=5 /NOTIFY='P3 -
          'P1
    $ VERIFY = F$VERIFY(VERIFY)
    $ EXIT

    Example 4

    You can use the Lock_Timeout or Deadlock qualifiers to construct
    a Lock Event Logging server. The following OpenVMS DCL script
    shows how to create a server that logs both lock timeout and
    lock deadlock events on the MF_PERSONNEL database for the next 15
    minutes:

    $ RMU/SHOW STATISTICS /NOHISTOGRAM /TIME=1 /NOINTERACTIVE -
    _$ /LOCK_TIMEOUT_LOG=TIMEOUT.LOG /DEADLOCK_LOG=DEADLOCK.LOG -
    _$ /NOBROADCAST /UNTIL="+15:00" MF_PERSONNEL

    Example 5

    The following example shows stall log information first with and
    then without the lock information:

    $ RMU /SHOW STATISTICS /NOINTERACTIVE /STALL_LOG=SYS$OUTPUT: -
    _$ DUA0:[DB]MFP.RDB
     Oracle Rdb X7.1-00 Performance Monitor Stall Log
     Database DPA500:[RDB_RANDOM.RDB_RANDOM_TST_247]RNDDB.RDB;1
     Stall Log created  4-SEP-2001 11:27:03.96
    11:27:03.96 0002B8A1:1 11:27:03.67 waiting for record 118:2:2 (PR)
       State... Process.ID Process.name... Lock.ID. Rq Gr Queue "record 118:2:2"
       Blocker: 000220A7   RND_TST_24716   0F019E52    EX Grant
       Waiting: 0002B8A1   RND_TST_24715   4500C313 PR    Wait
    11:27:03.96 0002B8A8:1 11:27:02.32 waiting for record 101:3:0 (EX)
       State... Process.ID Process.name... Lock.ID. Rq Gr Queue "record 101:3:0"
       Blocker: 000220AD   RND_TST_24710   0B00176A    PR Grant
       Blocker: 000220A7   RND_TST_24716   52018A3F    PR Grant
       Waiting: 0002B8A8   RND_TST_2474    3C00B5AF EX PR Cnvrt
    11:27:03.96 0002B89C:1 11:27:00.15 waiting for record 114:4:1 (PR)
       State... Process.ID Process.name... Lock.ID. Rq Gr Queue "record 114:4:1"
       Blocker: 000220A7   RND_TST_24716   180033CC    EX Grant
       Waiting: 0002B89C   RND_TST_2479    110066BA PR    Wait

    $ RMU /SHOW STATISTICS /NOINTERACTIVE /STALL_LOG=SYS$OUTPUT: -
    _$ DUA0:[DB]MFP.RDB /OPTIONS=NOLOG_STALL_LOCK
     Oracle Rdb X7.1-00 Performance Monitor Stall Log
     Database DPA500:[RDB_RANDOM.RDB_RANDOM_TST_247]RNDDB.RDB;1
     Stall Log created  4-SEP-2001 11:28:34.68
    11:28:34.69 0002B8B8:1 11:28:33.69 waiting for logical area 146 (PR)
    11:28:34.69 0002B8A8:1 11:28:32.76 waiting for record 114:4:2 (PR)
    11:28:34.69 0002B8B3:1 11:28:33.06 waiting for record 114:4:2 (PR)
    11:28:34.69 0002B8B0:1 11:28:31.96 waiting for record 111:7:7 (EX)