4.6.7 Analyzing periodic maintenance needs
We recommend that you perform the following maintenance during operation. Decide when maintenance should be performed.
-
Back up operation data
Back up operation data including the database and data files. If a disk error occurs, information on the management server might be lost or the management server might no longer operate.
Therefore, create a backup on a regular basis during operation. If an error occurs in the management server, you can use the backup to restore the state that existed when the backup was created.
-
Reorganize the database
Long term operation of the database might cause problems such as fragmented areas, degraded storage efficiency, and reduced access speed. To prevent such problems, a function that reorganizes the database is provided. By reorganizing the database, you can change the storage configuration without changing the data contents, thus providing more efficient performance.
As a standard, reorganize the database before the database space usage reaches 80%.
-
Back up operation logs stored in site servers
If operation logs acquired from computers with agents installed are stored in site servers, back up the acquired operation logs if necessary.
Decide when and at what interval you should back up operation data and reorganize the database. To create a backup or reorganize the database, you need to stop the management server. Therefore, when creating a schedule, choose a day of the week and time when the management server is not used.
You must also set up a schedule for backing up operation logs stored in site servers.
- Tip
-
We recommend that you create a backup or reorganize the database on a regular basis.
Use one of the following methods to perform maintenance on the management server.
-
Anytime you wish
You can manually perform maintenance anytime your wish by using the database manager or by executing a command.
-
Scheduled maintenance
Register the command as a Windows task, and then set a schedule to execute the command automatically.
To perform maintenance for site servers, you only have to back up operation log files manually. No other operations are required.
To perform maintenance by using the database manager:
-
From the Start menu on the management server, start the database manager.
-
In the dialog box that appears, select the menu item you want to execute.
-
Follow the instructions in the database manager window to perform maintenance.
Maintenance is completed.
To perform maintenance by using commands:
-
Use the stopservice command to stop the management server.
-
Perform maintenance.
-
To back up operation data:
Use the exportdb command to create a backup.
-
To reorganize the database:
Use the reorgdb command to reorganize the database.
-
-
Use the startservice command to start the management server.
Maintenance is completed.
- Important note
-
If the management server is in a cluster configuration, use the cluster software function to start and stop cluster resources on the management server.
If the management server is not in a cluster configuration, you can also use the exportdb or reorgdb command with the -a option specified to perform maintenance. In this case, perform only step 2 above. Steps 1 and 3 are automatically performed.
- Tip
-
If an error occurs on the management server, you can restore the data by using the importdb command with the backup data specified as an argument. You can also back up, restore, and reorganize the database by using the database manager.