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:
- Open the DB2® Command Window editor.
- Connect to the Historical database with the database instance user
(example: db2inst1) by running the command: db2 connect to HISTORICAL_database_name.
- Change directory to <DB2_INST_HOME>/sqllib/misc directory,
and then run the command: db2 -tvf db2mdapi.sql.
- 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