PI82524: RUNNING ANALYZE FAILS WITH AN SQL5105N ERROR

APAR status

• Closed as program error.

Error description

• Running ANALYZE on a table where full statistics for single
  columns (not column groups) had been previously collected on
  version 4.1 and (single, not column group) column statistics
  (not FULL) are being collected on version 4.2 may fail with an
  SQL5105N error; for example:
  
  [bigsql@testsystem ~]$ db2 "ANALYZE TABLE bigsql.TESTTABLE
  COMPUTE STATISTICS FOR COLUMNS
  name,salary,address,job,start_date,gender"
  
  DB21034E The command was processed as an SQL statement because
  it was not a
  valid Command Line Processor command. During SQL processing it
  returned:
  SQL5105N The statement failed because a Big SQL component
  encountered an
  error. Component receiving the error: "DDL FMP". Component
  returning the
  error: "DDL FMP". Log entry identifier: "[BSL-0-434e14607]".
  SQLSTATE=58040
  
  The bigsql.log shows errors similar to the following:
  
  2017-05-23 03:36:37,770 ERROR
  com.ibm.biginsights.biga.udf.SqlReturn [Thread-2725] :
  [BSL-0-434e14607]: Internal error: Unmapped exception in
  SqlReturn
  java.lang.NoSuchMethodError
  at
  sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
  Method)
  at
  sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCons
  tructorAccessorImpl.java:88)
  at
  sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delega
  tingConstructorAccessorImpl.java:57)
  at
  java.lang.reflect.Constructor.newInstance(Constructor.java:436)
  at
  java.util.concurrent.ForkJoinTask.getThrowableException(ForkJoin
  Task.java:609)
  at
  java.util.concurrent.ForkJoinTask.reportException(ForkJoinTask.j
  ava:688)
  at java.util.concurrent.ForkJoinTask.join(ForkJoinTask.java:731)
  at
  java.util.concurrent.ForkJoinPool.invoke(ForkJoinPool.java:2627)
  at
  com.ibm.biginsights.bigsql.stats.ColumnReader.aggColumnStats(Col
  umnReader.java:42)
  at
  com.ibm.biginsights.biga.udf.stats.StatsUpdater.aggColumnStats(S
  tatsUpdater.java:249)
  at
  com.ibm.biginsights.biga.udf.stats.StatsUpdater.etlStatistics(St
  atsUpdater.java:172)
  at
  com.ibm.biginsights.biga.udf.stats.StatsUpdater.doETL(StatsUpdat
  er.java:114)
  at
  com.ibm.biginsights.biga.udf.stats.AnalyzeTool.analyze(AnalyzeTo
  ol.java:142)
  at
  com.ibm.biginsights.biga.udf.stats.AnalyzeTool.analyze(AnalyzeTo
  ol.java:69)
  at
  com.ibm.biginsights.biga.udf.BIGSQL_DDL.performAnalyze(BIGSQL_DD
  L.java:1408)
  at
  com.ibm.biginsights.biga.udf.BIGSQL_DDL.doAnalyzeStatement(BIGSQ
  L_DDL.java:1317)
  at
  com.ibm.biginsights.biga.udf.BIGSQL_DDL.processDDL(BIGSQL_DDL.ja
  va:233)
  Caused by: java.lang.NoSuchMethodError:
  com/google/common/primitives/UnsignedLong.fromLongBits(J)Lcom/go
  ogle/common/primitives/UnsignedLong;
  at
  com.ibm.biginsights.bigsql.stats.PartitionReader.read(PartitionR
  eader.java:116)
  at
  com.ibm.biginsights.bigsql.stats.PartitionReader.getPartitionCol
  umn(PartitionReader.java:85)
  at
  com.ibm.biginsights.bigsql.stats.ColumnReader$ReadColumn.compute
  Directly(ColumnReader.java:98)
  at
  com.ibm.biginsights.bigsql.stats.ColumnReader$ReadColumn.compute
  (ColumnReader.java:84)
  at
  com.ibm.biginsights.bigsql.stats.ColumnReader$ReadColumn.compute
  (ColumnReader.java:68)
  at
  java.util.concurrent.RecursiveTask.exec(RecursiveTask.java:105)
  at
  java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:300)
  at
  java.util.concurrent.ForkJoinTask.doJoin(ForkJoinTask.java:400)
  at java.util.concurrent.ForkJoinTask.join(ForkJoinTask.java:730)
  at
  com.ibm.biginsights.bigsql.stats.ColumnReader$ReadColumn.compute
  (ColumnReader.java:91)
  at
  com.ibm.biginsights.bigsql.stats.ColumnReader$ReadColumn.compute
  (ColumnReader.java:68)
  

Local fix

• Use the FULL keyword on the ANALYZE statement.
  

Problem summary

• See error description
  

Problem conclusion

• The problem is fixed in Version 5.0.1.0 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

• Unknown
  

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R425 PSY

     UP