PI19276: MSGINZZ001S (0001): ABEND S04E U0000 REASON=00E7000C R2=18 WHEN REFORMATTING THE CLOB, BLOB, AND XML DATA TO VARCHAR(100)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload (SELECT ... OUTDDN) fails with ABENDS04E or
  ABENDS0C4 or other unidentified symptom if the following
  conditions are fullfilled:
  - the fix for PB12120 / PI08596 has been applied
  - the SELECT statement involves a big number of columns
  - the SELECT statement involves a LOB or XML column
  
  PB12357
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload (SELECT ... OUTDDN)    *
  *                      fails with ABENDS04E or ABENDS0C4 or    *
  *                      other unidentified symptom if the       *
  *                      following conditions are fullfilled:    *
  *                      - the fix for PB12120 / PI08596 has     *
  *                       been applied                           *
  *                      - the SELECT statement involves a big   *
  *                       number of columns                      *
  *                      - the SELECT statement involves a LOB   *
  *                       or XML column                          *
  *                      PB 12357                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzctrlh, inzquery and inzqryc8 modules were changed.
  

Problem conclusion

• APPLY the PTF.
  

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

• R420 PSY UI19067

     UP14/06/26 P F406

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.