CA IDMS/DB Journal Reports—JREPORTS › JREPORT 009 - User ID

JREPORT 009 - User ID

JREPORT 009, the User ID report enables compliance and audit reporting. JREPORT 009:

• Lists the user ID from every transaction with the date, time, and program associated with that transaction.
• Considerations:
  • If you want to capture information about retrieval only transactions, you must specify JOURNAL RETRIEVAL.
  • If you want to capture information from local batch jobs, you must capture the journal records (many sites take a backup of their database for recovery purposes when running a local mode update job rather than writing the local mode journal file.)
  • Many CICS applications or web-based applications capture the user ID on the client side of the application and use a generic user ID to access the data from the database. In these cases, the generic user ID is captured in the BGIN checkpoint record.

The following report shows one page from a sample User ID report:

Sample JREPORT 009:

REPORT NO. 09                           IDMS JOURNAL REPORTS       Rnn.n                     mm/dd/yy      PAGE    1
JREPORT 009                                 USER ID JOURNAL REPORT
         USER              UTC         UTC       TRANSACT   PROGRAM    LOCAL       LOCAL
          ID               DATE        TIME         ID        NAME      DATE        TIME

  USERA01                mm/dd/yy  hh.mm.ss.ht           5  RHDCRUAL  mm/dd/yy  hh.mm.ss.ht
  USER ID NOT CAPTURED   mm/dd/yy  hh.mm.ss.ht           6  IDMSDDDL  mm/dd/yy  hh.mm.ss.ht
  USERA01                mm/dd/yy  hh.mm.ss.ht           7  RHDCRUAL  mm/dd/yy  hh.mm.ss.ht
  NO USER SIGNON         mm/dd/yy  hh.mm.ss.ht           8  RHDCRUAL  mm/dd/yy  hh.mm.ss.ht
  USERA01                mm/dd/yy  hh.mm.ss.ht           1  WFAUPDAT  mm/dd/yy  hh.mm.ss.ht
  C750009 RECORDS WRITTEN FOR REPORT 09 --           8