Enabling File Activity Monitoring for the SAP 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 SAP Sybase IQ Output adapter is loading data.

1. As a user with permissions to create a user, run the $ESP_HOME/adapters/iqoutput/enableFileActivity.sql script on your SAP Sybase IQ database and create tables for that user. You must run this script before the file activity report begins collecting data.

   The script adds a user called RAP_USER, and a table owned by this user called RAP_WORK_FILE. It also grants the RAP_USER permission to perform client-side loads. RAP_USER can be used as the user through which the SAP Sybase IQ Output adapter connects to the SAP Sybase IQ database. If another user connects the adapter to SAP Sybase IQ, that user must have read and write permissions on the RAP_WORK_FILE table owned by RAP_USER. See the SAP Sybase IQ documentation for further details on these permissions.

   While the adapter is running, RAP_WORK_FILE 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 want to periodically remove information from RAP_WORK_FILE 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 in the process of being written or loaded, an error is written in the Event Stream Processor server logs on the next start-up of the adapter, and that file is not tracked in the file activity report. SAP recommends that you only delete rows that represent files that were completed or in error (columns for which the LOAD_STATUS is C or E respectively).

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