Query the Exceptions Log System Tables

The rs_exceptshdr system table contains descriptive information about the transactions in the exceptions log, including:

• User-assigned transaction name

• Site and database where the transaction originated

• User at the origin site who submitted the transaction

• Information about the error that caused the transaction to be recorded in the exceptions log

To retrieve a list of the excepted transactions for a given database, use, for example, the following query:

select * from rs_exceptshdr
 where error_site = 'data_server'
 and error_db = 'database'
 order by log_time

To retrieve the source and output text for a transaction with a given system transaction ID, use:

select t.texttype, t.sequence,
 t.textval
 from rs_systext t, rs_exceptscmd e
 where e.sys_trans_id = sys_trans_id
and t.parentid = e.cmd_id
 order by e.src_cmd_line, e.output_cmd_index,
 t.sequence