Configuring automatic ANALYZE after HCAT_SYNC_OBJECTS

You can change the behavior of the ANALYZE command after an HCAT_SYNC_OBJECTS call by setting the biginsights.stats.auto.analyze.post.syncobj property to DEFERRED, NEVER, or COPYHIVE, either as a session variable or as a system-wide property. The default value of biginsights.stats.auto.analyze.post.syncobj is DEFERRED.

Before you begin

These three values have the following definitions:
DEFERRED
Specifies that Hive statistics are to be copied after an HCAT_SYNC_OBJECTS procedure completes, and that ANALYZE is to be queued to run later if an ANALYZE command has never been run against the specified table. This is the default.
NEVER
Specifies that ANALYZE is never to be run after an HCAT_SYNC_OBJECTS procedure completes.
COPYHIVE
Specifies that Hive statistics are to be copied after an HCAT_SYNC_OBJECTS procedure completes.

Procedure

To set the biginsights.stats.auto.analyze.post.syncobj 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.auto.analyze.post.syncobj=NEVER;

To set the biginsights.stats.auto.analyze.post.syncobj property as a system-wide property, complete the following steps:

  1. Open the bigsql-conf.xml configuration file at $BIGSQL_HOME/conf/bigsql-conf.xml on the head node only.
  2. Add the following property: 
    
<property>
 <name>biginsights.stats.auto.analyze.post.syncobj</name>
 <value>NEVER</value> 
</property>
  3. Restart the Db2 Big SQL service.