Chapter 6: Using Stored Procedures

CSPs and DBMS

Several CSPs access tables that the DB2 database administrator maintains, including the tables shown in the following table.

**Table 6-21: DB2 Database administrator-maintained tables**
Member	Description
sp_server_info	The server, including capabilities and limitations
sp_sproc_columns	Stored procedures that an application can execute
sp_stored_procedures	Stored procedures executable from DirectConnect

During installation of the CSPs, the tables that these CSPs query are created and populated.

For details on the CSPs, see the Mainframe Connect DirectConnect for z/OS Option User's Guide for DB2 Access Services.