XDB-Parameters

Owned by dominik.kurfner (Unlicensed)
Last updated: Sept 19, 2022 by Reinhard Mayr (Unlicensed)
2 min read

The following parameters are important for trending and metering data recording.

Name

Description

Scope

Unit

Default

Annotation

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