To use the file activity report in SCC for Event Stream Processor, create a database
user and table in the database into which the Sybase IQ Output adapter is loading data.
- Run the $ESP_HOME/adapters/iqoutput/enableFileActivity.sql
script on your Sybase IQ database as a user with permissions to create a user, and
create tables for that user.
- The script adds a user called the RAP_USER, and a table owned by this user called
the RAP_WORK_FILE. It also grants the RAP_USER permission to perform client side
loads. This RAP_USER can be used as the user through which the Sybase IQ Output
adapter connects to the Sybase IQ database. If another user is used to connect the
adapter to Sybase IQ, that user must have read and write permissions on the
RAP_WORK_FILE table owned by RAP_USER. See the Sybase IQ documentation for further
details on these permissions.
- While the adapter is running, this table collects information about every file that
is created and loaded by the adapter. This allows the file activity report to
function as an archive for adapter activity.
- As a database administrator, you may wish to periodically remove information from
this table to prevent it from becoming unmanageable in size. Before removing
information, ensure that the adapter is not running. You may then delete rows from
the table using a standard SQL delete statement. If you remove rows that represent
files that were in the process of being written or loaded, an error displays in the
Event Stream Processor server logs on the next start of the adapter, and that file is
not tracked in the file activity report. Sybase recommends that you only delete rows
that represent files that were completed or in error (LOAD_STATUS column that has a
value of E or C respectively).
- You must run the script before the file activity report will begin collecting
data.