How to find last RUN date of a Query on AS/400?
My system currently has 2000+ queries defined. Not all are active. Is there a way to determine the LAST RUN DATE of a query as opposed to the LAST CHANGE date. Most of our queries are not resaved (ie 'changed') each time they are run. Thanks in advance for your help.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 16, 2005 3:00 PM
UPDATED:
November 11, 2009 6:12 AM
Answer Wiki:
I suggest DSPOBJD thequery *QMQRY then use 5 or 8, there is a page that shows number of days usage and last day uses. I have not checked if info is correect for *QMQRY, but i am sure it is correct for *PGM.
After having targetted info for one query, uses DSPOBJD ... OUTPUT(*FILE) for mass run
If necessary, you can turn number of days used to zero by
- rebuilding the object or
- changing this info with CHGOBJATR (available at http://jplamontre.free.fr/jpltools.htm)
To see all answers submitted to the Answer Wiki: View Answer History.
If you take a look at Chapter 4 of the CL Programming Guide (SC41-5721) It shows a table of object types and what causes their usage information to be updated.
For QMQRY it states……”When used to generate a report OR when extracted or exported”.
Paul, pardon mebut where can I find that guide … thanks in advance and appreciate the info
Easiest way to find the info is simply by looking at the section in the Information Center named ‘Detecting unused objects on the system’. If you don’t know how to find that section, try entering something like ‘Detecting unused objects on the system’ in the search field and pressing <enter>.
In case you can’t find the Information Center <==click here.
Tom