Deploying Cube Views database schema on the AIX® platform

The Cube Views™ metadata is stored in the Schema Generator output folder. This output folder is defined by the user through the WebSphere® Business Monitor administrative console.

To deploy the Cube Views™ metadata file, complete the following steps:
  1. Open the DB2® Command Window editor.
  2. Connect to the Historical database with the database instance user (example: db2inst1) by running the command: db2 connect to HISTORICAL_database_name.
  3. Change directory to <DB2_INST_HOME>/sqllib/misc directory, and then run the command: db2 -tvf db2mdapi.sql.
  4. Run the command: db2mdapiclient -d HISTORY -i <GENERATION_DIR>/schemagen/import_model.xml -m <GENERATION_DIR>/schemagen/model_cv.xml> -u <userid> -p <pw> -o <GENERATION_DIR>/schemagen/myoutput.xml.
    Where
    • -d is the Historical database name.
    • -i is the Schema Generator produced import_model.xml file.
    • -u is the user ID.
    • -p is the password.
    • -o is the output operation file name where DB2 output information is stored.
    • -m is the input metadata command or instruction to DB2. The Schema-Generator produces model_cv.xml file which is be used as the multidimensional metadata.
    • <GENERATION_DIR> refers to the output directory where the Schema Generator stores the artifacts that it generates.
Example:

su - db2inst1
db2 connect to HISTORY
cd /home/db2inst1/sqllib/misc
db2 -tvf
db2mdapi.sql
db2mdapiclient -d HISTORY
-i /opt/IBM/WebSphere/Monitor/generation/schemagen/import_model.xml
-m /opt/IBM/WebSphere/Monitor/generation/schemagen/model_cv.xml
-u db2inst1 -p monPa55w -o /tmp/import_output.xml

Related concepts
Cube views definitions
Related tasks
Deploying Cube Views database schema on the Windows platform
Creating ABX cubes manually

Copyright IBM Corporation 2005. All Rights Reserved.