×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
As an Amazon Associate we earn from qualifying purchases.