Usage scenario

The Schema Generator usage scenario describes how the Schema Generator is used to deploy a business measures model.

Before using the Schema Generator component to generate artifacts, you must perform some tasks. The following tasks describe the usual scenario for the creation and installation of WebSphere® Business Monitor databases.
  1. The business measures model is created, edited, modified, and annotated in the Business Measures editor. The business measures model file is in XML metadata interchange (XMI) format. It is exported from the Business Measures editor in .zip file format.
  2. The following databases should be created:
    • The Repository database is created either during the installation of WebSphere Business Monitor or manually by the database administrator (DBA). Because the Repository database is static, the DBA creates all table spaces, tables, and indexes at this time. The required scripts for creating the Repository database are saved in monitor_installation_dir\install\mondb.
    • The State, Runtime, and Historical databases are created either during the installation of WebSphere Business Monitor or manually by the DBA. Only the databases and some static tables are created at installation. The required scripts for creating the State, Runtime, and Historical databases are saved in monitor_installation_dir\install\mondb.
The following steps describe the usual scenario for the deployment of databases artifacts:
  1. The business measures model is imported through the Schema Generator panel in the WebSphere Business Monitor administrative console.
  2. The Schema Generator generates databases artifacts.
  3. The DBA executes the generated Database DDL files on the appropriate databases.
  4. The DBA executes the replication setup scripts.
  5. The DBA imports the generated Cube Views™ XML file into the DB2® OLAP Center.
  6. The business measures model can be deployed through the WebSphere Business Monitor administrative console. Deployment is done by importing the generated .zip file, which contains the business measures model XMI file and the Cube Views™ metadata XMI file, into the Import Model page.

The artifacts generated by the Schema Generator are based on the business measures model. When you change the business measures model in the Business Measures editor, you must regenerate and redeploy this model again.

For more information on managing those changes, refer to Change management artifacts generation in database services section.


Copyright IBM Corporation 2005, 2006. All Rights Reserved.