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

Informix

oc_create_informix.sql
oc_drop_informix.sql
oc_upgrade20_informix.sql
oc_upgrade61_informix.sql
oc_upgrade65_informix.sql
oc_upgrade651_informix.sql 

DBAccess

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

Sybase

oc_create_sybase.sql
oc_drop_sybase.sql
oc_upgrade20_sybase.sql
oc_upgrade61_sybase.sql
oc_upgrade65_sybase.sql
oc_upgrade651_sybase.sql

ISQL

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):

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:

  1. Start the utility program.

  2. Connect to the TBC_MD database as user TBC.

  3. In the ocscript directory, open the appropriate SQL script file.

  4. 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.

  5. 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.

  6. Close the utility program.