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

Defining and Allocating zSeries Setup Datasets

Complete the following procedure to define and allocate zSeries setup datasets.

To define and allocate zSeries setup datasets

1. After the transfer is successful, log on to the mainframe, and navigate to the DSNHLQ.SIEBEL.JOB0 dataset, for example, SK.SBL.SIEBEL.JOB0.
2. Go to Edit mode on the dataset.
3. Follow the procedures inside the DSNHLQ.SIEBEL.JOB0 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.

4. Submit the job using the JCL in dataset DSNHLQ.SIEBEL.JOB0.
5. After submitting the job, enter cancel on the command line or press PF3 to save changes.
6. 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.
7. Enter 6 on the TSO command line to go to the TSO Command Line Processor panel.
8. 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 you only reference Siebel executables, 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 TSO command ISRDDN.

   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.