PH68131: ABEND S017 30C FOR SQL MODE UNLOADS WITH OUTEXIT CLAUSE SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload performed in SQL mode terminates abruptly with
  an ABEND S017 with reason code 30 when zIIP processing is
  enabled (the message INZU315I is displayed in the SYSPRINT) and
  the OUTEXIT clause is specified.
  
  
  Note: The OUTEXIT statement is incompatible with SQL mode (DB2
  FORCE or DB2 YES in unloads incompatible with native mode) and
  is ignored, even when zIIP processing is not enabled (the
  message INZU489W will be displayed).
  

Local fix

• 1) If the unload is incompatible with native mode, remove the
  OUTEXIT clause.
  
  2) Perform the unload in native mode (DB2 NO) in order to make
  use of the OUTEXIT clause
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload performed in SQL mode  *
  *                      terminates abruptly with an ABEND S017  *
  *                      with reason code 30 when zIIP           *
  *                      processing is enabled (the message      *
  *                      INZU315I is displayed in the SYSPRINT)  *
  *                      and the OUTEXIT clause is specified.    *
  *                                                              *
  *                      Note: The OUTEXIT statement is          *
  *                      incompatible with SQL mode (DB2 FORCE   *
  *                      or DB2 YES in unloads incompatible with *
  *                      native mode) and is ignored, even when  *
  *                      zIIP processing is not enabled (the     *
  *                      message INZU489W will be displayed).    *
  *                                                              *
  *                      Local Fix:                              *
  *                      1) If the unload is incompatible with   *
  *                      native mode, remove the OUTEXIT clause. *
  *                      2) Perform the unload in native mode    *
  *                      (DB2 NO) in order to make use of the    *
  *                      OUTEXIT clause                          *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  ABEND S017 30C for SQL mode unloads with OUTEXIT clause
  specified
  

Problem conclusion

• Code has been changed to fix this problem
  

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

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO05248

     UP25/10/18 P F510

• R610 PSY UO05249

     UP25/10/18 P F510

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.