XDB-Parameters
- dominik.kurfner (Unlicensed)
- Reinhard Mayr (Unlicensed)
- Wolfgang Granzer
- Nahel Falhout (Unlicensed)
The following parameters are important for trending and metering data recording.
Name | Description | Scope | Unit | Default | Annotation |
|---|---|---|---|---|---|
XDB.DatabaseType | Sets the database type (MS SQL or MySQL (Maria DB)). | MySQL, MSSQL | None | MySQL | Â |
XDB.UserID | Username that is used to connect to the database. | String | None | sa | Â |
XDB.Password | Password that is used to connect to the database. | String | None | netxnetx_123456 | Â |
XDB.Hostname | The host name or IP address where the database is running. Use ".", "127.0.0.1", or "localhost" for connecting to the local machine. | String, IP-address | None | . | Â |
XDB.Database | Database name to use. If not set, the default database name "netx_ef_<workspace>" will be used. Following special characters are not allowed:Â ?*|"{}\'; | String | None | <empty> | since 4.1.2010 |
XDB.Port | Communication port of database. If not set, the port will not be provided in the connection string – otherwise, the specified port number will be used. | None, 1 – 65535 | None | None |  |
XDB.Instance | MS SQL Server only: Name of the used database instance. | String | None | NETX_SERVER_SQL | Â |
XDB.UseDefaultInstance | If enabled, the server connects to the default i.e. unnamed database instance of the MS SQL Server. | ON, OFF | None | OFF | Â |
XDB.ConnectionTimeout | Connection timeout in seconds. | 0 – 30 | s | 15 |  |
XDB.CommandTimeout | Command timeout in seconds. | 0 – 3600 | s | 60 |  |
XDB.LongCommandTimeout | Command timeout in seconds for long running commands like selecting trending values, auto purge or report generation. | 0 – 7200 | s | 300 |  |
XDB.AutoPurge | MS SQL Server Express Edition only (10 GB max. database size): If the database is more than 9 GB filled then the oldest trending data is deleted until the database size dropped below 8 GB. | ON, OFF | None | OFF | Â |
XDB.DeleteOldTrending | ON: The values of deleted trending definitions will be deleted from the database. OFF:Â The values of deleted trending definitions will be kept in the database, e.g. for future evaluation. | ON, OFF | None | ON | Â |
XDB.SkipMigration | BMS Platform R1 Build 2000 introduced a new SQL database schema. Since that version, the Core Server migrates from the old schema (database name NETX4_) to the new one (NETX_). Enable this option to disable this migration. | ON,OFF | None | OFF | Â |
Article applies to the following products:
NETx BMS Platform