Comparing journal images

 

You can use the Compare Journal Images (CMPJRNIMG) command to compare and list the differences between the before-image of a record and the after-image of that record, or the after-image of a record with the previous after-image of that record.

If you are using maximum receiver-size option RCVSIZOPT(*MAXOPT3) and your entry sequence numbers exceed 9 999 999 999, specify the FROMENTLRG and TOENTLRG parameters when you use the CMPJRNIMG command.

You can only use the CMPJRNIMG command for journaled physical database files. You cannot use the CMPJRNIMG command for journal entries that have minimized entry-specific data. If you specified the minimized entry-specific data (MINENTDTA(*FILE) or MINENTDTA(*FLDBDY) parameter on the Create Journal (CRTJRN) or Change Journal (CHGJRN) commands, the journal entries might have minimized entry-specific data, preventing you from being able to compare journaled images.

If the journaled files have null-capable fields, the null value indicators corresponding to the fields in the before-image of the record are compared with the null value indicators corresponding to the fields in the after-image of the record. A field-by-field basis compare does this.

The printed output from the CMPJRNIMG command shows the before-images and after-images of a record followed by a line that indicates (with asterisks) the specific change in the record on a character-by-character basis. If you compare the after-images, the output shows the previous after-image of the record and the current after-image of the record, followed by a line indicating the changes.

If you use this command to compare journal images for a file that contains any fields of data type BLOB (binary large object), CLOB (character large object), or DBCLOB (double-byte character large object), these fields are not included in the comparison. All other fields in the file are compared.

 

Parent topic:

Managing journals