IODriver

(PK) IODriverKey

int NOT NULL

The unique identifier for an IDAS. This value is automatically generated by the system when the IDAS is added.

(PK) (FK) StorageNodeKey

int NOT NULL

The unique numerical identifier for the storage node. StorageNodeKey is a foreign key from the StorageNode table.

ComputerName

nvarchar(255) NOT NULL

The name of the computer on which the IDAS runs.

AltComputerName

nvarchar(255) NULL

The name of the computer on which an optional, redundant IDAS runs. You must use the fully qualified name of the computer. You could also use the IP address. This should be set to an empty string if no redundant IDAS is specified. Make sure that the IDAS software is installed on the target failover computer. If the failure of the primary IDAS is detected by the system, the failover IDAS is automatically started. The failover IDAS is shut down after the primary IDAS is back online. By default, this column is an empty string.

StoreForwardMode

tinyint NOT NULL

Used to specify whether or not store-and-forward capability is enabled. If enabled, and the network connection between the IDAS and the storage node fails, data will be "buffered" to the location specified by the store-and-forward path. Valid values are: 0 = Disabled; 1 = Enabled; 2 = Autonomous. The Autonomous mode (2) is an extension of the normal store-and-forward mode (1). It allows the IDAS to start up using an IDAS configuration file and collect data in store-and-forward mode if the network connection to the AVEVA Historian is not available.

StoreForwardPath

nvarchar(255) NULL

Used to specify the path for the IDAS data buffer on the local hard drive of the IDAS computer. The path should be absolute (for example, c:\IDASBuffer). Data is written to this path until the minimum threshold for the buffer is reached. Remote buffer paths are not supported. When the store-and-forward path specified for the IDAS is invalid, the default path picked by the system is: <public folder>\ArchestrA\Historian\IDAS\SF where the <public folder> is dependent on the operating system. For example, for the Windows 2008 operating system, the path is C:\ProgramData\ArchestrA\Historian\IDAS\SF. When the store-and-forward path specified for the IDAS is just a folder name (without any path characters like \ and :), the default path picked by the system is: <Windows system path>\<folder name specified by the user>. For example, for the Windows Server 2008 32-bit operating system, the path is C:\WINDOWS\system32\<folder name>.

MinMBThreshold

int NOT NULL

The minimum amount of free disk space, in megabytes, at which IDAS stops collecting data in the store-and-forward buffer.

Status

tinyint NULL

Automatically updated by the system if a change is made to IDAS: 0 = No change; 1 = Insertion; 2 = Modification; 3 = Deletion.

Enabled

bit NOT NULL

Used to indicate whether the IDAS is enabled or not. 0 = Not enabled; 1 = enabled. Disabling the IDAS allows for the configuration to be retained in the database, even though the IDAS is removed from the system.

StoreForwardDuration

int NOT NULL

The minimum duration, in seconds, for the IDAS to function in store-and-forward mode. The IDAS functions in store-and-forward mode for this length of time even if the condition that caused IDAS to function in store-and-forward mode no longer exists. The maximum duration is 3600 seconds, and the minimum is 0 seconds.

AutonomousStartupTimeout

int NOT NULL

The amount of time, in seconds, that the autonomous IDAS should wait for configuration commands when started by the Configuration service before going to the autonomous mode. This timeout may need to be increased only if you have a large number of IDASs configured as autonomous on a slow network.

BufferCount

int NOT NULL

The number of 64 KB buffers pre-allocated for buffering data. This number may need to be increased to accommodate high data rates.

FileChunkSize

int NOT NULL

The size, in bytes, of the data "chunks" that are sent to the historian when store-and-forward data is forwarded. The size of the chunks can be decreased to accommodate slower networks. Decrease this number only if the forwarding delay is greater than zero.

ForwardingDelay

int NOT NULL

The time interval, in milliseconds, at which "chunks" of store-and-forward data are forwarded to the historian. The length of the interval may need to be increased to accommodate slower networks.

ConnectionTimeout

int NOT NULL

The amount of time, in seconds, that the Configuration service attempts to communicate with an IDAS for configuration/reconfiguration. If this timeout elapses, the Configuration service assumes that the IDAS connection has been dropped. This number may need to be increased to accommodate slower networks.