PM11020: ADB5043E *** RESTART PROCESSING WAS HALTED DUE TO A COMMAND MISMATCH *** SKIP NEXTED WSL WHICH FAILED SQLCODE -204

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS issues a message:
  ADB5043E *** Restart processing was halted due to a command
    mismatch. ***
  when attempting to restart a WSL after using the SKIP NEXT
  feature on panel ADB2Z2B1 'Display Batch Job Checkpoint Table
  Row'.
  The original WSL had failed with a SQLCODEN204 / SQLCODE -204
  error.
  

Local fix

• Use the WSL RESTART(FORCE) option:
  As with RESTART(YES), RESTART(FORCE) restarts at the last commit
  point prior to a failure. You must also provide the WORKLIST()
  parameter. However, the basic check done in RESTART(YES) is not
  done in RESTART(FORCE). Because the basic check is not done, the
  restart point might be unintended and the results might be
  unpredictable.
  If the COMMAND_RESTART column in the ADBCHKPT table has a value
  of 'S' upon the restart processing, the check for the checkpoint
  record is not performed. And, if the checkpoint dialog Skip-Next
  line command is used, the check is not performed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool             *
  *                 for z/OS who use ADBTEP2 to run              *
  *                 work statement lists and who use             *
  *                 the "skip-next" line command in              *
  *                 the checkpoint table dialog.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a restart is to take place and       *
  *                      the skip-next line command is           *
  *                      used, the ADBTEP2 run may               *
  *                      unexpectedly issue message              *
  *                      ADB5043E indicating a                   *
  *                      command mismatch has                    *
  *                      occurred.                               *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When a prior run has failed and the skip-next line
  command is used to influence the restart point,
  message ADB5043E was being issued incorrectly.
  When skip-next is used, the limited validation for
  command matching should also be skipped.
  

Problem conclusion

• The problem has been fixed.  ADBTEP2 will not
  perform command match validation during restart
  processing if the checkpoint record has been
  modified by the checkpoint record dialog, either
  with the skip-next line command or the update
  line command.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK57306

     UP10/06/03 P F006

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.