Deleting Stored Procedures

A number of stored procedures are installed during the database upgrade on the z/OS host to facilitate upgrade processing. These stored procedures are not required after the upgrade has been completed successfully and can be deleted. The following procedure describes how to drop the upgrade stored procedures.

For information on installing the stored procedures, see Creating and Deploying Stored Procedures on the Target Database.

To drop the upgrade stored procedures

1. Log on to the z/OS host.

2. Submit the JCL in the data set member DSNHLQ.SIEBEL.SP.CNTL(DRPSIA) or DSNHLQ.SIEBEL.SP.CNTL(DRPHOR), depending on your upgrade path.

   The Stored Procedures are deleted.

3. Press PF3 to complete the process.