Is there any way to track the usage by User, Date, Time, and System Name each time DBU is accessed?

~ 0 min
2024-03-11 19:28

Yes. Follow the steps below to track DBU usage.

  1. CRTJRNRCV JRNRCV(USERLIB/DBUUSE0001)
  2. CRTJRN JRN(USERLIB/DBUUSEJRN) JRNRCV(USERLIB/DBUUSE0001)
  3. STRJRNOBJ OBJ(DBU10/DBUSTS) OBJTYPE(*DTAARA) JRN(USERLIB/DBUUSEJRN) IMAGES(*BOTH)
  4. Execute DBU on any file.
  5. DSPJRN JRN(USERLIB/DBUUSEJRN) OBJ((DBU10/DBUSTS *DTAARA *FIRST)) ENTTYP(EB) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE3) OUTFILE(USERLIB/DBUUSAGE)
  6. DBU the file USERLIB/DBUUSAGE and look at the data, that should show you the usage of DBU.

The image to the right shows what the data looks like. Track DBU usage

Steps 1 – 3 are done one time to setup the JOURNAL. Step 5 can be done as many times as needed to track the usage of DBU, this data will be available until you delete the Journal Receivers. You can use DBU to view the data in the output file as in Step 6 or you can create your own custom reports.

Average rating 0 (0 Votes)

You cannot comment on this entry