2.19 Managing the database
JP1/IT Desktop Management stores various kinds of information managed by JP1/IT Desktop Management in a special database created on the management server or a database 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.
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 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 setup to upgrade or initialize the database, and to change the storage folder.
Note that the database manager cannot maintain databases on site servers. If necessary, make backups by manually copying the operation logs on site servers.
- Organization of this section