AH Table vs Revision Reports

[Phil Frankford]

Greetings - 

I'm trying to audit and do analytics using the contents of the AH table.

1) What and how is data is kept kept on the AH table?

2) What and where is the data obtained using the Revision Report?

3) Why wouldn't the data match from both sources?

I'm running into a scenario where expected data is not found on the AH table but is found when running a Revision Report.

On 12/10/2019, failed job DRL404J runid 2913483 was found on the AH table.

Audit_20191210.xlsx    @ 12/10/2019 1:16

Job	Activation_time	Start_time	End_time	Status	RC	Status_text	host	Runid	Type
DRL404J	06-09-2019 14:05:03	06-10-2019 01:12:19	06-10-2019 01:12:30	1800	254	ENDED_NOT_OK - aborted	AECPAS-OFRAME1	2913483	JOBS

However, current reports fail to find job DRL404J runid 2913483 on the AH table.

Yet, it appears in a revision report for restarts.

20190610 013919   AE_PRD      2000  RESTART     xxxxxxxxxxxxx_xxxxxx      JOBS  2931005     2901864     JOBS.MVS.DRLDEMAN.DRL404J      U00011541 Restart for task 'JOBS.MVS.DRLDEMAN.DRL404J' (RunID '0002931005') was processed. Reference RunID: '0002913483'; Options: ''; Workflow/Schedule: '0002913478'

What am I missing?

Be Well,
Phil Frankford

[Pete Wirfs]

The AH table holds "archive header" data, and the MELD table holds "messages".  I believe the information you have displayed here comes from those two different sources.

The AH table and the MELD table have different housekeeping rules.  See variable UC_UTILITY_ARCHIVE(key=AH and key=MELD) for what those custom rules have been set to for your client.  It is possible that the data in your AH table has a shorter life span than the data in your MELD table.

------------------------------
Pete
------------------------------

[Frank Muffke]

Hi

short add to Petes explanation:

Revision report (if activated) holds its data in XAO table, Statistics are kept in AH Table.

To prevent excessive data table growth (AH, RH, RT Tables) one should run the Reorg Utilities (DB Archive (optional), DB Reorg & DB unload)
This procedure deletes old data from those (and more) tables.

The settings can be seen in VARA UC_UTILITY_REORG (seperate for every client incl. Clt 0) or just start the reorg graphical REORG utility and go to settings.

Possibly there are different settings for "Object Audit" (= Revision report or XAO table) and AH

To crosscheck you could run DB.RR utility and your SQL on AH table for today - then they should match.

cheers, Wolfgang

------------------------------
Support Info:
if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
Otherwise update/upgrade your system and check if the problem still exists.
------------------------------