Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe > Preparing the z/OS Host Environment >

Defining and Allocating z/OS Setup Datasets

The following procedure defines and allocates z/OS setup datasets.

To define and allocate z/OS setup datasets

1. After you have successfully transferred the files generated by the Upgrade Wizard up to Pause #1, log on to the mainframe, and navigate to the DSNHLQ.SIEBEL.JOB0 dataset, for example, SK.SBL.SIEBEL.JOB0.

   Go to Edit mode on the dataset.

2. Follow the procedures inside the file. Use uppercase letters only. As indicated in the Comments section, change all references of SIEBELHLQ to DSNHLQ using the following command:

   c SIEBELHLQ DSNHLQ ALL

   CAUTION:  The variables DSNHLQ, SIEBELQ1, and SIEBELHLQ all represent the same value, and this value must be the same throughout your deployment. Ensure that your job card follows your organization's naming standards.

3. Submit the job using the JCL in dataset DSNHLQ.SIEBEL.JOB0.
4. After submitting the job, enter cancel on the command line or press PF3 to save changes.
5. Verify that the job ran successfully.
   1. Verify that the RC=0.
   2. Verify that three datasets were created:
      • DSNHLQ.SIEBEL.EXEC
      • DSNHLQ.SIEBEL.JCLLIB
      • DSNHLQ.SIEBEL.SP.CNTL
   3. Verify that the following PDS members contain information that you defined in the Database Server Configuration Wizard on the midtier:
      • DSNHLQ.SIEBEL.EXEC(@TBOSRC) contains the value for the source schema qualifier.
      • DSNHLQ.SIEBEL.EXEC(@TBOTAR) contains the value for the target schema qualifier.
6. Enter 6 on the TSO command line to go to the TSO Command Line Processor panel.
7. Enter the following command to allocate the CLIST/EXEC library DSNHLQ.SIEBEL.EXEC:

   alloc f(sysexec) da('DSNHLQ.SIEBEL.EXEC') shr reuse

   NOTE:  To make sure that only Siebel executables are referenced, this command disables all CLIST libraries allocated to the logged-in user.

   No message appears when the library is allocated. To verify that the exec library is listed in the file allocations by name, enter the TSO command ISRDDN.

   Execute the SBLUPG78 member from the DSNHLQ.SIEBEL.EXEC REXX library to display the Siebel Upgrade Menu; you can use this menu to navigate through the steps in the upgrade process.

   The EXEC library DSNHLQ.SIEBEL.EXEC is used to execute all REXX execs. The panel and programs are located in this library.

   TIP:   The TSO command allocation for the EXEC library must be reissued with each TSO logon. Add this allocation to your personal logon CLIST to avoid having to reallocate the DSNHLQ.SIEBEL.EXEC library with each new TSO logon.