Enabling data movement services

If data movement service has not been enabled during installation of a monitor model, you can use the WebSphere® Application Server administrative console to enable this service either by running the Enable data movement service scripts for that monitor model automatically or by exporting the scripts and then running them manually.

Data movement service optimizes server processing and reporting in higher volume production environments. Operational tables are optimized for inserts and updates, and the reporting tables are optimized for dashboard queries. When enabled, data movement service runs automatically as a scheduled service. Once enabled, data movement service cannot be disabled. Data movement service is optional in this release. It is not recommended for development and test environments, or small production environments where performance is not a concern. Therefore, it is not supported in the unit-test environment (UTE), also referred to as the Integrated Test Environment (ITE).

The copying and pruning operations of data movement service are handled by SQL stored procedures created in the database when data movement service is enabled. Data movement service can be enabled for a version of a model when it is deployed. It can also be deferred to a later time. It can be enabled by selecting Enable DMS at the WebSphere Application Server administrative console or by exporting the DDLs to be run manually.

Note:

If you are using Oracle as your database, export and manually run the database scripts to enable data movement services. These scripts include commands that create and drop tables and views and are not transactional with Oracle. If the scripts fail to complete successfully, the database administrator must perform any required cleanup because rollback is not supported. DB2 is fully transactional and running the scripts automatically on DB2 is acceptable if your database administrator allows it.
If you are using DB2® on zOS you must export the scripts and run them manually.
The server database user must have administrative privileges to create database objects. For more information, refer to the topic "Securing the data movement service database schema." A related link is provided.

Data movement service automates the copying and pruning operations. Data movement service schedules stored procedures to run at regular intervals. You can control the invocation of the data movement service stored procedures and the data movement service interval. The data movement service also provides a log that contains a record of the details of the stored procedure invocations.

The data movement service historical logs are recorded in the DMS_HISTORY_T table in the Monitor database. Each record in the table contains information about the model name, the model version, the monitoring context, the configured interval, rows copied to the reporting table, rows pruned from the operational tables. It also has a message indicating the status from the execution of the associated stored procedure, the last time the stored procedure was invoked, and the last time the stored procedure completed execution.

Using data movement service involves the following tasks: