Upgrade Guide for DB2 UDB for z/OS and OS/390 > 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.7 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.

NOTE:  You can use alternate third-party products that are preferred for your environment. Evaluate utilities by individual job.

Upgrade Guide for DB2 UDB for z/OS and OS/390