Datacom last referenced date on a Datacom table

Products

• Datacom/DB

Issue/Introduction

You need a report to list the last referenced date on a Datacom table and the type of command that was run on that table ( READ/ADDIT/UPDAT/DELET) in Datacom or maybe SYSVIEW.

Resolution

There is no report available to list the last referenced date /  table command on a Datacom table.  Not in Datacom and not in SYSVEW or any other tool..

A MUF EOJ report , DBUTLTY AUTOINFO report and DBUTLTY RECOVERY REPORT have information on the tables that have been accessed  but there is no report  that exists that has the last referenced date. 

And with external security implemented in the Datacom Multi-User facility ( MUF ), there are ESM reports that can be created to report on tables that have been accessed and by whom.  But not such a report with the last referenced date. It would be too costly for the Datacom MUF to register/maintain that information.

Additional Information

MUF EOJ , DBUTLTY AUTOINFO and DBUTLTY Recovery File (RXX) Report.