PI97515: MISMATCH OF SIZE OF FIELDS IN LOAD FROM DB2 LUW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When attempting to HLV Load from a Postgres table Federated
  through LUW, the Loader claims that the third column SELECTed
  is too long:
  HLOU5806W   Column propnoiciante data is too long.
  This field is defined, in Postgres, as
  character varying(1)
  and in the Target DB2 table as
  VARCHAR(1)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Analytics Accelerator Loader    *
  *                 Server for z/OS                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When attempting to HLV Load from a      *
  *                      Postgres table Federated through LUW,   *
  *                      the Loader claims that the third        *
  *                      column SELECTed is too long:            *
  *                      HLOU5806W   Column propnoiciante data   *
  *                      is too long.                            *
  *                      This field is defined, in Postgres, as  *
  *                      character varying(1)                    *
  *                      and in the Target DB2 table as          *
  *                      VARCHAR(1)                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to fix this problem
  

Problem conclusion

• Apply the PTF for problem resolution
  

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:

  UI56012

Modules/Macros

•    HALE210J HLVO31AD HLVO31AN HLVO31BD HLVO31BN
  HLVO31CD HLVO31CN HLVO319D HLVO319N
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI56012

     UP18/05/29 P F805

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.