Bookshelf Home | Contents | Index | PDF     

Siebel Database Upgrade Guide for DB2 for z/OS > Performing Postupgrade Tasks on the Target Database >

Performing Intersection Table Maintenance

Upgrades: Release 7.5.3 only. 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 SBLUPG81

    The Siebel In-Place Upgrade 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 Data Set Name High-Level Qualifier (DSNHLQ) used for the ITM/Dedup data sets produced during the development upgrade.

  4. Enter the DSNHLQ used for the development upgrade ITM/Dedup data sets, 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 data set &DSNHLQ.SIEBEL.INSTALL.JCL(ITMCONV).

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

    If the DSNHLQ and associated data sets 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 return code is 0 or 4 and that the JCLTEST return code is 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 data set &DSNHLQ.SIEBEL.INSTALL.JCL(UNPACK04).Submit the JCL in the data set to populate the PDS data sets.
  10. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 and that the JCLTEST return code is 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 data set &DSNHLQ.SIEBEL.INSTALL.JCL(LOADITM).Submit the JCL in the data set.
  4. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is 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 data set &DSNHLQ.SIEBEL.INSTALL.JCL(SUBITMUL).Submit the JCL in the data set.

    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 return code is 0 or 4 and that the JCLTEST return code is 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 postupgrade 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 data set 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 data set &DSNHLQ.SIEBEL.INSTALL.JCL(LOADITM2).Submit the JCL in the data set.
  14. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is 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 data set &DSNHLQ.SIEBEL.ITMJOBS.JCL.

    The PDS member list is displayed.

  18. Submit each member in the data set 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 return code is 0 or 4 and that the JCLTEST return code is 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 Main Menu.
    
Siebel Database Upgrade Guide for DB2 for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.