Creating Tables for the TBC_MD Database

Create tables for the TBC_MD database with the same utility program that you typically use.

The standard sample application SQL scripts used to create tables for the TBC_MD database are in the ocscript directory where you installed Integration Server.

The SQL scripts in the ocscript directory are the same scripts that you use to create any OLAP Metadata Catalog. For information on OLAP Metadata Catalogs, see Creating, Upgrading, and Deleting OLAP Metadata Catalogs.

The utilities listed in Table 11 have been tested to work with the SQL scripts:

Table 11. Tested Utilities for Creating TBC_MD Tables

Database	SQL Script	Utility Program
IBM DB2	oc_create_db2.sql oc_drop_db2.sql oc_upgrade20_db2.sql oc_upgrade61_db2.sql oc_upgrade65_db2.sql oc_upgrade651_db2.sql	IBM DB2 Command Center or >DB2 -tvf
Microsoft SQL Server	oc_create_sqlsrv.sql oc_drop_sqlsrv.sql oc_upgrade20_sqlsrv.sql oc_upgrade61_sqlsrv.sql oc_upgrade65_sqlsrv.sql oc_upgrade651_sqlsrv.sql	Query Analyzer
Oracle	oc_create_oracle.sql oc_drop_oracle.sql oc_upgrade20_oracle.sql oc_upgrade61_oracle.sql oc_upgrade65_oracle.sql oc_upgrade651_oracle.sql oc_create_oracle_unicode.sql oc_create_oracle9i_unicode.sql	SQL*Plus
Teradata	oc_create_teradata.sql oc_drop_teradata.sql oc_upgrade65_teradata.sql oc_upgrade651_teradata.sql	BTEQ

Note:

The scripts used to upgrade OLAP Metadata Catalog manually from Release 2.0 to Release 6.2 are identical to those used to upgrade from Release 2.0 to Release 6.1. Therefore, the names have not been changed from the names used in Integration Services Release 6.1. If you are upgrading OLAP Metadata Catalog from Release 2.0 to Release 6.2, use the scripts named *61*.sql that are appropriate for your RDBMS.

Integration Services provides five SQL scripts for each RDBMS (with the exception of Teradata):

oc_create_database_name.sql to build tables
oc_drop_database_name.sql to drop tables
oc_upgrade20_database_name.sql to upgrade tables from Integration Services Release 1.x to 2.0 (does not apply to Teradata users)
oc_upgrade61_database_name.sql to upgrade tables from Integration Services Release 2.0 to 6.2 (does not apply to Teradata users)
oc_upgrade65_database_name.sql to upgrade tables from Integration Services Release 6.1 or 6.2 to 6.5
oc_upgrade651_database_name.sql to upgrade tables from Integration Services Release 6.5 to 6.5.1

If you need to rebuild tables, you must first drop the tables before you build them again.

Caution!

You must create the tables for the TBC_MD database as user TBC or portions of the standard sample application will not work.

To create tables for the TBC_MD database:

Start the utility program.
Connect to the TBC_MD database as user TBC.
In the ocscript directory, open the appropriate SQL script file.
Run the SQL script.
Microsoft SQL Server: You receive a message that you did not create data or rows. This message is normal because you created only tables and columns.
Verify that you have created the TBC_MD tables; for example, type the following command:
```
SELECT * FROM TBC.MS_INFO 
```
or start the RDBMS and verify that the TBC_MD database has the new tables.
Close the utility program.