Mystery file dependency

45 pts.
Tags:
AS400 Command
dspdbr
I have an object that appears to be an index when I do a dspdbr command on an as/400 table. The object name is Q_AT000009 but has no library associated with it. I have looked on navigator for it and cannot find it.

1

Answer Wiki

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

If you try a DSPOBJD OBJ(*ALL/Q_AT000009) OBJTYPE(*FILE) what does it find? If it finds nothing what is the error?  This is a strange one. I did find a write up on the file. Not sure if you are using the same software.

Discuss This Question: 10  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.
  • BWIgreg
    No objects of specified name or type exist in library *ALL.
    45 pointsBadges:
    report
  • ToddN2000
    If the command is not returning anything, it does happen occasionally,  it may be your profile is not authorized to the file. Try running it again with a profile with more authority.
    134,930 pointsBadges:
    report
  • BWIgreg
    I tried with Qsecofr  Still nothing.
    45 pointsBadges:
    report
  • ToddN2000
    This is strange..I poked around a bit more and found an IBM SUPPORT page on the issue. It looks like you may need a couple of PTF's  
    134,930 pointsBadges:
    report
  • azohawk
    @ToddN2000  Good job finding that document, it looks rather obscure to find.
    4,055 pointsBadges:
    report
  • BWIgreg
    @ToddN2000  Thanks for taking time to find that.  I will have to pass this on to our system guy to see about the PTF apply

    45 pointsBadges:
    report
  • ToddN2000
    No problem, I love a good challenge...We can't let the machines win. :)
    Some time you see these errors if you have purchased a software package and you do not get the source code.. It point to the references on the system it was created on. 
    134,930 pointsBadges:
    report
  • TheRealRaven
    One step that may be tried is running the RCLDBXREF command. Run with the *CHECK option first (the default). If it indicates a problem, use the *FIX option; possibly also specify a library rather than using the *ERR option.

    As with any unfamiliar command, read the 'help' text carefully before execution.
    36,115 pointsBadges:
    report
  • BWIgreg
    Our ptf's finally were updated and I ran the IBM Support page recommendation and that cleaned the Q_AT... files up.   I had several more by this time
    45 pointsBadges:
    report
  • Splat
    BWIgreg, thanks for the update.
    12,915 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:

To follow this tag...

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

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

Following

Share this item with your network: