This chapter explains how to run SQL scripts to set up database tables, which are necessary for using DB2 with DirectConnect for z/OS Option.
Sybase provides SQL scripts that allow you to create a sample database and system tables on DB2. The installation program installs the scripts in the scripts subdirectory.
The scripts subdirectory is at <install_dir>/DC-15_0/scripts (UNIX) and <install_dir\DC-15_0\scripts (Windows).
The scripts are:
The pubsdb2.sql script creates sample PUBS tables that simulate the PUBS database provided with ASE. By installing PUBS tables on DB2, you can more easily test the transfer process between ASE and DB2. These tables are not required for DirectConnect for z/OS Option setup, but Sybase recommends installing them to assist Sybase Technical Support.
The cspdb2.sql script creates tables for catalog stored procedures (CSPs). These tables are required for DirectConnect for z/OS Option setup with DB2.
Use the isql utility to run the scripts. Sybase recommends that you complete all of these tasks from the platform server before you attempt to install Open Client/DB-Library files on any client machines.