What causes the last used date to be updated on a file?

357155 pts.
Tags:
AS/400 database
AS/400 Library
DSPOBJD
iSeries database
I have a library that has a number of files with very recent last used dates. This library is left over from the original application install and is not used anywhere that I can find. The only mention of the library is on a dsppgmref listing for the base application programs, where the library is listed 10,000+ times for the files used by the programs. The actual files in the library are not used and in many cases have no records - the records are in the live data library. So what would cause the last used date to be updated? Thanks, Carolyn

Answer Wiki

Thanks. We'll let you know when a new response is added.

1. CRTDUPOBJ

Phil

/////////

There is a lot of causes!

Take a look here

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rbam6/detob.htm

Regards,

Wilson

/////////
Thanks for the link, Wilson. I had searched the IBM website but missed that particular entry.

Unfortunately none of the listed update possibilities seem to fit the situation. Users are totally restricted to menus and the library isn’t in any library lists. We have 3 separate application environments (production) with the same base libraries on 3 different LPARs so there’s no possibility of crossover between them. Only one environment has this library but all three environments are working just fine. So I would assume that the only reason that the library is listed in the dsppgmref is due to the fact that it was the library containing the files over which the programs were originally compiled. There are no explicit references to the library in any CLPs so the files are found in the user’s library list at run time. Thus the mystery continues…

Carolyn

//////////////////////////
The Used date isn’t a save date?
Is it a date when some of the programs were recompiled?
DBU or Easy view could also changes the used date.
Phil

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • KSoniat
    We have this issue also - our file saves mark the files as "used". K
    610 pointsBadges:
    report
  • TheRealRaven
    "Unfortunately none of the listed update possibilities seem to fit..."

    It's almost certain that one of those possibilities is the reason. (In general, a simple 'save' will not update 'Last used date', but code that selects *FILE objects might cause a change. No way to know without seeing the code.)

    If DSPPGMREF shows references qualified to the library, then any/all of those could be (and probably are) causes.
    2,315 pointsBadges:
    report
  • azohawk
    You could use a trigger program on the files to track programs and other information that use the individual files.
    1,020 pointsBadges:
    report
  • TheRealRaven
    Assigning a journal would be a lot easier than crbeating and setting trigger programs.
    2,315 pointsBadges:
    report
  • ToddN2000
    Is it possible that they are being used by SQL, an SQL ALIAS , web application, WRKQRY? Are these just being used or are they being changed? I'd try Ravens suggestion and use journaling to see where and what is changing the file.
    20,880 pointsBadges:
    report
  • TheRealRaven
    Journaling should include *OPNCLO entries, especially since there might not be anything but opens and closes. This seems to be only 'Last used date' regardless of whether or not anything was changed nor even if any physical I/O happened.
    2,315 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following