Database DDL artifacts

You use the Schema Generator to generate the database artifacts, scripts, and associated DDLs, to support a business measures model.

The Schema Generator, using the annotated business measures model, generates DB2® specific DDL files. These files create the actual tables and columns in the various databases. The database administrator (DBA) must manually run the DDL files to create the database tables and their columns in the State, Runtime, and Historical databases.

The generated DDL files are saved into a directory location that is specified in the General Configuration page under the Schema Generator node in the WebSphere® Business Monitor administrative console. One DDL file and one description file, in text format, are created for each database. The description file contains the description of the DDL file contents.

Each DDL file contains the SQL statements necessary to:
A ZIP file is also generated. It contains the following two files: This ZIP file is the one that will be imported in the WebSphere Business Monitor using the Import Model page of the Business Measures Model administrative functions, under the Server node on the administrative console. For more information about importing the Business Measures Model, refer to Importing a business measures model.
Related concepts
Artifacts generation and deployment

Copyright IBM Corporation 2005, 2006. All Rights Reserved.