Solved

Find out which object is not saved

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DB2 V9.7 restore 5 50
adodb sql multi tables 1 1,227
Configure e-mail alerts VMWare Esxi 5.5 on IBM x3650 Server 6 151
Excel 2016 Import Data Using Microsoft Query 6 137
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

680 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