Table Usage statistics

Kirk Hampton

Table Usage statistics
Hi All,
I have a request to gather usage statistics on one of our large DB2
tables (who is accessing and how often). I think I can get this by turning on
the Security Audit trace for the subsystem, then running a DB2PM report.
Anyone have any other ideas for an easier way to extract this info ? BTW,
this is DB2 for OS/390 V5.1 on OS/390 V2.6.

Kirk Hampton
Sr. Systems Programmer
TXU Electric and Gas
Dallas, TX