Data point types and data points

The DBLogger uses the following internal data point types (DPT) and data points (DP):

_IS_Database

Contains the parameter settings for the DBs used. The DP name is identical to the DB name. If an ODBC database is used, the DB name is the DSN name.

DPE Type Description
.DbName string Name of the database (including extension, if there is one)
.DbPath string Path to the file database (empty for ODBC databases)
.DbType string

Possible types:

MS SQL Server, Oracle
.DbUser string User name, defined in the DB (suitable authorization permissions required)
.DbPassword string User password, defined in the DB
.DbAlivePeriod int Time interval in seconds at which the table DBL_Alive is updated (see the function DBL_UpdateAliveSession in DBL.ctc)
.DbCommitPeriod int Time interval in seconds after which a commit is immediately executed (see the function DBL_CommitPeriodical in DBL.ctc)
.DbCommitCount int Number of DB write errors after which a commit is immediately executed (see the function DBL_CommitPeriodical in DBL.ctc)
.DbCommitThreadNumber int Number of the thread in which the DBL_CommitPeriodical function was started
.DbCommitReset bit Reset periodic commit (see the function DBL_ConnectCommitReset in DBL.ctc)
.DbAliveThreadNumber int Number of the thread in which the DBL_UpdateAliveSession function was started
.DbAliveReset bool Reset Alive mechanism (see the function DBL_ConnectAliveReset in DBL.ctc)
.DbWritePassive bool Defines whether the passive host writes in a DB in redundant systems.

_IS_Table

Contains the parameter settings for the tables used. The DP name is created automatically from DB name + "_" + table name (defined during configuration).

DPE Type Description
.TableName string Name of the table
.TableType string Type of the table (only StandardHistory implemented at present)
.TableMaxLengthDpeName int Maximum length of the data point name / alias name in the table (Note: data points with longer names/aliases are not saved in the table).
.TableSystemNameDpe bit TRUE/FALSE: the DPE name/alias is saved with/without the system name in the table
.TableAlias bit TRUE/FALSE: the alias/DPE name is saved in the table
.TableOldDays int All data records older than the number of days given by TableOldDays are regularly deleted from the table (FIFO)
.TableFIFOThreadNumber int Thread number for FIFO
.TableFIFOAtHour int Time at which old data is deleted (FIFO)

_IS_ArchiveGroup

contains the parameter settings for the archive groups used. The DP name is created automatically from the text "DBL_ArchiveGroup_" and a serial number.

DPE Type Description
.AgName string Name of the archive group
.AgDbName string Name of the destination database (DB data point name)
.AgTableName string Name of the destination table in the database
.AgDescription langString user-definable multi-lingual description of the archive group
.AgTransfer structure
.Mode int

Transfer mode:

1 = periodical (Periodical)

2 = TriggerDP-controlled (Trigger)

3 = event-controlled (Event)
.Period int

in seconds, used only for periodic data transfer

Predefined periods:

3, 10, 15, 30 minutes,

1, 6, 8, 12 hours,

1 day, 1 month, 1 year
.SyncTime time used only for periodic data transfer: sync time for periodic data transfer
.TriggerDPE string used only with the Trigger transfer mode: when this DPE undergoes a change, its value is checked for validity, and if the condition is met then the data points defined in AgItems (see below) are transferred.
.TriggerConditionOperator string

used only with the Trigger transfer mode: relational operators for checking the trigger data point

Possible operators: <,<=,==,>,>=,!=,OnEvent
.TriggerConditionValue string used only with the Trigger transfer mode: comparison value for checking the trigger data point
.TriggerSourceTime int used only with the Trigger transfer mode: 1 = time of the trigger, 2 = time of the DPEs, 3 = most recent, 4 = oldest DPE time
.Delay int used only for the periodic transfer mode: transfer delay in seconds after the period time is reached
.TimedFuncDp string used only for the periodic transfer mode: Name of the DP of type _TimedFunc, used in the periodic transfer mode
.AgActive bit Status of the archive group (AG), true = active
.AgThreadNumber int Number of the start thread for the AG
.AgItems dyn_string List of the DPs used in the AG (to be written to the DB)
.AgStatistic structure
.Reset bit not implemented yet
.TransferCounter int not implemented yet
.Period int not implemented yet
.MaxCount int not implemented yet

_IS_TableType

contains the parameter settings for the user-defined tables used. The DP name for tables of table type FlexTables is created automatically from "DBL_" + table type name.

DPE Type Description
.TableFieldName dyn_string Name of each column in the table
.TableFieldLength dyn_int Field length of the columns
.TableFieldType dyn_string Field data type
.TableFieldOrigin dyn_string Type ==1: DPE + Config + Attribute, Type ==0: Config + Attribute
.TableFieldIndexType dyn_int Column indexed/not indexed
.Type int 0 = StandardHistory, 1 = FlexTables
.TableDataReadMode int only for type ==1 relevant (0 = dpGet, 1 = dpGetAsynch)

_IS_Control

used for enabling/disabling the archive groups (see the function DBL_ControlExitWorkFunction in DBL.ctc) and for stopping (restarting) the DBLogger archive groups (see the function DBL_ControlWorkFunction in DBL.ctc).

DPE Type Description
.AgName string Name of the archive group to be disabled/enabled
.AgActivate bool Switch for enabling/disabling the archive group specified in AgName
.ManType string for future use
.ManNum int for future use
.Exit int Switch for stopping (restarting) the DBLogger
.Error int for future use
.TableName string Name of the table for disabling/enabling FIFO
.TableFIFO bool Switch for disabling/enabling FIFO in the table
.ThreadTableName dyn_string List with thread names (for internal administration)
.ThreadNr dyn_int List with associated thread numbers (for internal administration)