Re: Find last date updated using SQL

[Jim Oberholtzer <midrangel@xxxxxxxxxx>]

Dave,

By far and away the easiest way to do that is to run Journals on those 
files you care about and pull the information from the journals.  
Another way would be to use auditing but that my not provide you with 
the level of information you need.


Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 4/7/2011 11:02 AM, Dave Boettcher wrote:
> On a somewhat regular basis, we need to determine whether or not the data in tables in a schema have been updated.  There are about 100 tables in this schema and an update is run daily.  Not all tables are necessarily updated each day.  I  have been just doing a DSPFD and scrolling down to the member list and looking at the last change date and time for the member.
> This morning I thought there must be a way to find this using the SYS* tables created when you create a schema so that I could automate this checking process.  I have looked at QADBXREF and QADBIFLD but have only found when the table itself was last changed, not when the data changed.  So I ran DSPFD *MBRLIST to an out file and of course it's there as last change date.  But isn't there a place on the system provided tables where it would be also?
>
> All help is appreciated.
>
> TIA,
>
> Thanks,
>
> Dave B
>
> Two rules to eliminate stress:
>                 1. Don't sweat the small stuff.    2. It's all small stuff.