PM81808: MSGINZU215E LOAD STATEMENT ERROR : INVALID CONVERSION FOR COLUMN BIGINT_COLUMN_NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload fails with completion code 8 after issuing
  msgINZU215E LOAD STATEMENT ERROR : INVALID CONVERSION FOR COLUMN
  bigint_column_name.
  
  This occurs whenever the following conditions are true:
  - a logical unload requires BIGINT data be unloaded
  - the DELIMITED format is requested
  - the load statement generation is requested (LOADDDN option)
  
  PB11818 INZU215E INZU215
  

Local fix

• remove the LOADDDN request from your unload command to get the
  data and use your own LOAD command.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The unload fails with completion code   *
  *                      8 after issuing msgINZU215E LOAD        *
  *                      STATEMENT ERROR : INVALID CONVERSION    *
  *                      FOR COLUMN bigint_column_name.          *
  *                      This occurs whenever the following      *
  *                      conditions are true:                    *
  *                      - a logical unload requires BIGINT      *
  *                       data be unloaded                       *
  *                      - the DELIMITED format is requested     *
  *                      - the load statement generation is      *
  *                       requested (LOADDDN option)             *
  *                      pb 11818                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzload 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

•    INZCHECK INZSIVP
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK94106

     UP13/05/14 P F305

• R420 PSY UK94107

     UP13/05/14 P F305

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.