HELPLIB.HLB  —  RMU72  Dump  Row Cache
    Allows you to display the in-memory contents of a row cache for
    an open database.

1  –  Description

    The RMU Dump Row_Cache command is intended for use as a
    diagnostic aid that allows you to display the in-memory contents
    of a row cache for an open database. Use this command to display
    the following information for each row in the specified cache:

    o  GRIC - Address of the GRIC data structure for the cache slot

    o  GRIB - Address of the GRIB data structure for the cache slot

    o  SLOT - Slot number within the cache

    o  NXTGRIC - Slot number of the next slot within the hash chain

    o  LHMTE - Flag values indicating:

       -  L - Row is latched

       -  H - Row is marked Hot (modified since last checkpoint or
          sweep)

       -  M - Row is marked Modified

       -  T - Row is marked Too Big for (or removed from) the cache

       -  E - End of on-disk checkpoint file; should never be seen
          with the RMU Dump Row_Cache command

    o  SNAPPNO - Snapshot pointer (either snapshot page number or
       snapshot slot number

    o  LEN - Length of the row in cache; 0 indicates row has been
       deleted

    o  ACTLEN - Actual length of allocated space on the database page
       for the row

    o  DBK - Database key for the row

    o  REFCNT - Reference count: number of processes with this row in
       a cache working set

    o  UPD_PID - Process ID of process currently updating the row in
       memory

    o  RVNO - In-memory row modification count

    o  TSN - Transaction sequence number of last transaction to
       modify the row

2  –  Format

  (B)0RMU/Dump/Row_Cache root-file-spec

     Command Qualifiers                        x Defaults
                                               x
     /Cache_Name=cachename                     x None
     /[No]Data                                 x /Data
     /Output=file-name                         x /Output=SYS$OUTPUT

3  –  Parameters

3.1  –  root-file-spec

    Specifies the database root file for which you want to dump the
    row_cache contents.

4  –  Command Qualifiers

4.1  –  Cache Name

    Cache_Name=cachename

    Secifies the name of the cache you want to dump. You must specify
    the cache name.

4.2  –  Data

    Data
    Nodata

    The Data qualifier specifies that the in-memory content of a row_
    cache is to be displayed in hexadecimal format along with the
    ASCII translation. The Data qualifier is the default.

    Specify the Nodata qualifier to display only header information
    for each cache slot.

4.3  –  Output

    Output=filename

    Specifies the name of the file where output is to be sent. The
    default is SYS$OUTPUT. If you specify a file name, the default
    output file type is .lis.
Close Help