Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Find out which object is not saved

Posted on 2014-10-27
2
Medium Priority
?
262 Views
Last Modified: 2014-11-12
With SAVLIB, I have a message saying, "1 file is not saved" and I know the library name. How can I find out which object that was?
0
Comment
Question by:exhuser
2 Comments
 
LVL 35

Expert Comment

by:Gary Patterson
ID: 40407158
Display the job log for the job doing the save.
0
 
LVL 27

Accepted Solution

by:
tliotta earned 1500 total points
ID: 40410508
Assuming you have the joblog available, that's the place to look. If it's not available, you can check the object descriptions of the files in your library to see which one doesn't have the same Save Date as the others.

So, for a start:
DSPOBJD OBJ( mylib/*ALL) OBJTYPE(*FILE) OUTPUT(*OUTFILE) OUTFILE(QTEMP/OBJ)

Open in new window

That creates a list of all *FILE objects in library "mylib". You can then run a couple SQL statements:
SELECT ODSDAT FROM qtemp/obj GROUP BY ODSDAT

Open in new window

That shows the various Save Dates for all of those files. You should see at least two dates listed. The latest date will be when all files but one were saved. The other date will be from the record for the file that wasn't saved on that date. (If it was never saved, it will be a blank value.)

And when you know what the Save Date value is, you can simply plug it into a SQL SELECT... WHERE... statement to see the full record.

Tom
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month9 days, 15 hours left to enroll

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question