PH59896: DB2 CLP ALWAYS RETURN RC00 WHEN RUNNING IN BATCH MODE ( BPXBATCH ) EVEN IF THE DB2 COMMAND OR SQL FAILS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 CLP always return RC00 when running in batch mode ( BPXBATCH
  
  ) even if the Db2 command or SQL fails
  
  Additional keywords and symptoms:
  **********************************
  IDAAV7R5/K
  
  case: TS015363256
  
  KnowIssue: DT261782
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 and 13 for z/OS users who run                     *
  * Db2 command line processor (CLP) in                          *
  * batch mode.                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Running Db2 CLP in batch mode returns                        *
  * a return code of 0 even if statements                        *
  * in the input file fail.                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Db2 CLP can run in batch mode by providing an input file with
  the -f option. Batch mode will process all of the statements in
  the input file in a single transaction.
  In batch mode, Db2 CLP will always return a return code of 0
  even if any statements in the input file fail. The return code
  can be checked by running "echo $?" after running the
  Db2 CLP batch mode command.
  

Problem conclusion

• Db2 CLP has been updated to return a return code of 255 if a
  statement in the input file fails while running in batch mode.
  Db2 CLP batch mode may be used in automated scripts or as a
  job step in batch jobs like BPXBATCH in JCL. Today, if a
  statement fails in Db2 CLP batch mode, the script or batch job
  will continue to the next command or step. With the fix, if a
  statement fails in Db2 CLP batch mode, the script or batch job
  may stop after receiving a non-zero return code from Db2 CLP.
  

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:

  UI96667 UI96668

Modules/Macros

• DSNCLP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI96667

     UP24/04/27 P F404

• RD10 PSY UI96668

     UP24/04/27 P F404

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.