Trace DB (Audit) Settings

The Variable Tracing is a Movicon functionality which allows you to historically log the behaviour of variables, by recording on Database files or text file each variable change and the cause changing the variable's value. This will enable you to keep track of the value changes that take place to variables and what were the causes. To modify the Real-Time DB Trace properties, select the object with the mouse and use the Movicon 'Properties Window'.

 

 

Use IMDB Manager

See paragraph "IMDB Settings for Recording data" in the section on "IMDB".

 

Shared Tables

See paragraph "IMDB Settings for Recording data" in the section on "IMDB".

 

Save XML File

See paragraph "IMDB Settings for Recording data" in the section on "IMDB".

 

Save CSV File

See paragraph  "IMDB Settings for Recording data" in the section on  "IMDB".

 

Crypt File

See paragraph "IMDB Settings for Recording data" in the section on "IMDB".

 

Write Behind Delay

See paragraph "IMDB Settings for Recording data" in the section on "IMDB".

 

Max Rows Nr.

See paragraph "IMDB Settings for Recording data" in the section on "IMDB".

 

Keep the DB Connection open

See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".

 

Max. Error Number

See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".

 

Max. Transactions

See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".

 

Max. Cache Size

See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".

 

Max. VarChar Precision

See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".

 

ODBC DSN

See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".

 

ODBC DSN User

See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".

 

Time Column

This setting is used for inserting the Trace Table's Time Column's name. If not specified the default's name will be used instead. The Time column indicates the recording's date and time referring to GMT.

 

Local Time Column

This setting is used for inserting the Trace Table' s Local Time Column's name. If not specified the default's name will be used instead. The Local Time column indicates the recording' s dates and Time referring to local time.

 

MSec Column

This setting is used for inserting the Trace Table's MSec Column's name. If not specified the default's name will be used instead. The MSec Column indicates the milliseconds relating to the recording time.

 

User Column

This setting is used for inserting the Trace Table's User Column's name. If not specified the default's name will be used instead. The User Column indicates the name of the active user when the recording took place.

 

Changer Column

This setting is used for inserting the name of the Trace Table's Changer Column's name. If not specified the default's name will be used instead. The Changer Column indicates by which event caused the variable's status change, eg. by a screen's object, by the communication driver, by the watch window, etc.

 

Value Before Column

This setting is used for inserting the Trace Table's Value Before Column's name. If not specified the default's name will be used instead. The Value Before Column indicates what the variable's value was before it was just last changed.

 

Value Next Column

This setting is used for inserting the Trace Table's Value Next Column's name. If not specified the default's name will be used instead. The Value Next Column indicates the variable's new value.

 

Value Column

This setting is used for inserting the Trace Table's Value Column's name. If not specified the default's name will be used instead. The Value column indicates the actual value that the variable was meant to be modified with. It may happen that the intended value is not always set exactly the same on the variable. The variable may undergo scaling or conversion which will therefore cause the inserted value to adapt. When this is the case the values reported in the 'Value Column' and the 'Value Next Column' tend to be different.

 

Quality Column

This setting is used for inserting the Trace Table's Quality Column's name. If not specified the default's name will be used instead. This column indicated the variable's quality status.

 

TimeStamp Column

This setting allows you to enter the name of the "TimeStamp" Column.  The default name will be used If no name is specified.  The TimeStamp Column indicated the variable's TimeStamp.

 

Variable Name Column

This setting allows you to enter the name of the "Variable Name" Column.  The default name will be used If no name is specified. The  "Variable Name" Column indicates the name of the variable when set to share the same trace table with other variables.

 

Variable Group Column

This setting allows you to enter the name of the "Variable Group" Column.  The default name will be used If no name is specified. The  "Variable Group" Column indicates the name of the group which the variable belongs to.

 

Variable Description Column

This setting allows you to enter the name of the "Variable Description" Column.  The default name will be used If no name is specified. The  "Variable Description" Column indicates the variable's description.

 

Recreate All

The command regenerates all the tables of the variables enabled with the Trace. All existing data will be lost.

 

 

See Also