Upgrade Guide for DB2 UDB for z/OS > Database and UI Upgrade Planning > Planning Your Upgrade >

Obtaining Required IBM Utilities

Verify that the following IBM utilities are available for your upgrade to Siebel 7.8 for DB2 UDB for z/OS:

• DSNTIAUL. The upgrade uses DSNTIAUL to unload data delivered by Siebel.

  Prepare and bind DSNTIAUL by following the procedures in your IBM installation documentation. If you made local modifications, you might need to prepare and bind a separate version.

• DSNTEP2. The upgrade uses DSNTEP2 to execute SQL.

  Prepare and bind DSNTEP2 by following the procedures in your IBM installation documentation. If you made local modifications, you might need to prepare and bind a separate version. Also, if you are using a separate version of DSNTEP2, you need to change the SIEBSQL* members to reflect the new plan and program names.

• DFSORT. The utility DFSORT is used to manipulate data for data migration during upgrade.
• LOAD. The IBM DB2 Load utility is used to load data during data migration.
• REBUILD INDEX. The IBM DB2 REBUILD INDEX utility is used to build indexes after they are created using DEFER YES.
• IEBCOPY. The utility IEBCOPY is used to create members in installation datasets. Sequential datasets contains control information used by IEBCOPY.
• IEBGENER. The utility IEBGENER is used to copy sequential datasets.

For information about IBM utilities, see your IBM documentation.

CAUTION:  You can choose to use alternate third-party utility products that are preferred for your environment. Evaluate utilities by individual job. Be aware, however, that if you do use utilities other than those recommended above, you might have to modify the Siebel-supplied SQL to accord with the rules for those utilities. You must contact Siebel Expert Services for help with this task.