Creating and configuring the metadata database

requires a database to store the metadata that is generated when you use the product. Before you install , you must create and configure this metadata database.

Before you begin

Before you begin

You need to enable a set of stored procedures for JDBC so that you can use certain functions of the DB2 Driver for JDBC and SQLJ on a DB2 for z/OS subsystem. Both the cube server and the Warehouse Administration Console use JDBC.

Run the SDSNSAMP batch job DSNTIJSG that is supplied with DB2 to set up and bind the following stored procedures:

DSNUTILU
ADMIN_JOB_SUBMIT
ADMIN_JOB_QUERY
ADMIN_JOB_FETCH
ADMIN_JOB_CANCEL
ADMIN_DS_BROWSE

For instructions for enabling the stored procedures, see Enabling the DB2-supplied stored procedures and defining the tables used by the IBM Data Server Driver for JDBC and SQLJ. Ensure that the executing WLM address spaces are defined accordingly, and that the following stored procedures, which use the _login() function to switch users, are defined to the RACF program control:

ADMIN_JOB_FETCH
ADMIN_JOB_SUBMIT
ADMIN_JOB_CANCEL
ADMIN_JOB_QUERY

About this task

About this task

When you run the product for the first time, it automatically creates the necessary tables and metadata in the metadata database (SQWCTRL).

Tip: When the metadata tables are created, you might see the following error:

DB2 SQL Error: SQLCODE=-443, SQLSTATE=38112, 
SQLERRMC=SQLTABLES;SQLTABLES;-805 
DWHD91T.DSNASPCC.DSNATBL8.1856182D029A8769

In this case, try running the DSNTIJSG job again to rebind all the stored procedures and eliminate consistency errors, or try installing program temporary fix (PTF) UK38087 and then running the DSNTIJSG job again.

For normal daily operations on the tables, only SELECT, UPDATE, DELETE, and INSERT authorities are necessary for the user ID that will be creating and deploying the cube.

Procedure

Procedure

To create and configure the metadata database:

Catalog the z/OS database by running the following commands on the Linux for System z system:

db2 catalog tcpip node node_name remote remote_z/os_computer_name server port_number_of_remote_z/os_computer_name

db2 catalog db remote_database_name as local_database_name at node node_name

Create a database for the metadata tables by running the following command:
```
db2 create database SQWCTRL stogroup storage_group_name
```
Note: SQWCTRL is the default name of the database. If you change the default name, be sure that you enter that name when prompted during the installation.
Grant authorities for the metadata database to the user ID that will be connecting to the z/OS database during the installation and configuration by running the following command:
```
Grant DBADM, DBCTRL, CREATETAB, CREATETS, DISPLAYDB,
DROP, LOAD, REORG, STATS ON DATABASE 
```
Grant create trigger authority to all schemas by running the following command:
```
Grant ALTERIN,CREATEIN,DROPIN on SCHEMA *
```
Grant DBADM for the database where the cube will be created to the user ID that will be creating the cube.

Results

The metadata database is created and configured, and you can now install .

What to do next

Running the installation program fordata warehousing in Db2