Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading a Database from the Mainframe > Executing the Upgrade on the zSeries Host (Phase 2 of 2) >
Rebuilding the Gen Primary 7.7 Indexes
Perform the following task to submit the rebuild jobs for the 7.7 Gen Primary indexes. To rebuild a primary index
- If you are not on the Siebel Upgrade Main Menu, enter the following command:
TSO SBLUPG77
- Select option 4: UPGRADE - RUN UPGRADE/POST-UPGRADE MAINTENANCE.
The Siebel Upgrade Job Submission Menu appears.
- For Siebel eBusiness application upgrades, the panel ID is SBLRUNHP.
- For Siebel Industry application (SIA) upgrades, the panel ID is SBLRUNFP.
- Select the option for the application you are upgrading.
- Run the job using the JCL in dataset
DSNHLQ .SIEBEL.INSTALL.JCL(SUBGPREX) .
After the job is run, verify that the job ran successfully. (RC=0 or RC=4 indicate that the job was successful.)
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 Running the Siebel Upgrade Wizard.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
This submits 2000+ Index Rebuild jobs. The number of Index Rebuild jobs varies by upgrade type. Job names range from ###10001 to ###1nnnn.
- 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 Running the Siebel Upgrade Wizard.
|