Siebel Database Upgrade Guide for DB2 UDB for z/OS > Performing Post-Upgrade Tasks On the Target Database >

Performing Intersection Table Maintenance

Upgrades: All upgrades.

Environments: Production test, production.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

The intersection table maintenance jobs (ITM) identify and resolve potential duplicate row IDs from intersection tables. Perform the following procedures to prepare and run the ITM jobs.

To prepare the intersection table maintenance jobs

1. Enter the following command and press Enter:

   TSO SBLUPG80

   The Siebel In-Place Upgrade 8.0 Main Menu appears. The panel ID is SBLUPG8P.

2. Select option 4: Post-Upgrade, and press Enter.

   The Target Database Post-Upgrade Menu appears. The panel ID is SBLPSTP.

3. Select option 2: Copy ITM files from Development HLQ, and press Enter. This process copies the ITM development upgrade files and then converts them for use in the production upgrade.

   A message appears prompting you to enter the Dataset Name High-Level Qualifier (DSNHLQ) used for the ITM/Dedup datasets produced during the development upgrade.

4. Enter the DSNHLQ used for the development upgrade ITM/Dedup datasets, and press Enter.

   If the DSNHLQ you enter is valid, the following message appears:

   Press Enter and submit JCL to complete required changes....

5. Run the JCL in dataset &DSNHLQ.SIEBEL.INSTALL.JCL(ITMCONV).

   The datasets are copied from the development environment and renamed to use the production upgrade DSNHLQ.

   If the DSNHLQ and associated datasets do not exist, or if you enter an invalid development upgrade DSNHLQ, the process stops. Correct the problem before running the process again.

6. Verify that the job ran successfully.

   Review the output in SDSF or another job output facility. Verify that the RC=0 or RC=4 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.

7. After submitting the job, enter cancel on the command line or press PF3 to save changes.
8. On the Target Database Post-Upgrade Menu, select option 3: Populate PDS Datasets, and press Enter.
9. You are placed in edit mode in the dataset &DSNHLQ.SIEBEL.INSTALL.JCL(UNPACK04).Submit the JCL in the dataset to populate the PDS datasets.
10. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the RC=0 and that the JCLTEST return code=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. On the Target Database Post-Upgrade Menu, select option 4: Add Jobcards to Unload & Delete/Update Jobs, and press Enter.
13. You are prompted to enter a three-character jobname prefix. Enter the prefix you want to use, and press Enter.

    Messages are displayed indicating that the JCL generation is in process, then a series of messages indicate the number of jobs generated. The number of ITM Unload jobs that are generated varies according to your upgrade path.

    The jobcards are added to the JCL templates.

Perform the following procedure to run the intersection table maintenance jobs.

To run the intersection table maintenance jobs

1. On the Target Database Post-Upgrade Menu, select option 5: Intersection Table Maintenance, and press Enter.

   The Intersection Table Maint. Process Menu appears. The panel ID is SBLITMP.

2. Select option 0:Load Siebel Log Entries (1), and press Enter.
3. You are placed in edit mode in the dataset &DSNHLQ.SIEBEL.INSTALL.JCL(LOADITM).Submit the JCL in the dataset.
4. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the RC=0 or RC=4 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
5. After submitting the job, enter cancel on the command line or press PF3 to save changes.
6. On the Intersection Table Maint. Process Menu, select option 1: Run Unload Jobs to Identify Candidate Tables, and press Enter.
7. You are placed in edit mode in the dataset &DSNHLQ.SIEBEL.INSTALL.JCL(SUBITMUL).Submit the JCL in the dataset.

   This job submits all the ITM Unload jobs to run in parallel. The number of jobs that are run varies according to your upgrade path.

8. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the RC=0 or RC=4 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
9. After submitting the job, enter cancel on the command line or press PF3 to save changes.
10. On the Intersection Table Maint. Process Menu, select option 2: Generate Delete/Update Jobs for Candidates Identified, and press Enter:
    • If no duplicate row IDs are identified in the intersection tables, a message appears indicating that the ITM process is completed. You can proceed to the next step in the post-upgrade process.
    • If tables are identified that contain duplicate row IDs, you are prompted to enter the COMMIT frequency.
11. Enter the COMMIT frequency you want to use or press Enter to accept the default value of 100.

    Messages appear indicating that the input Unload PDS dataset is being read and the update and delete jobs are being built.

12. On the Intersection Table Maint. Process Menu, select option 3: Load Siebel Log Entries (2), and press Enter.
13. You are placed in edit mode in the dataset &DSNHLQ.SIEBEL.INSTALL.JCL(LOADITM2).Submit the JCL in the dataset.
14. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the RC=0 or RC=4 and that the JCLTEST return code=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 Intersection Table Maint. Process Menu, select option 4: Run Delete/Update Jobs for Candidates Identified, and press Enter.
17. You are placed in edit mode in the dataset &DSNHLQ.SIEBEL.ITMJOBS.JCL.

    The PDS member list is displayed.

18. Submit each member in the dataset by selecting the PDS member, entering submit on the command line, and pressing Enter. Repeat for each member.
19. Verify that each job ran successfully. Review the output in SDSF or another job output facility. Verify that the RC=0 or RC=4 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
20. After submitting the job, press PF3 to return to the In-Place Upgrade 8.0 Main Menu.