|
There are only 2 objects in the library - source files QDDSSRC and
QRPGLESRC. I was able to look at the journal and there are no open
commits for either of those files (actually no changes at all committed or open).
I don't understand why the checkpoint process has a problem with the
library if neither object has open commits. That issue causes me to
question if I add the *NOCMTBDY would I be able to restore and use the
two files without jumping through the ADD/RMVJRNCHG hoops. Will the
system think there are still "open commits" for the file(s) even
though there were none to begin with?
As for killing the job, it is currently stuck on a level check. I do
not know what it does (not an application that I support) and I don't
know what killing it would do to the data. I have already reached out
to the support team but I have not gotten anywhere yet. I have
informed them that the job will be killed by EOD if they have not resolved it by then.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Jim Oberholtzer
Sent: Monday, August 7, 2023 3:07 PM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SAVOBJ checkpoint failure
The system would only look to see if there is a commit that is still
open. If so then yes, you would need the journal change to get after that
object. Can you not end the job, since it’s not doing anything? Then
restart it? That of course means you need to know what started it in
the first place. If this is an ODBC or other SQL connection dollars
to donuts the source job is gone/failed, so this one is just waiting
for instructions. You would have to end it anyway in that case.
Jim Oberholtzer
Agile Technology Architects
On Aug 7, 2023, at 1:47 PM, smith5646midrange@xxxxxxxxx wrote:worries me, specifically that first line of the second paragraph.
Does anyone know the details about the *NOCMTBDY? The help text
trying to get access to the journal info to confirm) and if not, do I
There should be nothing changed in this library by this job (still
still have to do APYJRNCHG or RMVJRNCHG to restore and use the source
files in it even though nothing in the library / files was changed?
not changed anything in the problem library, apparently just having
*NOCMTBDY
The system will save objects without requiring transactions with
pending record changes to reach a commit boundary. Therefore,
objects may be saved with partial transactions.
If you restore an object that was saved with partial transactions,
you cannot use the object until you apply or remove journal changes
(APYJRNCHG or RMVJRNCHG command) to reach commit boundaries. You
will need all journal receivers that contain information about the
partial transactions to apply or remove the changes. Until you
apply or remove the changes, any future save of that object will
include the partial transactions, even if you do not specify
*NOCMTBDY.
-----Original Message-----
From: smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Monday, August 7, 2023 2:20 PM
To: 'Midrange Systems Technical Discussion'
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SAVOBJ checkpoint failure
I was able to chase this down.
There is a job running using commitment control and even though it
has
the library in the libl is enough to cause the checkpoint to fail.
anything about it but I'll be checking that out.
It looks like there is a parm SAVACTWAIT(xxx *NOCMTBDY). I don't
know
job, for testing, and then opened some of those source members in SEU ...?
Thanks all for your help.
-----Original Message-----
From: smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Monday, August 7, 2023 12:53 PM
To: 'Midrange Systems Technical Discussion'
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SAVOBJ checkpoint failure
Is there a way to find what file(s) / member(s) might have this problem?
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf
Of Mark Waterbury
Sent: Monday, August 7, 2023 11:15 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SAVOBJ checkpoint failure
Someone might have had commitment control active (STRCMTCTL) in
their
I think that when it says it "failed to reach a checkpoint" thatthere is some commitment control going on ...
means
smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx> wrote:
On Monday, August 7, 2023 at 10:21:46 AM EDT,
did a WRKOBJLCK on the library and there are no locks on it. This
We have a process that backs up our dev source and pushes it over to
our prod machine for offsite backup. This has been running for
about
6 months with no problem. We are doing a SAVOBJ to a *SAVF with
SAVACT(*LIB) and now it is failing on one library with the message
Save ended. Unable to reach checkpoint.
I just did the command manually and got the same error. I
immediately
process works on other libraries so it is just one specific library
that is "broken".
Since the library only contains source, there shouldn't be anythingusing it.
meeting first to discuss this and that is not going to happen until
I recommended opening a ticket with IBM but the admins want to have
a
tomorrow which means we lose another night's backup.
https://archive.midrange.com/midrange-l.
Does anyone have any idea what I can look at in advance?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
related questions.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
https://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
related questions.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
--
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.