Upgrade Guide for DB2 UDB for z/OS > Upgrading the Database >

Deleting Redundant Upgrade Files

Upgrades: All upgrades.

Environments: Development (mainframe-centric) environment and Production environment.

This topic is part of an upgrade process. See How to Perform the Upgrade.

After you complete the database upgrade process, you can delete any upgrade files that are no longer required (for example, source tables). 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 also be deleted. The procedure in this topic describes how to drop the upgrade stored procedures.

For information on installing the stored procedures, see Installing Stored Procedures on the z/OS Host.

To drop the upgrade stored procedures

1. Log on to the z/OS host.
2. Submit the JCL in the dataset member DSNHLQ.SIEBEL.SP.CNTL(DRPSIA) or DSNHLQ.SIEBEL.SP.CNTL(DRPHOR), depending on your upgrade path.
3. Press PF3 to complete the process.