Defining Database Settings
You can define database settings to enable and disable the automatic execution of data definition language (DDL) statements on the database. Automatic execution of DDL statements is enabled by default.
When the automatic execution of DDL statements is disabled, the Analytic Engine runs in Static DB Schema mode. This means that you cannot create, edit or delete dimensions, event maps, KPI hierarchies or KPI definitions and all respective buttons in the My webMethods user interface will be dimmed.
Disabling the automatic DDL execution also affects the deployment process for Optimize assets. For more information about deploying Optimize deployment sets when Analytic Engine runs in Static DB Schema mode, see the PDF publication webMethods Deployer User’s Guide.
To define database settings
1. In My webMethods: Navigate > Applications > Administration > System-Wide > Environments > Define Environments.
2. On the Define Environments page, click the name of the environment you want to work with.
3. On the Edit Environment page, click the Configure Servers tab.
4. Under the appropriate Analytic Engine logical server node in the configuration tree, click Database Settings.
5. In the Database Settings for Analytic Engine area, click Disable DDL Statements to disable the automatic execution of DDL statements.
6. Click Save to save changes or click Cancel to discard any changes you have made in this settings area.
Note:
If you click Finish without first clicking Save, any changes made to these settings will be lost.
7. To configure another logical server subcomponent, click the name of that subcomponent in the configuration tree.
8. Click Finish to close this page and return to the Define Environments page.