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

Installing Stored Procedures on the z/OS Host

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.

Perform the following task to unpack the unload and load cards and execute the DDL.

To install and verify stored procedures

1. On the Siebel Upgrade Main Menu, select option 3: SCHEMA/JCL - BUILD DDL AND JCL-PREP FOR UPGRADE.

   The SCHEMA/JCL MENU appears. The panel ID is SBLUPGP.

2. On the Schema/JCL Menu, select option 1: PDS/SCHEMA/VERIFICATION UTILITIES.

   The Utilities Menu appears. The panel ID is SBLUTL2P.

3. On the Utilities Menu, select option 4: INSTALL/DEPLOY STORED PROCEDURES AND UDF.

   This places you in edit mode for PDS dataset DSNHLQ.SIEBEL.SP.CNTL.

4. Select the DSNHLQ.SIEBEL.SP.CNTL(@README) PDS member.

   This places you in edit mode for PDS dataset and member DSNHLQ.SIEBEL.SP.CNTL(@README).

5. Review the @README file.
6. Select the IEBCOPY PDS member.

   This places you in edit mode for PDS dataset and member DSNHLQ.SIEBEL.SP.CNTL(IEBCOPY).

7. Follow the procedures in the JCL.

   The WLM library to be used will vary based on the DB2 subsystem being used. You must replace LOAD_MODULE_DSNAME_SPAS with your WLM load library name.

   This job moves Stored Procedure load modules to the WLMSPAS.

   NOTE:  Do not change the @DB2WLM member. This value was set on the SBLSETV panel as part of the environment/dataset setup process.

8. Verify that the job ran successfully, RC=0.

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

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

9. Select the PDS member for your upgrade path.
   • Use BINDHOR if you are upgrading a Siebel 7.0.4, 7.5.2, or 7.7 application.
   • Use BINDSIA if you are upgrading a SIA 6.2.1, SIA/FINS/SIS 7.0.4, SIA 7.5.2, or SIA 7.7 application.

     This places you in edit mode for PDS dataset member DSNHLQ.SIEBEL.SP.CNTL(BINDSIA) or DSNHLQ.SIEBEL.SP.CNTL(BINDHOR).

     This job binds stored procedure packages.

     NOTE:  A DROP procedure job is included (DSNHLQ.SIEBEL.SP.CNTL(DRPSIA) or DSNHLQ.SIEBEL.SP.CNTL(DRPHOR)). If the procedure already exists, you must drop it before running the bind job.

10. Verify that the job ran successfully, RC=0 or RC=4.

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

11. After submitting the job, enter cancel on the command line or press PF3 to save changes.
12. Select option 5: RUN STORED PROCEDURE INSTALL VERIFICATION.

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

    • For Siebel Business application upgrades: DSNHLQ.SIEBEL.INSTALL.JCL(SPVHOR)
    • For Siebel Industry application upgrades: DSNHLQ.SIEBEL.INSTALL.JCL(SPVSIA)
13. Run the required JCL, such as in dataset DSNHLQ.SIEBEL.INSTALL.JCL(SPVSIA).

    This job executes each stored procedure against an empty target schema. This process is to verify that the stored procedures have been installed and can be executed.

14. Verify that the job ran successfully, RC=0.

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

15. After submitting the job, enter cancel on the command line or press PF3 to save changes.
16. On the Utilities Menu, Press PF3.

    The Schema/JCL Menu for your upgrade path appears. The panel ID is SBLUPGP.

You install the stored procedures and UDFs to facilitate upgrade processing. You can review the SQL for these objects in the dataset DSNHQL.SIEBEL.SP.SPDDL.