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.
- To access the Schema Generate Profile page
from WebSphere® Application
Server administrative
console, go to .
- 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:
- Ensure that the specified output directory is accessible to the user who
will deploy the generated scripts.
- The generated artifact files are created with general access. It is recommended
that, immediately after generation, the user should make copies of the files
and remove the generated artifacts that are accessible to anyone. This activity
should be done before the database artifacts are deployed.