|
Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe >
Preparing Siebel-Scheduled Jobs 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. NOTE: The procedure in this section uses Siebel-Scheduled job execution but you can also choose to use a third party job scheduler. For information on 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.
Perform the procedures in this section to prepare the upgrade JCL and to generate non-unique index rebuilds. You can choose to generate index rebuilds in either TSO foreground mode or batch mode. It is recommended that you perform the procedure in batch mode. To complete Siebel-scheduled JCL preparation (Part 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.
- 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.
- 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.
- Press Enter.
- From the JCL-PREP: SIEBEL LOGGING/SCHEDULING Menu (panel ID is SBLJCL1P), 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.
- Press Enter.
- From the JCL-PREP: SIEBEL LOGGING/SCHEDULING Menu (panel ID is SBLJCL1P), 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.
- Press Enter. The JCL-PREP: SIEBEL LOGGING/SCHEDULING Menu appears (panel ID is SBLJCL1P).
To generate non-unique index rebuilds
- From the JCL-PREP: SIEBEL LOGGING/SCHEDULING Menu (panel ID is SBLJCL1P), select option 4: GENERATE INDEX REBUILDS.
The Index Menu appears. The panel ID is SBLIDXP.
The following steps describe how to rebuild non-unique indexes using the TSO foreground mode, but either batch or foreground mode can be used.
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: It is recommended that you perform the procedure in batch mode. Before doing so, make sure you modify the ispf batch procedure, dsnhlq.siebel.proc(ispbat), to your installation standards. If you perform the procedure in foreground mode, make sure your logon region size is at least 7092.
- Select option 1: NON-UNIQUE INDEX.
(To run option 1: NON-UNIQUE INDEX in batch mode, enter 1 in the option field, then tab to the RUN OPTIONS 1-3 IN BATCH? N (Y/N) screen. Replace the N with a Y.)
The following message appears:
SIEBEL JCL MODIFICATIONS TO BE APPLIED BASED ON RULES THAT SIEBEL LOGGING/SCHEDULING WILL BE USED. MESSAGE: SBLJCL-0014.
- 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.
|
