PK60598: NEW FUNCTION CHANGES TO THE MAXE COMMAND - SUPPORT FOR STOPPING ON FAILING DB2 COMMAND BUT NOT FAILING BIND COMMAND

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The DB2 Administration Tool MAXERROR/MAXE parameter will be
  amended to provide options to allow the ADBTEP2 Batch Restart
  program to stop on a failing DB2 command but not on a failing
  BIND command.
  

Local fix

• Not needed / New Function
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool V7.2.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Panel ADB2UPA has a new field - the     *
  *                      BindError field.  This field allows     *
  *                      the customer to specify how BIND or     *
  *                      REBIND errors are to be handled by      *
  *                      ADBTEP2.  The allowed values for this   *
  *                      field are MAXE, SAVE and IGNORE.        *
  *                      The value provided for this field is    *
  *                      passed to the ADBTEP2 program using     *
  *                      the new BINDERROR() parameter. When     *
  *                      MAXE is specified as the BINDERROR      *
  *                      value, the failing BIND or REBIND       *
  *                      command will be written to the ADBHOLD  *
  *                      table. ADBTEP2 will use the MAXE        *
  *                      setting to determine if processing      *
  *                      continues or halts:                     *
  *                      If MAXE(0) is specified or if MAXE()    *
  *                      is omitted, a BIND or REBIND error      *
  *                      will cause the WSL processing to stop.  *
  *                      If MAXE(-1) is specified, processing    *
  *                      will continue.                          *
  *                      If a value >0 is provided for MAXE,     *
  *                      the BIND or REBIND error will           *
  *                      increment the MAXE counter and          *
  *                      processing will stop if the number of   *
  *                      errors has reached the value. When      *
  *                      SAVE is specified as the BINDERROR      *
  *                      value, the failing BIND or REBIND       *
  *                      command will be written to the ADBHOLD  *
  *                      table.  ADBTEP2 will continue           *
  *                      processing. When IGNORE is specified    *
  *                      as the BINDERROR value, the failing     *
  *                      BIND or REBIND commands are ignored     *
  *                      and not written to the ADBHOLD table.   *
  *                      ADBTEP2 will continue processing.       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  With this enhancement to DB2 Administration Tool V7.2, a method
  of allowing the ADBTEP2 Batch Restart program to stop on a
  failing DB2 command but not on a failing BIND command is
  introduced.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

Modules/Macros

•    ADBHUPA  ADBTEP2  ADB2TEP  ADB2UPA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK38008

     UP08/07/17 P F807

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.