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

Preparing Siebel-Scheduled Jobs on the zSeries 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.

NOTE:  The procedure in this section uses Siebel-Scheduled job execution. For information about choosing a scheduler, see Executions of Jobs Using Siebel-Scheduled Mode or Vendor-Scheduled Mode. Choose your scheduling method carefully, because once you begin an upgrade process under a selected mode, you cannot change your scheduling mode or reverse this decision.

To complete JCL preparation (Part 1)

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 2: SIEBEL SCHEDULED - JCL-PREP TO BUILD/EXECUTE/MANAGE JOBS VIA SIEBEL.

   The JCL-PREP: Siebel Logging/Scheduling Menu appears. The panel ID is SBLJCL1P.

3. Select option 1: ADD JOBCARDS, BUILD SIEBEL JOB LOGGING CAPABILITIES.

   A message appears before each part of the JCL preparation runs. The following messages are examples of the messages you receive.

   NOTE:  The messages you receive depend on your upgrade path.

   SIEBEL JCL MODIFICATIONS TO BE APPLIED BASED ON RULES THAT SIEBEL LOGGING/SCHEDULING WILL BE USED. MESSAGE: SBLJCL-0012.

   JOB LOG LOADFILE BEING WRITTEN TO: DSN= DSNHLQ.SIEBEL.JOBLOG.LOADFILE.

   UNLOAD JCL - ADDING JOBCARDS/LOGGING DSN= DSNHLQ.SIEBEL.DDLIMP.UNLOAD.CNTL.

   LOAD JCL - ADDING JOBCARDS/LOGGING DSN= DSNHLQ.SIEBEL.DDLIMP.LOAD.CNTL.

   DATA MIGR-PRESCHM JCL - ADDING JOBCARDS/LOGGING DSN= DSNHLQ.SIEBEL.PRESCHM.JCL.

   DATA MIGR-PRDCFG JCL - ADDING JOBCARDS/LOGGING DSN= DSNHLQ.SIEBEL.PRDCFG.JCL.

   DATA MIGR-GEN PRIMARY JCL - ADDING JOBCARDS/LOGGING DSN= DSNHLQ.SIEBEL.GENPRIM.JCL.

   DATA MIGR-UPGISS JCL - ADDING JOBCARDS/LOGGING DSN= DSNHLQ.SIEBEL.UPGISS.JCL.

   PROCESSING COMPLETE...
***

   When three asterisks (***) appear, the process is complete.

4. Press Enter.

   The JCL-PREP: SIEBEL LOGGING/SCHEDULING Menu appears. The panel ID is SBLUPGP.

5. Select option 2: ADD SIEBEL JOB LOGGING, JCL COND-CODE CHECKS.

   A series of messages displays as each part of the JCL preparation runs:

   NOTE:  The messages you receive depend on your upgrade path.

   • SIEBEL JCL MODIFICATIONS TO BE APPLIED BASED ON RULES THAT SIEBEL LOGGING/SCHEDULING WILL BE USED. MESSAGE: SBLJCL-0012.
   • MODIFY UNLOAD JCL - ADDING SIEBEL LOGGING DSN= DSNHLQ.SEBEL.DDLIMP.UNLOAD.CNTL.
   • MODIFY LOAD JCL - ADDING SIEBEL LOGGING DSN= DSNHLQ.SIEBEL.DDLIMP.LOAD.CNTL.
   • MODIFY DATA MIGR-PRESCHM JCL - ADDING SIEBEL LOGGING DSN= DSNHLQ.SIEBEL.PRESCHM.JCL.
   • MODIFY DATA MIGR-GEN PRIMARY JCL - ADDING SIEBEL LOGGING DSN= DSNHLQ.SIEBEL.GENPRIM.JCL.
   • PROCESSING COMPLETE...
***

     When three asterisks (***) appear, the process is complete.

6. Press Enter.

   The JCL-PREP: SIEBEL LOGGING/SCHEDULING Menu appears. The panel ID is SBLUPGP.

7. Select option 3: ADD JOBSTEP TO EACH DATA MIGRATION JOBSTREAM THAT AUTO-SUBMITS DEPENDENT JOB TO JES INTRDR. DEPENDENT JOB SUBMITTED ONLY WHEN PREDECESSOR JOB RAN SUCCESSFULLY.

   A series of messages displays as each part of the JCL preparation runs:

   NOTE:  The messages you receive depend on your upgrade path.

   SIEBEL JCL MODIFICATIONS TO BE APPLIED BASED ON RULES THAT SIEBEL LOGGING/SCHEDULING WILL BE USED. MESSAGE: SBLJCL-0012.

   PLEASE NOTE: THE FOLLOWING CHANGES WILL BE APPLIED TO SOURCE TABLE UNLOAD AND DATA MIGRATION JCL. (EXAMPLES: PRESCHM, PRDCFG, UPGISS).

   MODIFY DATA MIGR-PRESCHM JCL - ADD DEPENDENT JOB SUBMIT JCL DSN= DSNHLQ.SIEBEL.PRESCHM.JCL.

   PROCESSING COMPLETE...
***

   NOTE:  The type and number of messages you receive depends on your upgrade.

8. Press Enter.

   The JCL-PREP: SIEBEL LOGGING/SCHEDULING Menu appears. The panel ID is SBLUPGP.

9. On the Schema/JCL Menu for your upgrade path, select option 2: SIEBEL SCHEDULED - JCL-PREP TO BUILD/EXECUTE/MANAGE JOBS VIA SIEBEL.

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

10. Select option 4: GENERATE INDEX REBUILDS.

    The Index Menu appears. The panel ID is SBLIDXP.

11. Select option 1: NON-UNIQUE INDEX.

    The following message appears:

    SIEBEL JCL MODIFICATIONS TO BE APPLIED BASED ON RULES THAT SIEBEL LOGGING/SCHEDULING WILL BE USED. MESSAGE: SBLJCL-0014.

12. When the following message appears, specify the number of indexes to be included in each rebuild job:

    ENTER THE MAXIMUM NUMBER OF INDEXES TO BE INCLUDED IN A SINGLE REBUILD JOB. (PRESS ENTER TO ACCEPT DEFAULT OF 3, MAXIMUM IS 10)

    CAUTION:  Consider your objective before choosing a maximum number of indexes for each job. Increasing this number results in fewer jobs but requires more memory and sort work. Reducing this number results in more jobs—reducing resource requirements but building fewer indexes in parallel.

    During the Non-Unique Index Rebuilds process, the following series of message appears as the process runs.

    GENERATING INDEX REBUILD JOBS FOR NON-UNIQUE INDEXES OLD-SCHEMA BUILDING NON-UNIQUE-INDEX REBUILDS (DDLNUIND) DSN= DSNHLQ.SIEBEL.DDLNUIND.JCL
DSN= DSNHLQ.SIEBEL.DDLNUIND.SQL.

    NUMBER OF INDEX REBUILD JOBS BUILT = 951.

    Index count varies according to your upgrade path and the number of indexes included in each job.

    GENERATING INDEX REBUILD JOBS FOR OBSOLETE INDEXES OLD-SCHEMA - BUILDING OBSOLETE-INDEX REBUILDS (DDLOIND) DSN= DSNHLQ.SIEBEL.DDLOIND.JCL
DSN= DSNHLQ.SIEBEL.DDLOIND.SQL.

    NUMBER OF INDEX REBUILD JOBS BUILT = 101.

    Index count varies according to your upgrade path and the number of indexes included in each job.

The preceding example used TSO foreground mode. The procedure can be performed in either batch or foreground mode.

NOTE:  It is recommended that you perform the procedure in batch mode. Performing the procedure in batch mode executes options 1-3 on the foreground screen.

• In foreground mode, messages are displayed on the screen as the JCL-Prep progresses. This mode will lock up your session until the option is complete. Each option can take an extended period of time (more than thirty minutes), depending on the user's dispatching priority.

  NOTE:  If you perform the procedure in foreground mode, make sure your logon region size is at least 7092.

• To perform the procedure in batch mode, tab to the screen location named: RUN OPTIONS 1-3 IN BATCH? N (Y/N). Replace the N with a Y.

  NOTE:  Before performing the procedure in batch mode, make sure you modify the ispf batch procedure, dsnhlq.siebel.proc(ispbat), to your installation standards.

The options on the JCL-PREP: Siebel Logging/Scheduling Menu must be performed in the order in which they are listed. For example, you must complete step 1 before performing step 2, and so on.