JR33440: PROBLEM OCCURRED DURING JOB RUN, WHEN TRYING TO READ INT64 COLUMNS FROM NETEZZA TABLES

APAR status

• Closed as program error.

Error description

• Problem occurred during job run, when trying to read int64
  columns from netezza tables
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IS 8.0.1.1 RH Linux Netezza EE Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  PROBLEM OCCURRED DURING JOB RUN, WHEN TRYING TO READ INT64
  COLUMNS FROM NETEZZA TABLES
  ****************************************************************
  RECOMMENDATION:
  Please apply the provided patch.
  The fix has been included in the IS 8.1 FP1. Apply the fixpack 1
  for the IS 8.1
  ****************************************************************
  

Problem conclusion

• There was a issue in import schema generation when last column
  is non-nullable and is of either
  (u)int8/(u)int16/(u)int64/sfloat/dfloat datatypes.
  

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

• NETEZZA
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSY

     UP