Viewing File Activity for the Sybase IQ Output Adapter

View the file activity report for the Sybase IQ Output Adapter from the Administration Console to see each file processed by the adapter and its current state.

Prerequisites

(Optional) Register the Sybase IQ server, to which the Sybase IQ Output adapter publishes data, with the same instance of SCC that you registered the node on.
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 a table for that user. For full information on the table and user you need to create, see Enabling File Activity Monitoring for the Sybase IQ Adapter in the Event Stream Processor Adapters Guide.
Log in using the espAdminRole role to be able to perform this task.
Enable the time-granularity option on the node in the Event Stream Processor project configuration (.ccr) file. See the Event Stream Processor Administrators Guide for information on the project configuration file.

Task

You can view all registered nodes or only a certain node from the Administration Console:
- To view all registered nodes, in the application menu, select View > Open > Administration Console.
- To view only a certain node, in the Perspective Resources view, select the node and select Resource > Administration Console.
In the left pane of the Administration Console, expand ESP Nodes and select Adapters.
In the right pane of the Administration Console, select the Sybase IQ Output adapter, click the arrow, and select File Activity.
A new window appears and displays the file activity report which contains details about each of the files processed by the adapter, including their current state.

By default, it displays records an hour ahead from the local time. If you want to display records from different periods of time, go to the Perspective Resources view menu, and select View > Filter.

If the Sybase IQ database cannot find the Sybase IQ database username and password from the SCC server, another window appears and asks for this information.