Enabling File Activity Monitoring for the Sybase IQ Adapter

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.

1. 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.

2. 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.
3. 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).

4. You must run the script before the file activity report will begin collecting data.