Re: display last used date for a source member

You mean something like this:

SELECT SYSTEM_TABLE_SCHEMA as Library,
SYSTEM_TABLE_NAME as table,
SYSTEM_TABLE_MEMBER as member,
LAST_CHANGE_timestamp as last_changed,
LAST_USED_TIMESTAMP as last_used
FROM syspartitionstat

....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9
LIBRARY TABLE MEMBER LAST_CHANGED LAST_USED

#CGULIB QS36PRC #CGU 2010-03-13-09.09.34.000000 -
#DFULIB QS36PRC #ENTER 2010-03-13-09.09.28.000000 -
#DFULIB QS36PRC #INQUIRY 2010-03-13-09.09.28.000000 -
#DFULIB QS36PRC #LIST 2010-03-13-09.09.28.000000 -
#DFULIB QS36PRC #UPDATE 2010-03-13-09.09.28.000000 -
#DFULIB QS36PRC #DFMP 2010-03-13-09.09.28.000000 -
#DSULIB QS36PRC #DSU 2010-03-13-09.09.31.000000 -
#IDDUMSC QIDCTP02 QIDCTLC 2006-10-21-02.01.59.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP10 QIDCTP10 2006-10-20-22.43.39.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP20 QIDCTP20 2006-10-21-00.40.26.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP21 QIDCTP21 2006-10-21-03.08.34.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP25 QIDCTP25 2006-10-21-00.48.08.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP30 QIDCTP30 2006-10-20-21.54.41.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP31 QIDCTP31 2006-10-21-00.14.52.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP51 QIDCTP51 2006-10-21-02.10.48.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP52 QIDCTP52 2006-10-21-03.34.08.000000
2008-11-28-00.00.00.000000
#IDDUMSC QIDCTP53 QIDCTP53 2006-10-21-02.19.46.000000
2008-11-28-00.00.00.000000
#IDDUTPF QIDCTP02 QIDCTLC 2006-10-21-01.57.42.000000
2008-11-28-00.00.00.000000
#IDDUTPF QIDCTP10 QIDCTP10 2006-10-21-01.13.50.000000
2008-11-28-00.00.00.000000

Then, no, I don't think that IBM i has anything like that.

:-)

Rob Berendt