PI39817: DB2 ADMIN FAILS RESTART RUN OF CHANGE W/SQLCODEN104 AFTER EDITING CHECKPOINT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS fails restart RUN of CHANGE
  with SQLCODEN104 ( SQLCODE -104) after editing checkpoint and
  issues ADB5146E Unexpected SQLCODE in :setCurrentExplainMode()
  msgADB5146E
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who edit a checkpoint to restart    *
  *                 an APPLY job from a different starting       *
  *                 point using the Batch Restart Program        *
  *                 ADBTEP2.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When restarting an APPLY job from a     *
  *                      different starting point via editing    *
  *                      a checkpoint using panel ADB2Z2BU       *
  *                      'UPDATE an Entry' and setting option    *
  *                      'Explain mode' to 'YES', then           *
  *                      executing the APPLY job, error          *
  *                      messages ADB5146E / msgadb5146e and     *
  *                      SQLCODE=-104 / SQLCODEN104 are          *
  *                      observed:                               *
  *                                                              *
  *                      ADB5146E Unexpected SQLCODE             *
  *                      in :setCurrentExplainMode()             *
  *                                                              *
  *                      DSNT408I SQLCODE = -104,                *
  *                      ERROR:  ILLEGAL SYMBOL                  *
  *                      "<END-OF-STATEMENT>".                   *
  *                      SOME SYMBOLS THAT MIGHT                 *
  *                      BE LEGAL ARE: EXPLAIN :                 *
  *                      <IDENTIFIER> ? YES                      *
  *                      NO                                      *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When restarting an APPLY job from a different starting point
  via editing a checkpoint using panel ADB2Z2BU, the Batch
  Restart Program ADBTEP2 applies an invalid special register
  value to the CURRENT EXPLAIN MODE rather than the value
  specified by the user.  As a result, the execution of the SET
  CURRENT EXPLAIN MODE statement fails with a SQLCODE=-104 /
  SQLCODEN104.
  

Problem conclusion

• The problem has been resolved.
  

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

• RB10 PSY UI27619

     UP15/05/16 P F505

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.