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:

Does anyone know the details about the *NOCMTBDY? The help text worries me, specifically that first line of the second paragraph.

There should be nothing changed in this library by this job (still trying to get access to the journal info to confirm) and if not, do I 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?

*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 not changed anything in the problem library, apparently just having the library in the libl is enough to cause the checkpoint to fail.

It looks like there is a parm SAVACTWAIT(xxx *NOCMTBDY). I don't know anything about it but I'll be checking that out.

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 job, for testing, and then opened some of those source members in SEU ...?
I think that when it says it "failed to reach a checkpoint" that means there is some commitment control going on ...

On Monday, August 7, 2023 at 10:21:46 AM EDT, smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx> wrote:

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 did a WRKOBJLCK on the library and there are no locks on it. This 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 anything using it.



I recommended opening a ticket with IBM but the admins want to have a meeting first to discuss this and that is not going to happen until tomorrow which means we lose another night's backup.



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




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