Introduction

PCMPJRN compares ISeries (AS/400, AS400, System i) database journal entries in the same or different journals/receivers. This is one of the commands in our ISeries utilities library (click this URL for full Prospero Software PSPUTIL contact and pricing details).

The compare stops when it detects a difference i.e. a change in any of 1) file, 2) member, 3) entry code, 4) entry type or 5) entry data. A message is then sent advising the journal sequence number(s) where the first difference is detected. The maximum number of entries to compare may be specified.

Use it to compare database updates in a controlled change environment i.e. to verify that program changes have altered the pattern of database updates (or not) as you expect. PCMPJRN saves you the tedious work of comparing DSPJRN output manually.

Examples

PCMPJRN JRN1(GLJRN/GLJRN01) SEQ1(107567) JRN2(GLJRN/GLJRN01) SEQ2(365984)

Command above compares two ranges of journal entries in the journal GLJRN01 in library GLJRN. Entries from journal sequence number 107657 are compared to entries from sequence number 365984. The compare continues until a difference is found or no more journal entries are available to compare.

PCMPJRN JRN1(GLJRN/GLJRN01) SEQ1(50) JRN2(GLJRN/GLJRN02) RCDS(500)

Command above compares entries in the journal GLJRN01 (starting at sequence number 50) to entries in the journal GLJRN02 (also starting at sequence number 50). The compare continues for a maximum of 500 journal entries until a difference is found or no more journal entries are available to compare.

Restrictions

1)	A maximum length of 500 bytes of journal entry data is compared. This can easily be increased if needs be.

IBM rebranded the AS/400 - some users called it AS400 - to ISeries several years ago and then to System i. All 4 names - ISeries, AS/400, AS400, System i - refer to exactly the same system.