I need an AS400 DB2 Query for physical file Last Used Date
Posted on 2008-10-06
I use the AS400 command "DSPOBJD" to list one or more physical files. Once the files are on the screen I put the number 5 beside a file for "Display full attributes". I hit enter and a screen is displayed showing the full object description. I page down to the next screen and one of the lines of information is "Last used date".
My question: Is it possible to create an SQL query against the SYSIBM, QSYS2, and/or other system tables to list physical files and their "Last used date" information? I have created queries for all kinds of other information like column names, etc. I cannot find any table or query for "Last used date" information. I have found "last_altered_timestamp" and so forth, but I just want the "Last used date" data displayed on the DSPOBJD" results screen. Any help is greatly appreciated.