Disable automatic schema management

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

About this task

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

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>

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

After you create a tracking group and update the tracking definitions for your process application, run the following commands 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