Upgrade Guide for DB2 UDB for z/OS > Reviewing the Database Upgrade Log Files >

Viewing the Siebel Job Log Status

Upgrades: All upgrades.

Environments: Production test, production.

If you are using Siebel-scheduling to run your upgrade jobs, you can query the Siebel job log by completing the following procedure.

NOTE:  To view job status, you must have installed DSN REXX.

To view the Siebel job log status

1. If you are not on the Siebel Upgrade Main Menu, enter the following command:

   TSO SBLUPG78

2. Select option 6: JOB LOG - DISPLAY JOB STATUS (SIEBEL SCHEDULED MODE).

   The SIEBEL JOB LOG QUERY panel displays. The panel ID is SBLLOGP.

   A list of successful and failed jobs appears.

3. Next to the label LIST BY JOB TYPE/STATUS:, enter 2 or 9 for FAILED jobs. Enter option 1 to list the UNLOADS jobs.

   The list displays 250 lines only. The Unload, Load and Index Rebuild processes have more than 250 jobs, so you must query using another option or by specific or partial job name.

4. Press PF3 when you are finished viewing the log.

   The Siebel Upgrade Main Menu for your upgrade path appears.