Siebel Database Upgrade Guide for DB2 for z/OS > Upgrading the Target Database > Performing the In-Place Target Database Upgrade >

Creating and Deploying Stored Procedures on the Target Database

Perform the following task to install stored procedures and functions on the target database and to verify that they deployed correctly.

To install and verify stored procedures

1. On the Target Database In-Place Upgrade Menu, select option 6: Create SPs & Functions (Bind), and press Enter.

   A message appears telling you to use the instructions in the @README member to install the stored procedures and functions.

2. Enter Y to continue, and press Enter.

   The Target Database Stored Procedure Process Menu is displayed.

   
3. On the Target Database Stored Procedure Process Menu, select option 0. Copy Load Modules, and press Enter.
4. Run the job using the JCL in the data set DSNHLQ.SIEBEL.SP.CNTL(IEBCOPY).

   This job moves the stored procedure load modules into the WLMSPAS (this is the WLM load library you specified in Preparing the Upgrade Environment and Building the Staging Database).

5. Verify that the job ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs
6. After submitting the job, enter cancel on the command line or press PF3 to save changes.
7. On the Target Database Stored Procedure Process Menu, select option 1. Bind Stored Procedures, and press Enter.
8. Run the job using the JCL in one of the following data sets:
   • SNHLQ.SIEBEL.SP.CNTL(BINDHOR) for Siebel Business Applications upgrades
   • DSNHLQ.SIEBEL.SP.CNTL(BINDSIA) for Siebel Industry Applications upgrades

     This job binds the stored procedure packages.

     NOTE:  If the job fails because the procedure already exists, run the appropriate DROP procedure job, either DSNHLQ.SIEBEL.SP.CNTL(DRPSIA) or DSNHLQ.SIEBEL.SP.CNTL(DRPHOR), then run the bind job again.

9. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
10. After submitting the job, enter cancel on the command line or press PF3 to save changes.
11. On the Target Database Stored Procedure Process Menu, select option 2. WLM Refresh, and press Enter.
12. Submit the JCL in the data set DSNHLQ.SIEBEL.SP.CNTL(WLMREFSH).

    This job refreshes the DB2 WLM environment.

13. Verify that the job ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs.
14. Press PF3 twice to return to the Target Database In-Place Upgrade Menu.
15. Select option 7: Verify SP and Function Deployment, and press Enter.

    This places you in edit mode for one of the following PDS data sets and members:

    • For Siebel Business Applications upgrades: DSNHLQ.SIEBEL.INSTALL.JCL(SPVHOR)
    • For Siebel Industry Applications upgrades: DSNHLQ.SIEBEL.INSTALL.JCL(SPVSIA)
16. Run the JCL in the appropriate data set for your upgrade. The JCL in the SPVSIA and SPVHOR members executes each stored procedure against the target database after the new schema has been created and data has been loaded onto the target. This process verifies that the stored procedures have been installed and can be executed.
17. Verify that the job ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs.

    The JCLTEST return code must be FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.

18. After submitting the job, enter cancel on the command line or press PF3 to save changes.