IOServer
- Last UpdatedMar 10, 2025
- 2 minute read
Contains one row for each I/O Server providing data to the AVEVA Historian.
|
Column |
Data Type |
Description |
|---|---|---|
|
(PK) IOServerKey |
int NOT NULL |
The unique numerical identifier for the I/O Server. This value is automatically generated by the system when the I/O Server 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. |
|
(FK) IODriverKey |
int NULL |
The unique identifier for an IDAS. IODriverKey is a foreign key from the IODriver table. |
|
(FK) ApplicationName |
nvarchar(32) NULL |
The application name of the I/O Server. This name is usually the same as the executable file name. ApplicationName is a foreign key from the IOServerType table. |
|
Path |
nvarchar(255) NULL |
The full UNC path (including the filename) to locate the executable file for the I/O Server. If the I/O Server type key is specified, the filename may be omitted. |
|
ComputerName |
nvarchar(255) NULL |
The name of the computer on which the I/O Server runs. |
|
AltComputerName |
nvarchar(255) NULL |
The name of the computer on which an optional, failover I/O Server runs. The failover I/O Server must be running in order for the switch to be made. |
|
AutoStart |
bit NOT NULL |
Used to control how the I/O Server starts up. 0 = Automatic startup when the system starts. 1 = Manual startup required. Currently not used. |
|
ExeType |
int NOT NULL |
The type of executable for the I/O Server. Used by the Operations Control Management Console to determine how to start the I/O Server. 0 = Service; 1 = Console application; 2 = Windows application. |
|
InitializationStatus |
tinyint NOT NULL |
A control flag used to ensure that each I/O Server has been asked for the data type (integer or real) of each tag that it will send. Only needed after a database modification. |
|
ProtocolType |
tinyint NOT NULL |
The protocol used by the AVEVA Historian server to communicate with the I/O Server. 1 = DDE; 2 = SuiteLink™; 3 = AVEVA Historian named pipe driver (for compatibility with IndustrialSQL Server 3.0 and previous versions). Of the operating systems currently supported by the AVEVA Historian, DDE is only supported on the Windows XP operating system. |
|
Description |
nvarchar(50) NULL |
The description of the I/O Server. |
|
Status |
tinyint NULL |
Automatically updated by the system if a change is made to the I/O Server: 0 = No change; 1 = Insertion; 2 = Modification; 3 = Deletion. |