Chapter 7: Creating Database Tables

Creating CSP tables

The system tables described in the following table are required if you are using CSPs in DB2.

**Table 7-1: CSP tables**
CSP	System table	Table description
sp_stored_procedure	SYSPROCEDURES	This table contains specific information about stored procedures created at your site.
sp_sproc_columns	SYSPROCCOLUMNS	These tables contain specific information about the arguments in the stored procedures created at your site.

The system administrator maintains the information in each table.

To use the cspdb2.sql script to create the tables

Start the DirectConnect server by issuing the direct -S command.
If you are using Windows, display the Windows command line.
Run cspdb2.sql by entering the following:
```
isql -Uuserid -Ppassword -Sservice_name -icspdb2.sql
```
where:
- isql starts the utility of the same name.
- userid is a valid DB2 user ID with create table privileges.
- password is a valid password for DB2 for the user ID you entered.
- service_name is the desired DB2 service name.
The script drops any tables with the same names as the tables created. If the table does not exist, the DropTable command returns an error message. This does not prevent successful execution of the rest of the script.
Log in to DirectConnect and issue a SELECT statement against each table to verify that you successfully created each one.
Grant SELECT authorization to the following DB2 system tables for all CSP users:
- SYSIBM.SYSCOLAUTH
- SYSIBM.SYSCOLUMNS
- SYSIBM.SYSDATABASE
- SYSIBM.SYSFOREIGNKEYS
- SYSIBM.SYSINDEXES
- SYSIBM.SYSKEYS
- SYSIBM.SYSRELS
- SYSIBM.SYSSYNONYMS
- SYSIBM.SYSTABAUTH
- SYSIBM.SYSTABLES
Although cspdb2.sql automatically grants select authorization to PUBLIC for the tables it creates, you must grant authorization to these DB2 system tables.