View previous topic :: View next topic
|
Author |
Message |
Mike 1304
New User
Joined: 15 Oct 2011 Posts: 46 Location: Germany
|
|
|
|
Hi,
I want to make housekeeping.
I have some old tables with configuration data of some applications.
The tables are not changed the last 10 years.
But I do not know, if anyone still reads this tables.
The tables are in production and could be useed by some important applications. So try and error (rename) is a risky way.
And: I think reading SMF records of the last 10 years is not a solution.
How can I check when the last read access take place?
Mike |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
Ttry,
1.LASTUSED col in SYSIBM.SYSINDEXESTATS
2.CRUD SQL |
|
Back to top |
|
|
|