Enabling or disabling cumulative statistics collection

The default behavior of the ANALYZE command is to keep previously collected statistics. You can change this behavior by setting the biginsights.stats.cumulative property to true or false, either as a session variable or as a system-wide property.

To set the biginsights.stats.cumulative property as a session variable, complete the following step:

1. Run the following command within the Db2® Big SQL shell or interface:

   SET HADOOP PROPERTY biginsights.stats.cumulative=true;

To set the biginsights.stats.cumulative property as a system-wide property, complete the following steps:

2. Open the bigsql-conf.xml configuration file at $BIGSQL_HOME/conf/bigsql-conf.xml on the head node only.
3. Add the following property:

   
   <property>
    <name>biginsights.stats.cumulative</name>
    <value>true</value> 
   </property>

4. Restart the Db2 Big SQL service.