Using journal reports to identify area updates

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/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.

Resolution

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