PM68462: ABEND0C4 IN TSO ROUTINE IKJEFT04 + 118 AFTER ABEND04E RC00E40090 FROM DB2 CHECK DATA UTILITY SYNTAX ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS report secondary abend
  following failure of DB2 CHECK DATA utility. Syntax error in DB2
  CHECK DATA utility causes original abend04e rc00e40090 which
  percolates into TSO ESTAI routine, IKJEFT04 ,  only when CHECK
  DATA utility was run from Admin Tool ADBTEP2 / ADB2UTIL program
  to execute the DB2 utility.
  .
  This apar will address Admin Tool abend handling, which resulted
  in secondary abend0c4 in TSO's IKJEFT04 routine.
  .
  DB2 apar PM68239 may alter original abend symptoms from
  DB2 CHECK DATA utility.
  .
  Additional symptoms: 00e40090 rsn00e40090 0c4 rc04 msgadbt015i
    msgadb5184e
   ADBT015I  Failure attempting to execute   ADB2UTIL  with parm
   ADB5184E The run is ending due to an error with a non-SQL
      command.
  

Local fix

• Use correct syntax for CHECK DATA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use an invalid CHECK utility        *
  *                 statement 'FOR EXCEPTION + USE table         *
  *                 name2' which was executed in the ADBTEP2     *
  *                 program.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users of DB2 Administration Tool for    *
  *                      z/OS report a secondary abend           *
  *                      following the failure of the DB2        *
  *                      CHECK DATA utility. A syntax error      *
  *                      in DB2 CHECK DATA statement causes      *
  *                      the original ABEND04E RC00E40090        *
  *                      which percolates into the TSO ESTAI     *
  *                      routine, IKJEFT04, only in the case     *
  *                      when the CHECK DATA utility was run     *
  *                      from the DB2 Admin Tool ADBTEP2 /       *
  *                      ADB2UTIL program to execute the         *
  *                      DB2 utility.                            *
  *                                                              *
  *                      This APAR will build the correct        *
  *                      CHECK DATA syntax which will not        *
  *                      result in the secondary ABEND0C4        *
  *                      in the TSO's IKJEFT04 routine.          *
  *                                                              *
  *                      The syntax error example:               *
  *                      CHECK DATA TABLESPACE                   *
  *                      XXXX.XXXX                               *
  *                        FOR EXCEPTION USE                     *
  *                        XXXX.XXXX                             *
  *                        DELETE YES                            *
  *                        ERRDDN(UTLERR)                        *
  *                        WORKDDN(UTLUT1,SORTOUT)               *
  *                                                              *
  *                      The symptoms:                           *
  *                      SYSTEM COMPLETION                       *
  *                      CODE=0C4  REASON                        *
  *                      CODE=00000004                           *
  *                                                              *
  *                      Additional symptoms:                    *
  *                      DSNUGUTC - OUTPUT START                 *
  *                      FOR UTILITY, UTILID = ssid              *
  *                      DSNUGTIS - PROCESSING SYSIN             *
  *                      AS EBCDIC                               *
  *                      DSNUGBAC - UTILITY BATCH MEMORY         *
  *                      EXECUTION ABENDED,                      *
  *                      REASON=X'00E40090'                      *
  *                                                              *
  *                      ADBT015I  Failure attempting to         *
  *                      execute ADB2UTIL  with parm             *
  *                      ssid,DB2BATCH,,                         *
  *                                         802816               *
  *                      Check for possible CSV019I message      *
  *                      ADB5184E The run is ending due to       *
  *                      an error with a non-SQL command.        *
  *                      Additional messages may have been       *
  *                      sent to the DD SYSTSPRT                 *
  *                           Additional diagnostics             *
  *                           NNNIYNN                            *
  *                           commit_all_req=N                   *
  *                           asw_req       =N                   *
  *                           asw_app       =N                   *
  *                           asw_stmt_app  =I                   *
  *                           chk_rec_found =Y                   *
  *                           SQLCODE -626? =N                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 CHECK DATA utility syntax error causes a DB2 ABEND04E,
  which causes the ADB2UTIL program to fail with an ABEND0C4.
  

Problem conclusion

• Program has been changed to build the correct CHECK DATA syntax
  if the user specifies 'YES' for 'Use customized util opts'
  on panel GOC5 'Generate Compare Jobs', and specifies 'Schema'
  and 'Name' on panel ADB2ISK 'Specify Utility Options - CHECK
  DATA' to build the  'FOR EXCEPTION IN' statement.
  

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:

  UK83582 UK83583

Modules/Macros

•    ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK83582

     UP12/11/21 P F211

• RA20 PSY UK83583

     UP12/11/21 P F211

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.