VMS Help  —  RMU72  Dump  After journal, Examples
    Example 1

    The following command generates a list of records associated with
    unresolved transactions in the .aij file:

    $ RMU/DUMP/AFTER_JOURNAL/STATE=PREPARED PERSONNEL.AIJ

    Example 2

    The following example shows the value to specify with the Aij_
    Buffers qualifier along with information on how frequently each
    page is accessed. The output from this example shows that you
    should specify the Aij_Buffers=29 qualifier when you recover
    aij_one.aij. In addition, it shows that pages (1:623-625) were
    referenced 37 times which means that 8.9% of all data records in
    the dumped after-image journal file reference this page.

    $ RMU/DUMP/AFTER_JOURNAL/OPTION=STATISTICS aij_one.aij
    .
    .
    .
    Use "/AIJ_BUFFERS=29" when recovering this AIJ journal
    1 recovery buffer referenced 37 times (1:623-625): 8.9%
    1 recovery buffer referenced 23 times (4:23-25): 5.5%
    1 recovery buffer referenced 22 times (4:5-7): 5.3%
    1 recovery buffer referenced 21 times (4:44-46): 5.0%
    1 recovery buffer referenced 20 times (4:50-52): 4.8%
    1 recovery buffer referenced 19 times (4:41-43): 4.6%
    2 recovery buffers referenced 18 times (4:38-40): 8.7%
    1 recovery buffer referenced 17 times (4:17-19): 4.1%
    1 recovery buffer referenced 16 times (4:29-31): 3.8%
    2 recovery buffers referenced 15 times (4:35-37): 7.2%
    1 recovery buffer referenced 14 times (4:2-4): 3.3%
    2 recovery buffers referenced 13 times (4:11-13): 6.3%
    3 recovery buffers referenced 12 times (4:8-10): 8.7%
    2 recovery buffers referenced 11 times (5:2-4): 5.3%
    4 recovery buffers referenced 10 times (4:14-16): 9.7%
    1 recovery buffer referenced 9 times (4:47-49): 2.1%
    2 recovery buffers referenced 8 times (1:617-619): 3.8%
    1 recovery buffer referenced 6 times (4:20-22): 1.4%
    1 recovery buffer referenced 2 times (1:503-505): 0.4%
    Journal effectiveness: 97.3%
    175 data records
    412 data modification records
    423 total modification records
    2 commit records
    3 rollback records

    See the Oracle Rdb Guide to Database Maintenance and the Oracle
    Rdb7 Guide to Distributed Transactions for more examples of the
    RMU Dump After_Journal command.

    Example 3

    The following example shows how to start a dump from Block 100 or
    TSN 52, whichever occurs first.

    $ RMU/DUMP/AFTER_JOURNAL /FIRST=(BLOCK=100,TSN=0:52) mf_personnel.aij

    Example 4

    This example shows how to dump committed records only.

    $ RMU/DUMP/AFTER_JOURNAL /ONLY=(TYPE=COMMIT) mf_personnel.aij

    Example 5

    This example shows the dump output when you specify an area, a
    page, and a line.

    RMU/DUMP/AFTER_JOURNAL/AREA=3/PAGE=560/LINE=1 mf_personnel.aij

    *-----------------------------------------------------------------------------
    * Oracle Rdb X7.1-00                                     3-NOV-2005
    10:42:23.56
    *
    * Dump of After Image Journal
    *     Filename: DEVICE:[DIRECTORY]MF_PERSONNEL.AIJ;1
    *
    *-----------------------------------------------------------------------------

    2/4              TYPE=D, LENGTH=122, TAD= 3-NOV-2005 10:31:12.56, CSM=00
        TID=6, TSN=0:640, AIJBL_START_FLG=01, FLUSH=00, SEQUENCE=1
            MODIFY: PDBK=3:560:1, LDBID=0, PSN=0, FLAGS=00, LENGTH=84

                                0022  0000  line 1 (3:560:1) record type 34
                             00 0001  0002  Control information
                                      ....  79 bytes of static data

    86726576696C6F54343631303000010D  0005   data '...00164Toliver.'
    5020363431411120846E69766C410420  0015   data ' .Alvin. .A146 P'
    009820876563616C50206C6C656E7261  0025   data 'arnell Place. ..'
    3330484E12208B6175726F636F684307  0035   data '.Chocorua. .NH03'
      20F03100630F72B31C00004D373138  0045   data '817M...³r.c.1ð '

    2/6              TYPE=D, LENGTH=224, TAD= 3-NOV-2005 10:31:12.56, CSM=00
        TID=6, TSN=0:641, AIJBL_START_FLG=01, FLUSH=00, SEQUENCE=3
            MODIFY: PDBK=3:560:1, LDBID=0, PSN=1, FLAGS=00, LENGTH=84

                                0022  0000  line 1 (3:560:1) record type 34
                             00 0001  0002  Control information
                                      ....  79 bytes of static data
    86726576696C6F54343631303000010D  0005   data '...00164Toliver.'
    5020363431411120846E69766C410420  0015   data ' .Alvin. .A146 P'
    009820876563616C50206C6C656E7261  0025   data 'arnell Place. ..'
    3330484E12208B6175726F636F684307  0035   data '.Chocorua. .NH03'
      20F03100630F72B31C00004D373138  0045   data '817M...³r.c.1ð '

    3/9              TYPE=D, LENGTH=330, TAD= 3-NOV-2005 10:31:12.73, CSM=00
        TID=6, TSN=0:642, AIJBL_START_FLG=01, FLUSH=00, SEQUENCE=5
            MODIFY: PDBK=3:560:1, LDBID=0, PSN=2, FLAGS=00, LENGTH=84

                                0022  0000  line 1 (3:560:1) record type 34
                             00 0001  0002  Control information
                                      ....  79 bytes of static data
    86726576696C6F54343631303000010D  0005   data '...00164Toliver.'
    5020363431411120846E69766C410420  0015   data ' .Alvin. .A146 P'
    009820876563616C50206C6C656E7261  0025   data 'arnell Place. ..'
    3330484E12208B6175726F636F684307  0035   data '.Chocorua. .NH03'
      20F03100630F72B31C00004D373138  0045   data '817M...³r.c.1ð '

    Use "/AIJ_BUFFERS=3" when recovering this AIJ journal.
    Make sure you have enough working set and pagefile quota
    for the recommended number of buffers.

    1 recovery buffer referenced 3 times (3:559-561): 50.0%
    1 recovery buffer referenced 2 times (3:436-438): 33.3%
    1 recovery buffer referenced 1 time (3:134-136): 16.6%
    Journal effectiveness: 54.5%

    3 data records
    6 data modification records
    11 total modification records
    3 commit records
Close Help