This section describes how to newly construct a database of Systemwalker Desktop Keeper Log Analyzer Server.
Note
When constructing database, be aware of the following restrictions and notes
When migrating from Systemwalker Desktop Log Analyzer to Systemwalker Desktop Keeper V15.0.0 or later, data shall be transferred again. Before constructing database, refer to "Chapter 4 Upgrading".
Do not set compression or encryption settings for the drive and folder for constructing the database.
Exclude the folder for constructing the database from the targets of virus scan software.
Do not delete the Windows logon user (Log Analyzer user) who has constructed the database environment constructed. When deleting the database environment, migrating database environment and restoring management information and log data, the Windows logon user used when the database environment was constructed is required.
Confirm the maximum log size of the event viewer (application log) and the operation settings when the maximum is reached in advance, and confirm that the event logs can be recorded properly. Construction of the database will be interrupted if no event log is recorded.
Items to be confirmed before database construction
In the Log Analyzer Server, the following ports will be used for access to database:
No. 30004
If the above port numbers have been used, refer to "Port Number List" of Systemwalker Desktop Keeper Reference Manual before constructing the database, and change the environment of Systemwalker Desktop Keeper.
Standard of database construction time
The amount of time needed to construct the database will depend on the capacity of the database. The standard of creation time is as follows:
When database capacity is about 50GB, (Xeon 3.16GHz, memory 4GB and RAID1 structure)
Measured conditions
Number of clients: 250 sets
Number of file operation logs: 500 pieces
Number of non-file operation logs: 500 pieces
Number of months to save: 4 months
Database construction time: around 30 minutes
Note: Processing time is a reference value because changes will occur due to reasons such as the operation status of CPU, memory, disk performance and other applications of PC.
The steps to construct Systemwalker Desktop Keeper Log Analyzer Server database are as follows:
Log on as a Log Analyzer user (Windows account set at installation of Log Analyzer Server).
Select Systemwalker Desktop Keeper > Log Analyzer > Operating Environment Maintenance Wizard from the Start/Apps menu.
The "Welcome to Operating Environment Maintenance Wizard" window is displayed. Click the Next button.
Select processing window is displayed. Set Processing executed and click the Next button.
Item Name | Description |
|---|---|
Processing executed | Select the processing to be executed. Select "Construction of Operating Environment" here.
|
The Input database information window will be displayed.
Set Database saving target and Database estimation, and click Capacity calculation button.
Confirm Database capacity and Available disk capacity displayed in Capacity, and change Database saving target when Available disk capacity is insufficient. In addition, Database capacity can be added according to the needs. Set Database capacity directly.
After confirming Database saving target and Database estimation, click the Next button.
Item Name | Description | |
|---|---|---|
Database saving target | Enter the creation target of database. The initial value is "C:\DTK_LOGANALYZER\SFWD". When changing the creation target to be displayed, click the Browse button to change the folder. Up to 32 characters can be specified for the database storage folder name. Multi-byte characters such as space, some symbols (tab , ; # '), Hiragana, Katakana and Chinese characters cannot be specified. In addition, the following drives cannot be specified:
| |
Database estimation | Number of Clients (required) | Enter the number of CTs managed in this server within the range of 1-99999. |
Number of file operation logs (required) | Enter the number of file operation logs within the range of 1-99999. | |
Number of non-file operation logs (required) | Enter the number of non-file operation logs within the range of 1-99999. | |
Number of saving months (required) | Select the number of months to save between 1-12. | |
Capacity | Database capacity (required) | Set the items in Database estimation and display the estimated value when the Capacity calculation button is clicked. When disk capacity available for the database creation target is sufficient, and creation is made with the capacity expected to be larger than the estimated capacity, reset this item within the range of disk capacity available. |
Available disk capacity | The capacity available of the target disk of creation is displayed. | |
Note
About [Number of Months to Save]
The partition of the database is the specified number of months to save x 31 log saving spaces.
For example, if the number of months to save is 3, it is divided into 3*31=93 saving spaces.
Every time when data transfer command is started, data will be saved to saving space 1, saving space 2 and saving space 3, etc. However, after the saving space 93, it will return to saving space 1 and overwrite. Therefore, the old data of correspondent space will be deleted.
In addition, when the data saved by overwriting cannot be written into the existing saving space, several saving spaces after that might be deleted.
As mentioned above, in spite of circulated use of the saving space corresponding to Number of Months to Save, be aware that not only the oldest data in operation time, but the old data that has been transferred in the earliest will also be overwritten.
The Confirm the settings content window is displayed. Confirm if the content displayed in the window has mistakes, and click the Next button.
The Processing window is displayed, and database creation is started.
After the processing has completed normally, the Processing Completed window will be displayed. Click the Finish.
