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.
- 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.
- 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:
- The business measures model is imported
through the Schema Generator panel in the WebSphere Business Monitor administrative
console.
- The Schema Generator generates databases artifacts.
- The DBA executes the generated Database DDL files on the appropriate databases.
- The DBA executes the replication setup scripts.
- The DBA imports the generated Cube Views™ XML file into the DB2® OLAP Center.
- 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.