Go to documentation repository
Page History
The figure below shows the idb.exe dialog box.
The table describes the interface elements of the idb.exe utility dialog box.
№ | Element name | Description | Default value | Allowed values | |||||
1 | The Select data source database drop-down list | The A drop-down list for selecting the database: local , events log Configuration database, Event protocol database, or a remote .database for synchronization | Basic data | Basic data – local configuration Configuration database Synchro source – remote database for synchronization Protocol – Event protocol database Titles – Captions – events log database Other values are used when working with vertical solutions. | |||||
2 | The Description field | An The information field showing that displays the description of the selected source database. | Base for a configuration system Axxon PSIM | Base for a configuration system Axxon PSIM – Main configuration database of the Axxon PSIM system Remote database for synchronization Events log database Other values are not used. | data source from the Select data source drop-down list | Axxon PSIM main database | "Axxon PSIM" main database – local Configuration database Synchro source – remote database for synchronization "Axxon PSIM" system's external protocols database –Event protocol database Titles database – Captions database Other values depend on the availability of the databases for the installed vertical solutions. | ||
3 | The Use checkbox | The checkbox for enabling or disabling the selected database usage. When set, the Configure button becomes active, | 3 | Use | A checkbox for enabling/disabling database usage. When checked, the Build button becomes enabled which is used for setting up the connection to the database. | Checked | Checked – database is connected Unchecked Clear – database is not connected | ||
4 | The Move database button | The button used to transfer MS SQL Server database files (.mdf and .ldf) to the specified folder. The user must should have the rights to create files in this folder. When the files are moved, the database is automatically attached. Note. It is possible to transfer move only the local DB (Basic data data source). When using a remote DB (Synchro sourse source data source), files can not be moved. | EnabledActive | Enabled Active – the idb.exe utility is connected to an the MS SQL format database Disabled Inactive – the idb.exe utility is not connected to an the MS SQL format database | |||||
5Build | The Configure button | A The button for opening opens the Data Link Properties dialog box for to configure the database connection setup. This button is enabled active if the Use checkbox is checked.set | EnabledActive | Enabled Active – the idb.exe utility is connected to the database Disabled Inactive – the idb.exe utility is not connected to the database | |||||
6 | The Connection string information field | An The information field showing displaying the summary about the database connection parameters | Depends on the database connection parameters and , the server /workstation configurationconfiguration or Remote Administrator's workplace configuration | Displays the combination of Shows the following parameters: Provider, Integrated Security, Persist Security Info, Data Source. The Provider parameter can take the following values:
other Other values are not used. The Integrated Security parameter can take the following values:
The Persist Security Info parameter can take the following values:
The Data Source parameter can take the following values:
| |||||
7 | Information field and the Select . dbi-file button | An The information field and a the button for selecting and displaying a the database structure file ( .dbi )file. The updated database will have the structure specified in this file. | C:\Program Files\Axxon PSIM\psim.dbi | Full pathname of The full path to the .dbi file | |||||
8 | Select .ddi file | Information field and the Select dbi-file button | The An information field and a the button for selecting and displaying the name of information about the .ddi file with system objects, events and actions.reactions | C:\Program Files\Axxon PSIM\Languages\en\Axxon PSIM.ddi | Full pathname of The full path to the .ddi dbi file | ||||
9 | Convert MS Access to MS SQL database | A button for starting the conversion of an MS Access database to MS SQL format. This button is enabled if the utility is connected to an MS Access database. | Disabled | Enabled – idb.exe utility is connected to an MS SQL database Disabled – idb.exe utility is not connected to an MS Access database | 10 | The Create backup copy (MS SQL) button | A The button for starting the process of creating a backup copy of the database. This button is enabled active if the idb.exe utility is connected to an the MS SQL format database. | EnabledActive | Enabled Active – the idb.exe utility is connected to an the MS SQL format database Disabled Inactive – the idb.exe utility is not connected to an the MS SQL format database |
1110 | The Restore from backup (MS SQL) button | A The button for restoring the database from a previously created backup. | EnabledActive | Enabled Active – the idb.exe utility is connected to an the MS SQL format database Disabled Inactive – the idb.exe utility is not connected to an the MS SQL format database | |||||
| 1211 | The Clear protocols checkbox | A The checkbox excluding that excludes the Event protocol log database while creating from the created database backup copy. It is recommended to set this checkbox if the size of the Event protocol log database is too large, and there is no need to include the Event protocol log in a the backup copy. The setting is available only for the Axxon PSIM Intellect base database. | No | Yes Checked – the database backup copy does not include the Event protocol log database. No Clear – the database backup copy includes the Event protocol log database. | |||||
1312 | The Update database button | A The button for starting the process of updating the database structure. The structure is updated according to the .dbi file specified in the Select . dbi File -file field. | EnabledActive | Enabled Active – the idb.exe utility is connected to the configuration Configuration database Disabled Inactive – the idb.exe utility is not connected to the configuration Configuration database | |||||
1413 | The Create dbi-file button | A The button for creating a database structure .dbi file (.dbi template). | EnabledActive | Enabled – Active – .dbi file creation is allowed. | |||||
1514 | The Protocol information table | An information area displaying The information table that displays the progress of database processing: converting, structure updating, creating backup copy, etc. | Empty | An information area displaying Information messages about the progress of the database processing. A The blue “i” marks the notifications about successful completion of each processing step.icon indicates that the processing step has been successfully completed The A red “!” marks the notifications about icon indicates the errors in a the processing step. A blue tick marks icon indicates the completion of the processing. | |||||
1615 | The OK button | A The button for saving the database connection parameters and shutting - down the idb.exe utility. | EnabledActive | Enabled Active – saving database connection parameters and shutting - down the idb.exe utility is allowed. Disabled Inactive – the utility is still processing the database. |
Overview
Content Tools