Applying the DDL Files on the DB2 Host

The following procedure describes how to apply the DDL files on the host.

To apply the DDL files on the DB2 host

1. When the DDL file transfer is successfully completed, log on to the mainframe and navigate to the Data Set List Utility (DSLIST) panel.

   The DSLIST panel reflects the data sets associated with the user ID you entered previously when logging on.

2. Edit the HLQ.SIEBEL.INST.JOBINSTL data set, for example, SIEBLQ1.SIEBEL.INST.JOBINSTL, by entering e before the data set name and pressing Enter twice.

   The Edit Entry Panel appears.

3. As instructed in the comments section, change all occurrences of SIEBELQ1 to your HLQ using the following command:

   c SIEBELQ1 HLQ ALL

   Note: Make sure that your entry is in capital letters.

4. Press Enter, and the changes are made.

5. Entersubmit on the Command line, and press Enter to submit the job.

6. Details of the job are displayed. Press Enter again and a new data set named HLQ.SIEBEL.INST.EXEC is created.

7. Press F3 to return to the DSLIST screen.

8. On the DSLIST screen, edit the HLQ.SIEBEL.INST.EXEC data set by entering e before the data set name and pressing Enter.

9. Enter exec before the SBLINST member and press Enter to start the installation.

10. On the Siebel Install Main Menu screen, you can select one of the following options:

    • 1. Generate Siebel DDL - Generate JCL and DDL

    • 2. Generate View DDL - Generate VIEW DDL

    Enter 1 on the Command line to create the JCL and DDL used to generate the schema.

11. Enter the DDL input data set name, for example, HLQ.SIEBEL.INST.SCHEMA, and then press Enter.

12. Press Enter again and an SQL data set named HLQ.SIEBEL.INST.SCHEMA.SCH is created.

13. Press F3 to exit after the job completes.

14. On the DSLIST screen, enter e before the HLQ.SIEBEL.INST.SCHEMA.SCH data set, and press Enter.

    Note: If you use a tool other than the DSNTEP2 tool to create objects, specify the program and plan names of the tool you are using in the SIEBSQLA member, for example:

    DSN SYSTEM(Q109)
    RUN PROGRAM(MYTEP2) PLAN(MYTEP2) PARMS(‘ /SQLTERM(/) ‘)
    END

15. In the HLQ.SIEBEL.INST.SCHEMA.SCH data set, edit the following JCL members in the order shown. Run the GRJCL member last because it grants permissions to the objects (database, table spaces and tables) created when you run the other three members.

    • DBJCL

    • TSJCL

    • TBJCL

    • GRJCL

    To edit and run each JCL member, do the following:

    1. Enter e before the JCL member, and press Enter.

    2. Edit the job card parameters in each member, for example, specify the appropriate CLASS and MSGCLASS names:

       // D2PUNL0 JOB ACCNT#,CLASS=S,MSGCLASS=X,MSGLEVEL=(1,1),
       // TIME=1440,REGION=0M,NOTIFY=&SYSUID,LINES=9999
       //*TYPRUN=SCAN
       

    3. Enter an asterisk (*) before the TYPRUN parameter to comment out this command.

    4. Enter submit on the Command line and press Enter to submit the job.

       After each job is completed, verify that the return code is 0 (zero) to make sure that no errors occurred and that the job ran successfully.

       The Siebel DDL is now generated.

16. To generate the View DDL file, follow the instruction to edit the HLQ.SIEBEL.INST.EXEC data set described in Step 8.

17. Select 2 on the Install Main Menu screen to generate the View DDL.

18. Enter the DDL file name, for example, HLQ.SIEBEL.INST.DDLVIEW, to specify the DDL input data set, then press Enter.

19. Press Enter to generate a DDLVIEW SQL data set named HLQ.SIEBEL.INST.DDLVIEW.VIE.

20. Press F3 to exit after the job completes.

21. On the DSLIST screen, enter e before HLQ.SIEBEL.INST.DDLVIEW.VIE data set, and press Enter.

    Note: If you use a tool to create objects other than the DSNTEP2 tool, specify the program and plan names of the tool you are using in the SIEBSQLA member, for example:

    DSN SYSTEM(Q109) RUN PROGRAM(MYTEP2) PLAN(MYTEP2) PARMS(‘ /SQLTERM(/) ‘) END

22. In the HLQ.SIEBEL.INST.DDLVIEW.VIE data set, edit the VIEJCL member:

    1. Enter e at the start of the VIEJCL member, and press Enter.

    2. Edit job card parameters in each member, for example, specify the appropriate CLASS and MSGCLASS names:

       // D2PUNL0 JOB ACCNT#,CLASS=S,MSGCLASS=X,MSGLEVEL=(1,1),
       // TIME=1440,REGION=0M,NOTIFY=&SYSUID,LINES=9999
       //* TYPRUN=SCAN
       

    3. Enter an asterisk (*) before TYPRUN parameter to comment out this statement.

    4. Enter an asterisk (*) before GRANT statements; GRANT statements on views are not required with DB2 for z/OS. If you do not comment out these statements, error messages are returned when you run the VIEJCL member; you can ignore these messages.

    5. Enter submit on the Command line and press Enter to submit the job. Press Enter again.

       After each job is completed, verify that the return code is 0 (zero), to make sure that no errors occurred and that the job ran successfully.

23. Return to the midtier to continue the Siebel Schema installation by verifying the schema that you have just created.

    The schema.sql file is overwritten during the schema validation process. Therefore, if you would like to save the schema.sql file with the complete Siebel Schema DDL that was generated for the Siebel Schema, rename schema.sql (located in the DBSRVR_ROOT\db2390\dboutput\install directory on Windows or DBSRVR_ROOT/db2390/dboutput/install directory on UNIX) after you apply schema.sql on the mainframe.