PM96542: INZU215E LOAD STATEMENT ERROR, BIGINT AND EXTERNAL FORMAT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When attempting to unload BIGINT data in EXTERNAL format and
  requesting a LOAD statement be generated (LOADDDN option), the
  process stops after having issued msgINZU215E (LOAD STATEMENT
  ERROR : INVALID CONVERSION FOR COLUMN bigint_column) while
  generating a valid LOAD statement is actually possible.
  
  msgINZU215E INZU215E msgINZU215 INZU215
  PB12023
  

Local fix

• Consider removing the LOADDDN option to get the output data and
  use your own LOAD statement (specify INTEGER EXTERNAL (20) for
  BIGINT fields).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When attempting to unload BIGINT data   *
  *                      in EXTERNAL format and requesting a     *
  *                      LOAD statement be generated (LOADDDN    *
  *                      option), the process stops after        *
  *                      having issued msgINZU215E (LOAD         *
  *                      STATEMENT ERROR : INVALID CONVERSION    *
  *                      FOR COLUMN bigint_column) while         *
  *                      generating a valid LOAD statement is    *
  *                      actually possible.                      *
  *                      PB 12023                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzrload module was fixed.
  

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

• INZPLIB0
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK98177

     UP13/10/16 P F310

• R420 PSY UK98178

     UP13/10/16 P F310

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.