This section describes how to create a new database for a Systemwalker Desktop Keeper Management Server/Master Management Server.
Database includes the operation database for saving operation information (management information and operation log information) and the log viewing database for migrating and viewing the previous operation logs.
The operation database is required. If the Management Server or Master Management Server is newly installed, the database will be constructed automatically. Construct the log viewing database according to need.
When the database information used in the old version is used directly in V15.1.0, refer to "Chapter 4 Upgrading". However, you need to delete V15.0.0 or earlier databases.
When constructing the database during installation of the Management Server or Master Management Server, automatic backup and deletion will be configured for the data stored in the database. Refer to "3.1.2.2 Automatic Data Backup and Deletion" for details on changing the configuration.
In addition, in order to prevent database insufficiency, perform notification setting when the database space is insufficient. For notification settings when database is insufficient, refer to "2.3.6.8 Set Administrator Notification". If depletion of database space is reported, reconstruct the database immediately. Refer to "Reconstruct Database of Management Server" in the Systemwalker Desktop Keeper User's Guide for Administrator for details.
Note
If depletion of database space is reported, space is not secured until the database is reconstructed, so the notification continues to be output. Lower the notification threshold value or immediately reconstruct the database.
Note
When constructing database, there are following restrictions and notes
Do not set compression or encryption for the drive and the folder to construct database.
Exclude the folder to construct database from the target of virus scan software.
For the logon user name of Windows, specify alphanumeric characters beginning with a letter and with no more than 18 characters, with the Administrator authority.
Confirm the maximum log size of event viewer (application log) and the settings of operation when the maximum is reached in advance so that the new event log can be recorded without any problems. Database construction may be interrupted if no event log is recorded.
Items to be confirmed before database construction
Use the following ports to access database in Management Server/Master Management Server:
Operation database: 42050
If the above-mentioned port number has been used, before constructing the operation database, refer to the "Port Number List" in the Systemwalker Desktop Keeper Reference Manual to change the environment of Systemwalker Desktop Keeper.
Log viewing database: 42051
When the above-mentioned port number has been used, before constructing the log viewing database, refer to the "Port Number List" in the Systemwalker Desktop Keeper Reference Manual to change the environment of Systemwalker Desktop Keeper.
DB construction time: 1 min.
Note: More time may be consumed depending on server performance and RAID structure.
Construct operation database
If the Management Server or Master Management Server is newly installed, the operation database will be constructed automatically. Follow the procedure below to construct the operation database manually:
Log in to Windows with the user that belongs to the Administrators group or the user that belongs to the Domain Admins group. When other application is being used, close it.
Refer to the notes mentioned above for existence condition of user name.
Select Start > Systemwalker Desktop Keeper > Server > Server settings tool or Apps > Systemwalker Desktop Keeper > Server > Server settings tool.
Log on using the primary administrator account:
User ID: secureadmin
Password: Specify the initial value "secureadmin", or the password modified after installation of Management Server or Master Management Server
In the Server Settings Tool menu, click Build, delete, or show information of database.
The Build, delete, or show information of database window will be displayed.
Item Name | Description |
|---|---|
Database creation folder | Database creation folder. The initial value is "C:\DTK\OPEDB". To change the value, click Browse and select the desired folder. Specify the database creation folder name using up to 96 halfwidth characters. You cannot specify the following drives:
The folder name cannot contain the following characters:
|
Database usage | Usage of the created database. If the database has not been built, this item will be blank. |
Disk availability | Available space on the creation destination disk. |
Click Construct.
The confirmation message is displayed. Click OK.
Creation of the database will start.
When the process is completed normally, the process completion message will be displayed. Click OK.
The Automatic Backup Settings window is displayed.
Target | Backup window | |
|---|---|---|
Automatic backup/deletion | To set up if carrying out automatic backup or deletion or not:
Initial setting: Execute | |
Automatic backup/deletion settings | To perform setting of automatic backup and deletion. | |
Task name | It is the task name registered in task scheduler. Fixed value (DTK_Auto_Backup_Command). | |
Backup target folder | Specify a folder for saving data during automatic backup. It can be specified as follows:
Specify up to 189 bytes (can be a combination of fullwidth and halfwidth characters and symbols). The folder name cannot contain the following symbols: \ / : * ? " < > | The backup management information is stored in the subfolder MSyyyyMmDd of the specified folder (yyyyMmDd indicates the backup execution date). If multiple backups are executed to the same folder on the same date, a unique sequential number enclosed by parentheses will be appended to the subfolder name. The first backup will be saved in MSyyyymmdd, the second one in MSyyyymmdd(1), the third one in MSyyyymmdd(2), and so on. Initial value: Folder specified during installation | |
Schedule Type | Set the interval of automatic backup and deletion:
Initial value: day | |
Execution week | When Week is selected in Schedule Type , select a day of the week for execution. Monday - Sunday can be selected. Initial setting: Monday | |
Execution date | When Month is selected in Schedule Type , enter the date for execution. 1-31 can be entered. Initial value: 1 | |
Execution start time | The time for executing automatic backup and deletion can be set. 00:00-23:59 can be specified. Initial value: 0:0 | |
Saving date | Duration for operation log saved can be set.
If Day is selected in Schedule Type , only Day can be selected. If Week is selected in Schedule Type , Day and Week can be selected. If Month is selected in Schedule Type , Day and Month can be selected. Initial value:
Operation log data outside the specified period will be deleted. Example: When a period of 30 days is specified, operation log data for the 31st and later days will be deleted | |
Refer to "3.1.2.2 Automatic Data Backup and Deletion" for details on each item and changing the settings.
Select Automatic backup/deletion > Execute, and then click Set.
Note
Data that was automatically backed up will not be deleted automatically, and if left as is, the backup drive space may become depleted. Therefore, you should periodically delete (move) data.
The message "[BKCI-INF001] The schedule of automatic backup has been set." will be displayed. Click OK.
Alternatively, select Automatic backup/deletion > Do not execute, and then click Set.
The message "[BKCI-INF002] The schedule of automatic backup has been canceled." will be displayed. Click OK.
Note
When a date after the 29th is specified in the Execution date, a message will be displayed to indicate that the command will not be executed for months in which the specified date does not exist.
According to the execution month, if the specified date does not exist, automatic backup and deletion cannot be conducted. In order to guarantee that the operation can be performed every month, specify the date to be before the 28th.
Note
About the time spent for automatic backup and deletion
Automatic backup and deletion will backup management information, log information in Log Viewer format and log information, and delete log information, therefore automatic backup and deletion may take some time.
Create log viewing database
The following describes how to construct a log viewing database. In addition, the log viewing database requires the construction of an operation database.
Log in to Windows with a user that belongs to the Administrators group or a user that belongs to the Domain Admins group. When other applications are being used, close them.
Refer to the attentions mentioned above for the existence condition of the user name.
Select Start > Systemwalker Desktop Keeper > Server > Server settings tool or Apps > Systemwalker Desktop Keeper > Server > Server settings tool.
Log on using the primary administrator account:
User ID: secureadmin
Password: Specify the initial value "secureadmin", or the password modified after installation of Management Server or Master Management Server
In the Server Settings Tool menu, click Build, delete, or show information of database.
The Build, delete, or show information of database window will be displayed.
Item Name | Description |
|---|---|
Database creation folder | Database creation destination folder. The initial value is "C:\DTK\REFDB". When changing the displayed creation target, click the View button to change the folder. The number of characters in the file name of the database creation target can be specified to be no more than 96 halfwidth characters. You cannot specify the following drives:
The folder name cannot contain the following characters:
|
Database usage | Usage of the created database. If the database has not been built, this item will be blank. |
Disk availability | Available space on the creation destination disk. |
Click Construct.
The confirmation message is displayed. Click OK.
Creation of the database will start.
When the process is completed normally, the process completion message will be displayed. Click OK.
Building an iOS Management Database
To manage iOS devices, an iOS management database must be constructed. Follow the procedure below to create an iOS management database:
Log on to Windows as a user that belongs to the Administrators group or Domain Admins group. If other applications are being used, then they must be closed.
Refer to the notes above for details on conditions that apply for user names.
Select Start > Systemwalker Desktop Keeper > Server > Server settings tool or Apps > Systemwalker Desktop Keeper > Server > Server settings tool.
Log on using the primary administrator account:
User ID: secureadmin
Password: Specify the initial value "secureadmin", or the password modified after installation of Management Server or Master Management Server
In the Server Settings Tool menu, click Build, delete, or show information of database.
The Build, delete, or show information of database window will be displayed.
Item Name | Description |
|---|---|
Database creation folder | Database creation folder. The initial value is "C:\DTK\MDMDB". To change the value, click Browse and select the desired folder. Specify the database creation folder name using up to 96 halfwidth characters. You cannot specify the following drives:
The folder name cannot contain the following characters:
|
Database usage | Usage of the created database. If the database has not been built, this item will be blank. |
Disk availability | Available space on the creation destination disk. |
Click Construct.
The confirmation message is displayed. Click OK.
Creation of the database will start.
When the process is completed normally, the process completion message will be displayed. Click OK.
The port in which the iOS management database waits will be set with the initial value (55432). If this value needs to be modified, refer to "How to Modify the Port Number" in the Systemwalker Desktop Keeper Reference Manual.
Note
If managing iOS devices in both Systemwalker Desktop Patrol and Systemwalker Desktop Keeper, an iOS management database must be constructed for both products.
If the operating system is to be restarted after an iOS management database is constructed, the PostgreSQL_swdtmdm service must be stopped first. Open the Windows Services window, select the PostgreSQL_swdtmdm service, and click Action > Stop.
If the operating system is restarted before stopping the service, the following message may be output to the event log
ERROR: canceling statement due to user request
This is a message displayed when the operating system stops the service, and does not cause any problem to the operation.
