IBM BPM, V8.0.1, All platforms > Administer the IT infrastructure > Manage Business Performance Data Warehouses

Disable automatic schema management

Use the <automatic-schema-management> configuration property to control automatic schema management for the Performance Data Warehouse.

The 00Static.xml configuration file includes the following content to enable automatic schema management:

<load-tracking-definition>
<max-attempts>2</max-attempts>
<loader-factory-class-name ="com.lombardisoftware.server.tracking.definitionloader.BasicDefinitionLoaderFactory" />
<validate queued="true"/>
<store queued="false"/>
<automatic-schema-management>true</automatic-schema-management>
</load-tracking-definition>

If you want to disable automatic schema management you must explicitly set the value to false. Simply commenting out the property from the 00Static.xml file does not disable automatic schema management.

Procedure

1. Copy the following content from 00Static.xml to your custom configuration file (typically, 100Custom.xml).

   <load-tracking-definition>
   <max-attempts>2</max-attempts>
   <loader-factory-class-name ="com.lombardisoftware.server.tracking. 
   definitionloader.BasicDefinitionLoaderFactory" />
   <validate queued="true"/>
   <store queued="false"/>
   <automatic-schema-management>true</automatic-schema-management>
   </load-tracking-definition>

2. Change the value of <automatic-schema-management> to false and save the file.
3. Restart the server.

4. After you create a tracking group and update the tracking definitions for your process applications against the default profile.

   /opt/IBM/WebSphere/AppServer/BPM/Lombardi/tools/perfdw-tool/perfDWTool.sh 
   -u  userName -p  password pending -preview pending.sql
   
   /opt/IBM/WebSphere/AppServer/BPM/Lombardi/tools/perfdw-tool/perfDWTool.sh 
   -u  userName -p  password pending -execute

Manage Business Performance Data Warehouses

Related information:
The 99Local.xml and 100Custom.xml configuration files