How to resolve Batch Processor error BPA0008E SYNCPOINT nn was not found message
Article ID: 270179
Updated On:
Products
Issue/Introduction
When executing the Database Management for Db2 for z/OS Post Install Create job (ssid0001),
encountering the the following error:
BPA0008E: SYNCPOINT nn WAS NOT FOUND
What needs to be done to resolve this error so the job can continue.
Cause
There is a restart record on the restart table for this BPID which is not complete and the job is trying to do a RESTART SYNC and the current batch processor
script being executed does not have a SYNC nn of that number so there is a mismatch. It could be an old restart record that is a remaining hangover
of a previous batch processor job using the same BPID.
Resolution
What this means that there is an existing RESTART record in our restart table pointing to SYNC point nn that has not been completed and resolved.
If you know for a fact that this is not true, it may be a hangover from a previous install some time ago.
To start from the very beginning you can do a RESTART OVERRIDE
In the ssid0001 job......
//BPIOPT DD *
.CONTROL BPID(hlq.CDBASAMP-ssidDDL) +
LOGID(ssid) UNIT(SYSDA) THREADS(1)
.LIST SYSOUT(*)
.OPTION ERRORS NOSQLERRORS RETRY(24) NOBINDERRORS
.RESTART OVERRIDE <=========add in this line here
.CONNECT ssid
/*
Then submit the job.......again as long as you know that this has not been submitted recently and there wasn't a recent job that stopped at SYNC nn and was validly still not completed.
What this will do is start from the very beginning of the install as if for the first time and ignore the restart record with sync point nn. After that the BPID will be marked as completed.
Additional Information
Feedback
