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

Running SQL in Siebel Logs

Upgrades: All upgrades.

Environments: Development (mainframe-centric) environment and Production environment.

This topic is part of an upgrade process. See How to Perform the Upgrade.

By using SPUFI or the command line, you can construct SQL queries to run against the source or the target log tables.

The following statements report the status of the load jobs for the source or target databases:

• SELECT JOB_DESC, JOB_NAME, JOB_STATUS FROM CQ10A901.TMP_SBLLOG_SRC WHERE JOB_NAME LIKE 'LKC%';
• SELECT JOB_DESC, JOB_NAME, JOB_STATUS FROM CQ10A901.TMP_SBLLOG_TAR WHERE JOB_NAME LIKE 'LKC%';

You can alter the preceding statements to report the status of any jobs by changing the LIKE JOB_NAME statement to another prefix.

This following statement checks for failed unload jobs, but can check for any other job by changing the JOB_NAME LIKE statement to use the appropriate prefix.

SELECT JOB_DESC, JOB_NAME, JOB_STATUS FROM CQ10K034.TMP_SBLLOG_SRC WHERE JOB_STATUS != 'COMPLETED SUCCESSFUL' AND JOB_NAME LIKE 'LKB%';