Solved

Find out which object is not saved

Posted on 2014-10-27
2
173 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 34

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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
eclipse find/step into stored procedure 3 178
compare column value for each row 4 75
Iseries Object Security 5 66
creating materialized view in ibm i series 5 63
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 (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

947 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now