Solved

Find out which object is not saved

Posted on 2014-10-27
2
214 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Suggested Solutions

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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

751 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