Configuring the Alarm ODBC Service
To configure
the Alarm ODBC Service:
- In Classic view, from the iFIX WorkSpace, click the System Configuration Utility button on the toolbar.
-Or-
In Ribbon view, on the Applications tab, in the System & Security group, click SCU.
- On the SCU toolbox, click the Alarms button.
- Double-click the Alarm ODBC Service.
- Click the Configure button.
- Enter the SQL login information required to connect to your relational database. If you want to use the existing SQL configuration, select the Use Login Information from SQL Configuration check box.
- Configure the column and table names for the relational database. If you want to use your own column and table names, enter them instead.
- Select the Allow Operator to Pause Alarm Logging check box to let operators temporarily stop writing to the relational database.
- In the Update Interval field, enter the number of seconds the service should wait between writes to the relational database. At each write, the service will check the iFIX AlarmQueue and the Lost Connection File.
- In the AlarmQueue Size field, enter the maximum number of records in the iFIX AlarmQueue.
- In the Number of records to log from iFIX field, enter the number of records to write to the relational database at one time from the iFIX AlarmQueue.
- In the Number of records to log from Backup File field, enter the number of records to write to the relational database at one time from the Lost Connection File.
- In the Lost Connection Options section, enter the path where you want to save your backup file and the tag that will indicate a broken connection with the relational database. Alternatively, instead of entering a tag here, you can create an Alarm ODBC watch dog using the Scheduler. For more information, refer to the Creating an Alarm ODBC Watchdog Using the Scheduler section.
- In the User Fields section, edit the ASCII format database blocks for any user defined iFIX field names you selected.
- Click OK.
