Bookshelf Home | Contents | Index | PDF |
Siebel Database Upgrade Guide for DB2 for z/OS > Reviewing the Siebel Upgrade Log Files > Running SQL in Siebel LogsBy using SPUFI or the command line, you can construct SQL queries to run against the staging or the target log tables. The following statements report the status of the load jobs for the staging and target databases:
You can alter the preceding statements to report the status of any jobs by changing the JOB_NAME LIKE 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.
|
Siebel Database Upgrade Guide for DB2 for z/OS | Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |