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)0[mRMU/Dump/Row_Cache root-file-spec
[4mCommand[m [4mQualifiers[m x [4mDefaults[m
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.