Re: what had a lock on files trying to restore

this is savrstlib cmd between systems
on the target system we see the normal joblog entries for files being restored & indexes built starting at 3:59a till 4:04a then
nothing in joblog till 7:29a . That time period corresponds to a remote pgmr logging on at 4:02a(from a land far far away..).
(had a device description in QCTL...).
I know just ending QINTER is not a good protection from locking objects - we have web servers, sql servers, etc that could access the system as well. But customer asking me "what job caused the problem..."?
When day shift arrived, the target system job was in status SVFW and we could see it had locks on 20 or so files.
We ended up killing the job, which caused damaged objects & now scheduling a rclstg tonight. Simple delete of file did not fix the issue.
But the question is: is there a log anywhere of the actual conflicts a restore has? Looking at wrkobjlck hours later is generally useless.
jim

---- rob@xxxxxxxxx wrote:

Are you sure it was a conflicting job on the RESTORE? Was it a
conflicting job on the save instead? Was it even a conflicting job or was
it something like restoring a logical file onto the remote system and the
PF doesn't exist (cross library logical)? What was the error?


Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Jack Kingsley <iseriesflorida@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/14/2010 02:43 PM
Subject: Re: what had a lock on files trying to restore
Sent by: midrange-l-bounces@xxxxxxxxxxxx



If you know the object name and or library you could possibly track it
down
with wrkobjlck




On Tue, Dec 14, 2010 at 1:50 PM, <franz400@xxxxxxxxxxxx> wrote:

We run a savrstlib from production sys to development sys in an

automated

job. Short of putting system in restricted state, how can we determine

what

job(s) caused an object to not restore. We see the joblog that it did

not

restore, but no info of conflicting job. Is this somewhere we can get

to?

Jim Franz

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.