PH21932: WITH CUSTOM. PARM ENABLE_COPY_TABLE_STATISTICS SET TO TRUE USERSMAY SEE WARNING MESSAGES IN IBM DB2 ANALYTICS ACELERATOR STUDIO

APAR status

• Closed as documentation error.

Error description

• With customization parameter ENABLE_COPY_TABLE_STATISTICS set to
  TRUE users may see warning messages in IBM Db2 Analytics
  Acccelerator studio such as "Statistics not yet collected after
  loading...".
  These error message pointing to missing statistics are displayed
  erroneously. You may ignore them.
  .
  The issue will be fixed in IDAA 7.5.1
  
  Additonal keywords:
  RTC#24452
  
  For IBM support:
  You can verify the existence of statistics for the subject table
  using the following statement replacing <tablename> with the
  actual table name:
  select substr(a.tabname,1,40), a.statstype,
  a.STATS_ROWS_MODIFIED, a.RTS_ROWS_MODIFIED, a.COL_OBJECT_P_SIZE,
  b.TABLEORG, b.stats_time , b.CREATE_TIME from
  sysibmadm.admintabinfo a , syscat.tables b where
  a.tabname=b.tabname where tabname like '<tablename>%'
  
  Verify that 'stats_time' contains a value; the value of
  statstype may be 'U' or 'A'.
  

Local fix

Problem summary

• The issue descibed was fixed in the IDAA V7 accelerator server.
  The fix became part of IDAA V7 maintenance level 7.5.1 made
  available on April 22,2020.
  

Problem conclusion

• Upgrade your IDAA V7 maintenance level to 7.5.1 or higher.
  

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:

Fix information

Applicable component levels