db_status

db_version

string40

Y

N

Version of database: major.minor.build where major and minor affect DB schema and build may be used for SPs, etc. that do not affect DB schema.

mw_db_user

string40

N

N

Identify the database user_id used by the middleware. Needed to distinguish middleware from database tool users for audit trails. Default = "sa"

mes_service_host_pref

string254

N

Y

Identifies the host, using the fully qualified domain name, that is preferred to run the MES service/maintenance tasks.

Set in the post‑install Configurator when configuring the MES DB/MW Communication component.

mes_service_host

string254

N

Y

Identifies the host, using the fully qualified domain name, that is currently running the MES service/maintenance tasks.

host_tz_id

string80

N

Y

Identifies the time zone ID of the middleware host that is currently running the maintenance activities. For example, U.S. Pacific Standard Time.

def_tz_id

string80

N

N

Specifies the default time zone ID to use to run daily maintenance tasks when entities/times are not related to any site. Set in the post‑install Configurator when configuring the MES DB/MW Communication component.

service_last_ran

tdatetime2

N

Y

When the middleware last ran the daily maintenance tasks, in UTC

upgrade_history

string2000

N

N

List of MES database upgrades since the first MES installation, including the initial installation; entries, including the last one, are terminated by a semicolon (;) and a space

hotfix_history

string2000

N

Y

List of hotfixes applied on the current version of the database; entries, including the last one, are terminated by a semicolon (;) and a space

install_date_utc

tdatetime

N

N

The installation date and time (UTC) of the database.

wait_time

int32

N

Y

Number of minutes MES Service will wait to kill stale sessions. Default = 0

wait_time_before_takeover

int32

N

N

When the current middleware host stops processing the maintenance tasks, the amount of time to wait (in minutes) before switching the maintenance tasks to another middleware host. The default is 2 minutes.

regen_samples

logical

N

N

True if all samples need to be regenerated by MES Service; default = false

install_date_utc

tdatetime

N

N

Datetime (UTC) the database was installed.

spare1

string1700

N

Y

Spare field

spare2

string1700

N

Y

Spare field

spare3

string1700

N

Y

Spare field

spare4

string1700

N

Y

Spare field