Batch Processor : Delete old Batch Processor restart rows

Products

• Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

There are old 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.

How to delete rows from the PTI.BPLOG_0203 table to remove old entries?

Environment

Release: R20

Db2 for z/OS

Resolution

Go to the Execution Display Panel (option 3) from the RC/Migrator Main Menu.  On that screen use the filtering fields to identify the BPID of the job that are to be deleted.

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 this statement:

.RESTART OVERRIDE

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

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