Siebel Database Upgrade Guide for DB2 for z/OS > Performing Postupgrade Tasks on the Target Database >

Deleting Redundant Upgrade Files

Upgrades: All upgrades.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

After you complete the database upgrade process, delete any upgrade files that are no longer required. The procedures in this topic describe how to drop all staging database objects, and how to delete Unload data sets and stored procedures.

Removing the Staging Database

After you have successfully completed your database upgrade, you must remove the staging database objects before you can reuse the same database prefix and tableowner name.

To remove the staging database

1. Log on to the z/OS host.
2. Submit the JCL in the &DSNHLQ.SIEBEL.INSTALL.JCL(STGDROPJ) data set.

   The staging database objects are removed.

3. Press PF3 to complete the process.

Deleting Unload Data Sets

When your database upgrade is completed, you no longer require the Unload data sets. Perform the following procedure to generate a list of the Unload data sets and then delete them.

NOTE:  Before performing this procedure, you must have the *.siebel.exec library allocated.

To delete unload data sets

1. Log on to the z/OS host.
2. Enter the following command and press Enter:

   TSO SBLDELDS

   A list of the unload data sets to be deleted is generated.

3. Navigate to the *.siebel.install.jcl library.
4. Submit the JCL in the data set &DSNHLQ.SIEBEL.INSTALL.JCL(DELULDS) to delete the Unload data sets.
5. Verify that the job ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs.

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.