2.20 Managing the database
JP1/IT Desktop Management 2 stores various kinds of information managed by JP1/IT Desktop Management 2 in a special database created on the management server.
You must regularly maintain the database by creating a backup in preparation for problems or by re-organizing it to increase performance.
To maintain the database, use the database manager provided by JP1/IT Desktop Management 2.
The following are the database manager functions:
- Backup
-
This function creates a backup of the database. If a disk failure should occur, information in the database might be erased or corrupted. Therefore, regularly make backups when the database is operating.
You can also back up the database by executing the exportdb command.
- Restore
-
This function restores the database from a backup created by the backup function or by the exportdb command. If an error occurs in the database, you can use the backup to restore the database to the status as of the backup.
You can also restore the database by executing the importdb command.
- Reorganize
-
Fragmentation of database area might occur if the database has been used for a long time. This might cause problems, such as slowdown of access speed. To prevent such problems, JP1/IT Desktop Management 2 can reorganize the database. Reorganizing the database can be done while the data remains stored, and can help to make performance more efficient. We recommend that you reorganize the database before the usage rate of the database reaches 80%. You can check the usage rate of the database in the database manager.
You can also reorganize the database by executing the reorgdb command.
In addition, you can use the JP1/IT Desktop Management 2 setup to upgrade or initialize the database, and to change the storage folder.
The following table describes the environments in which backed up data can be restored.
|
Environment in which the backup is created |
Environment in which the data is to be restored |
|||
|---|---|---|---|---|
|
Management server in a single-server configuration |
Multi-server configuration |
|||
|
Primary management server |
Management relay server |
|||
|
Management server in a single-server configuration |
Y |
Y |
Y |
|
|
Multi-server configuration |
Primary management server |
-- |
Y |
Y |
|
Management relay server |
-- |
-- |
Y |
|
Legend: Y: Can be restored. --: Cannot be restored.
If you want to restore backup data to a different environment, for example when you restore a backup of the primary management server to a management relay server, you need to change the settings of the management server. For details, see a description on how to integrate multiple multi-server-configuration systems in the JP1/IT Desktop Management 2 Configuration Guide.
- Organization of this section