|
Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe > Executing the Upgrade on the z/OS Host (Phase 1 of 2) >
Executing Index DDL and Executing Rebuild Indexes
Perform the following procedure to execute index DDL and execute rebuild indexes. To execute the index DDL and rebuild indexes
- If you are not on the Siebel Upgrade Main Menu, enter the following command:
TSO SBLUPG78
- Select option 5: RUN UPGRADE / POST-UPGRADE MAINTENANCE.
The Siebel Upgrade Job Submission Menu for your upgrade path appears.
- For Siebel Business application upgrades, the panel ID is SBLRUNHP.
- For Siebel Industry application (SIA) upgrades, the panel ID is SBLRUNFP.
- Select option 4: "OLD SCHEMA INDEX DDL".
This places you in edit mode for dataset DSNHLQ.SIEBEL.INSTALL.JCL(SCHEMA02).
- Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(SCHEMA02).
This job runs DDL Create Index statements to build the old-schema non-unique and obsolete indexes.
- Verify that the job ran successfully, RC=
0 or RC=4 in steps DDLNUIND and DDLOIND.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
The Siebel Upgrade Job Submission Menu for your upgrade path appears. The panel ID is SBLRUNFP.
- Select option 5: "OLD SCHEMA INDEX REBUILDS".
This places you in edit mode for dataset DSNHLQ.SIEBEL.INSTALL.JCL(SUBIX).
- Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(SUBIX).
This job automatically submits all Non-Unique and Obsolete Index Rebuild jobs referenced in datasets: DSNHLQ.SIEBEL.EXEC(@DDLNUIX) and DSNHLQ.SIEBEL.EXEC(@DDLOIX).
Non-unique job names range from ###N0001 to ###Nnnnn. Obsolete job names range from ###O0001 to ###Onnnn, where the placeholder ### represents your job prefix and nnnn represents a sequential number from 0001 to n.
- Verify that the job ran successfully, RC=
0 or RC=4.
Jobs with an ABEND (end abnormally) U99 or U099 message are jobs that failed.
If you selected Siebel-Scheduled Mode, this job is logged (as Completed Successfully or Failed) to the target Siebel log table: TARGET_TABLEOWNER.TMP_SBLLOG_TAR.
NOTE: You must fix any failed jobs before proceeding with the upgrade. For information on restarting failed jobs, see Restarting Failed Jobs on the Mainframe.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
- View the job status.
For information on how to view job status if you selected Siebel-Scheduled Mode, see Viewing the Siebel Job Log Status.
|
