Siebel Database Upgrade Guide for DB2 for z/OS > Creating the Siebel Staging Database > Preparing the z/OS Upgrade Environment and Creating the Staging Database >

Creating and Allocating the z/OS Setup Data Sets

Perform the steps in the following procedure to create and allocate the z/OS setup data sets.

To define and allocate z/OS setup data sets

1. After you have successfully transferred the staging files generated by the Upgrade Wizard up to Pause #0, log on to the host/LPAR where the staging database is to be created.
2. To create the REXX, CNTL and JCLLIB data sets, navigate to the DSNHLQ.SIEBEL.JOB0 data set.
3. Go to Edit mode on the data set and submit the job using the JCL in the DSNHLQ.SIEBEL.JOB0 data set.
4. After submitting the job, enter cancel on the command line or press PF3 to save changes.
5. Verify that the job ran successfully (return code is 0) and that the following data sets were created:
   • DSNHLQ.SIEBEL.EXEC
   • DSNHLQ.SIEBEL.JCLLIB
   • DSNHLQ.SIEBEL.SP.SPCNTL
6. Verify that the following PDS members contain information that you defined in the Database Configuration Wizard on the midtier:
   • DSNHLQ.SIEBEL.EXEC(@TBOSTG) contains the value for the staging schema qualifier.
   • DSNHLQ.SIEBEL.EXEC(@TBOTAR) contains the value for the target schema qualifier.
7. To allocate the DSNHLQ.SIEBEL.EXEC REXX exec library, enter 6 on the TSO command line to go to the TSO Command Line Processor panel.
8. Enter the following command and press Enter to allocate the CLIST/EXEC library:

   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.

   The EXEC library DSNHLQ.SIEBEL.EXEC is used to execute all REXX execs. The panel and programs are located in this library. Execute the SBLUPG81 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.

   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.