View Journal Files

View Journal Files

You can view a journal file on the Journals page of the Management Portal (System Operation > Journals).

1. On the Journals page, you can use the Filter box to shorten the list of journal files if necessary.

   If the instance is configured as a mirror member, all journal files including mirrored and nonmirrored are displayed by default. Optionally click the link containing the mirror name, for example Mirror Journal Files Of 'MUNDANE', to display a list of mirror journal files only. If the instance is configured as a reporting async member of multiple mirrors, there is a separate link for the journal files from each mirror. To return to displaying all journal files, click the All Journal Files link.

   Note:

   For information about mirror journal files, see Journal Files and Journal History Log and Mirror Synchronization.

2. To view a journal file, click View in the row of the journal file you want to see. The journal file is displayed record by record on the View Journal page. Fields include the following:

   • Offset — Offset number for the record within the journal file.

   • Time — Time at which the buffer containing this journal record was created (not the time at which the operation described in the record occurred).

   • Process — ID of the process that created the record.

   • Type — Type of operation described by the record. (The Journal File Operations table in Display Journal Records Using ^JRNDUMP provides information about the values that appear in the Type column.)

   • InTransaction — Whether or not the operation occurred as part of a transaction.

   • GlobalNode — Global node that was changed by the operation.

   • Database — Database in which the change occurred.

3. You can:

   1. Click in the Offset column of a record to view a dialog box containing its details.

   2. Choose whether to color code the records by the time of buffer creation, the process that performed the operation recorded in the journal, the type of operation, whether the operation was part of a transaction, the global involved in the operation, or the database involved in the operation.

   3. Search for a particular record set of records using the Match boxes and the Search button.

      1. For a manual search, set the first drop-down to the column you want to search by, select an operator such as “equal to” or “not equal to”, and enter the value you want to match in the right-most box, then click Search.

      2. To match a particular cell in one of the columns, just double-click in that cell. For example, to find all journal records containing KILL operations, double-click in any cell in the Type column containing KILL. The operator drop-down is automatically set to “equal to” but you can change that before pressing Search.

You can also use the ^JRNDUMP utility to display the entire journal and the SELECT^JRNDUMP entry point to display selected entries. See Display Journal Records Using ^JRNDUMP for details.