How to delete CA Batch Processor restart rows

Document ID : KB000126340
Last Modified Date : 14/02/2019
Show Technical Document Details
Introduction:
There are old CA Batch Processor IDs in the system.  When attempting to run a new process,
the process tries to pick up where the old process left off.

Additionally the following message my be encountered:
BPA0022E: BPID IS FLAGGED INCOMPLETE - RESTART IS REQUIRED.
Question:
How to delete rows from the PTI.BPLOG_0203 table to remove old entries?
Environment:
Db2 for z/OS
Answer:
Go to the Execution Display Panel (option 3) from the CA RC/Migrator Main Menu.  Within that screen
use the filtering fields to identify the BPID of the job that you want to delete. Having identified the job
place a "D' next to the entry and press enter.  The restart job entry is then deleted from the table and display.

See : Monitor Strategy Analysis and Batch Processor Execution

Another way is to modify the BPID in the JCL .CONTROL parm by at least 1 character which will
just add a new row in the the BPLOG restart table. The user can also override the restart row by adding
.RESTART OVERRIDE

Example:
PTEDL1        ------------ Execution Display Panel ----------- yyyy/mm/dd hh:ss
COMMAND ===>                                                  SCROLL ===> CSR

BPID      ==> *
DB2 SSID  ==> ssid Strat Creator ==> authid Timestamp ==> *
Status    ==> *    Strat Name    ==> *        Type      ==> *
---------------------------------------------------------------------- AUTHID
                                    --- Strategy ----
    BPID                                                Creator  Name        St  T      Syncpoint-#  Time

__  AUTHID.USERID.BPCODE-AUTHIDS   AUTHID QUICKM    NC  S          960  2015


The restart id above is AUTHID.USERID.BPCODE-AUTHIDS

In the batch job change the AUTHIDS to AUTHID1 and a new row will be created
when the job is executed ignoring the old record.


//BPIOPT   DD   *
.CONTROL BPID(
AUTHID.USERID.BPCODE-AUTHID1) +
 LOGID(DB0G) UNIT(SYSDA)
.LIST SYSOUT(X,,A)
.OPTION NOERRORS NOSQLERRORS RETRY(01) NOBINDERRORS    +
   WRAPLINE
.CONNECT SSID



See also knowledgebase article regarding the use of OVERRIDE.
CA Batch Processor - .RESTART OVERRIDE Command with DELETE Option

There is no current way to mass delete the restart rows using a batch job however there is the ability
to use the block line command "DD" instead of "D" to delete blocks of displayed records.
DD - Delete a "Block" or group of consecutively displayed rows from the log.  Enter a DD in the
line command area of the first and last rows that are to be deleted.  The DD commands must be entered in pairs.

See also: Restart Batch Processor Jobs

See also: How to identify the restart point of a failed batch processor execution.