PI79154: ANALYZE FAILURES WITH "HIGH2KEY IS OUT OF RANGE ERRORS"

APAR status

• Closed as program error.

Error description

• Analyze uses the Big SQL java IO reader to scan the table
  and gather statistics on the table.  When computing column
  statistics, Analyze computes HIGH2KEY and LOW2KEY values which
  represent the largest and smallest values of that column. If
  the column is of DATE type and contains negative values, the
  Java Reader attempts to convert that value to a positive DATE.
  This leads Analyze to believe that the LOW2KEY value is higher
  than the HIGH2KEY.  This raises a flag to Analyze which fails
  with the following warning:
  
  2017-03-16 17:20:36,754 WARN
  com.ibm.biginsights.catalog.translator.hive.HiveExceptionTransla
  tor [Thread-5] : [BSL-0-2d8fe6b92]: The catalog statistic
  "2012-03-27" for column "HIGH2KEY" is out of range for its
  target column, has an invalid format, or is inconsistent in
  relation to some other statistic. Reason Code = "3"..
  SQLCODE=-1227, SQLSTATE=23521, DRIVER=4.21.34
  com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException:
  The catalog statistic "2012-03-27" for column "HIGH2KEY" is out
  of range for its target column, has an invalid format, or is
  inconsistent in relation to some other statistic. Reason Code =
  "3".. SQLCODE=-1227, SQLSTATE=23521, DRIVER=4.21.34
  
  
  The fix for this issue is to allow the following (01-01-0001)
  as the earliest valid date for the Java Reader.  Dates before
  this time will be converted to a NULL value by Analyze.  This
  will allow Analyze to proceed without the "HIGH2KEY is out of
  range errors".
  

Local fix

• N/A
  

Problem summary

• See error description.
  

Problem conclusion

• The problem is fixed in Version 4.3 and later fix packs.
  

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

• n/a
  

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R430 PSY

     UP