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.