If the SCADA node running iFIX ODBC loses a connection to the relational database, every INSERT, UPDATE, and DELETE command that is enabled for backup is automatically sent to either a primary or secondary back-up file.
In situations where the server connection is lost for long periods of time, iFIX ODBC backs up data until the:
- Primary and secondary back-up paths (disks) are full.
- Connection to the server is re-established.
- SQL task is stopped by an operator.
IMPORTANT: iFIX ODBC does not back up a SELECT command's request because there is no means of accurately determining when the connection to the server can be re-established. Since the SELECT command writes values to the process database, the process of selecting must be performed on a controlled and predictable basis (not whenever the connection is re-established).
