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

Creating and Allocating the z/OS Setup Data Sets


The following procedure is used to create and allocate the z/OS setup data sets.

To define and allocate z/OS setup datasets

  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. Verify that the Procedure parameter on the logon panel is set to DB2REL8.
  2. To create the REXX, CNTL and JCLLIB datasets, navigate to the DSNHLQ.SIEBEL.JOB0 dataset.
  3. Go to Edit mode on the dataset and submit the job using the JCL in the DSNHLQ.SIEBEL.JOB0 dataset.
  4. After submitting the job, enter cancel on the command line or press PF3 to save changes.
  5. Verify that the job ran successfully (RC=0) and that the following datasets 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 SBLUPG80 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.

Siebel Database Upgrade Guide for DB2 UDB for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.