Using journal reports to identify area updates

Document ID : KB000121659
Last Modified Date : 29/11/2018
Show Technical Document Details
Introduction:
This article describes various methods for using journal reports to determine if a given area has been updated.
Environment:
CA IDMS, all supported releases.
Instructions:
JREPORT 007 can be used to determine the usage-modes in which areas have been READYed.
However, if you need to know if actual records have been updated, you need to use JREPORT 008.

Method 1:
Using the output of a LOOK DMCL, determine the area's page range, and use that in SELECT criteria by db-key.
For example, area EMPDEMO.ORG-DEMO-REGION has page range 75,151 to 75,175.
Given the default database key radix of 8, the lowest possible db-key is x'01258F00', and the highest is x'0125A7FF'.
JREPORT=008                           
 SELECT WHEN TYPE EQ ('BFOR' 'AFTR')  
*       AND DB-KEY-A GE X'01258F00'   
*       AND DB-KEY-A LE X'0125A7FF'

Method 2:
Run one JREPORT 008 with the following syntax:
SELECT WHEN TYPE EQ 'AREA' AND AREA EQ 'ORG-DEMO-REGION'
With the output of this job, you can identify the transaction ids of all the transactions readying that area (field TRANSACT ID).
Then use these values in a second job:
SELECT WHEN TYPE EQ ('BFOR' 'AFTR')
* AND TRANSACT-ID EQ ( 12345 12346 12348 )

 
Additional Information:
JREPORT 007 - Area Summary
JREPORT 008 - Formatted Record Dump