RE: LASTUSED system catalog view

Hmm, something else must be bumping that date. Perhaps one of our third party products.



-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Wednesday, June 24, 2015 12:15 PM
To: Midrange Systems Technical Discussion
Subject: Re: LASTUSED system catalog view

STRSQL
CREATE TABLE ROB.MATT1 (MYCOL CHAR (5 ) NOT NULL WITH DEFAULT) Table MATT1 created in ROB.
commit
Commit completed.

DSPOBJD OBJ(ROB/MATT1) OBJTYPE(*FILE) DETAIL(*FULL) Last used date . . . . . . . . . . . :

SAVOBJ OBJ(MATT1) LIB(ROB) DEV(*SAVF) OBJTYPE(*FILE) SAVF(ROB/ROB) DSPOBJD OBJ(ROB/MATT1) OBJTYPE(*FILE) DETAIL(*FULL) Last used date . . . . . . . . . . . :


SELECT * FROM QSYS2.SYSTABLESTAT WHERE TABLE_SCHEMA='ROB' AND TABLE_NAME='MATT1'
..+..117....+..118....+..119....+..120....+..121....+.
LAST_CHANGE_TIMESTAM LAST_SAVE_TIMESTAMP
P
2015-06-24-13.06.03.000000 2015-06-24-13.07.10.000000


.125....+..126....+
LAST_USED_TIMESTAMP

-


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Matt Olson <Matt.Olson@xxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 06/24/2015 12:29 PM
Subject: LASTUSED system catalog view
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Anyone know where the LASTUSED column is on the IBM I for a file to
determine when the last DML was executed against a table?

LUW has it as documented here:
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0001063.html?cp=SSEPGG_9.7.0%2F2-10-7-97


We are trying to do some cleanup and without that feature it is going to
be an impossible task.