CA Batch Processor for DB2 for Z/OS : Delete old CA Batch Processor restart rows

book

Article ID: 126340

calendar_today

Updated On:

Products

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

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

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

Environment

Release: R19, R20

Db2 for z/OS

Resolution

Go to the Execution Display Panel (option 3) from the CA RC/Migrator Main Menu.  On 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 this statement:


.RESTART OVERRIDE

Example:
BPID      ==>
DB2 SSID  ==> DT32 Strat Creator ==> BASLU02  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.
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.