Generating schema

After you have configured the Schema Generator component, you next invoke the Schema Generator to generate the required artifacts of the business measures model.

To generate the databases artifacts, you perform the following steps.
  1. To access the Schema Generate Profile page from WebSphere® Application Server administrative console, go to WebSphere Business Monitor > Schema Generator > Generate.
  2. To generate the artifacts according to the configuration you entered, click Generate. The generated artifacts are saved in the output directory that is specified in the Schema Generator configuration panel. The contents of the output directory are:
    • Three DDL files for each database (State, Runtime, and Historical)
    • Three text files describing the tables of each database
    • Three zip file containing the replication scripts and procedures required to manage replication among databases (one for State, one for Runtime and one for Historical database). On AIX® system, JAR archives will be created instead of zip files.
On the AIX system, the Schema Generator files that are created are owned by the user ID under which the WebSphere Business Monitor server is running. Because they are created with general read-and-write access, you should take the following precautions when configuring and running the Schema Generator:
Related concepts
Usage scenario
Related tasks
Configuring the Schema Generator

Copyright IBM Corporation 2005, 2006. All Rights Reserved.