4.5.1 Database overview

JP1/IT Desktop Management has multiple database folders and data storage folders according to the type. The following provides details about the folders for each JP1/IT Desktop Management database.

Management server database and database server database

The location in which each folder will be created can be specified during setup of the management server in a single-server configuration system, or during setup of the management server or database server in a multi-server configuration system .

The following table lists and describes the folders.

Folder type	Description	Created?
Database folder^#1	A folder in which a database area is created for storing management information, including device information, asset information, security policies, events, and reports	Yes
Data folder	A folder that stores data, such as the registered agents and packages created by the distribution function	Yes
Data folder shared among servers^#1	A folder that stores environment information for the management server and database server	Yes
Local data folder^#1	A folder used as a management server temporary folder during operation	Yes
Operation log database folder	A folder in which the following two types of database areas are created to retain and reference operation logs collected from computers. Online area This area stores operation logs for about 30 days from the current day.^#2 The size of this area is automatically set according to the value that was specified for Total Managed Nodes during setup. Restoration area This area is used to restore operation logs from backup. Operation logs for a maximum of 500 days can be restored. The restored operation logs can also be deleted. The size of this area is automatically set according to the values that were specified for Total Managed Nodes and Maximum restore period for operation logs during setup.	C
Operation log backup folder	A folder for saving the automatically backed-up operation log data. When you restore operation logs in the operation window, the data in this folder is stored in the restoration area in the operation log database folder, which allows you to reference the operation logs from the past.	C
Revision history output folder	A folder to which revision histories are output periodically for archival purposes.	C
Database extraction folder^#1	A folder for temporarily saving data when the database folder is changed. This folder is not used during normal operation	Yes

Legend: Yes: Always created, C: Created depending on the setting

#1: In a multi-server configuration system, this folder is created on the database server.

#2: If the number of operation logs exceeds the value obtained by multiplying the number of managed computers by 30 (days) and then by 2,700 (logs), or if operation logs have been stored beyond 500 days, operation logs are deleted, beginning from those with the oldest dates.

Tip: Only the local disk on the management server can be specified for the folders. Note, however, that for the operation log backup folder, a network folder can be specified in addition to the local disk. Therefore, we recommend that you use large-capacity storage for the operation log backup folder and use a hard disk on the management server for other folders.

Important note: For the operation log backup folder, you can specify any network disk, except for a storage device that is recognized as a removable disk.

Site server database

The location in which each folder will be created can be set during setup of the site server.

The following table lists and describes the folders.

Folder type	Description	Created?
Database folder	A folder in which a database area for storing operation log management information is created	Yes
Data folder	A folder that stores data, such as the agents registered on the management server and packages created by the distribution function	Yes
Operation log data folder	A folder that stores operation logs collected from computers	Yes

Legend: Yes: Always created

Important note: The size of the site server database monotonically increases according to the volume of collected operation logs and created packages. If the hard drive free space becomes low, an event is displayed. If necessary, consider deleting data or adding a hard disk.

To Page Top