2.7.1 Intelligent Integrated Management Database

In JP1/IM - Manager, if you set up your own database of JP1/IM - Manager, you can centrally manage various information handled by the Intelligent Integrated Management Base in the database. The management DB of various information built on PostgreSQL is collectively called "Intelligent Integrated Management Database".

Organization of this subsection

(1) Configuration
(2) Install and uninstall
(3) functions
(4) About encrypted communication

(1) Configuration

(a) Database configuration

In JP1/IM - Manager, you can manage the data used by various functions by constructing management DB of information as following: to Intelligent Integrated Management Database.

Trend data Management Database

Manages performance data and alert information for monitored systems as time-series data (trend data). Browse through dashboards and trend data display function.
Integrated agent host Administration Database

Manage information to JP1/IM - Manager cooperates with agent, such as integrated agent host or your own OSS.
Response Action results management database

Manages the outcome of executions and control information of auto response Action, manual response Action, and definition file manipulation functions.
Dashboard Management Database

Manages information for displaying dashboard.

In addition, operation commands for building and maintaining the intelligent integrated management database are also included.

The definition of the assumptions (objects such as database clusters and roles) of the trend data management DB where trend data is stored is automatically created when you run the setup command for the intelligent integrated management database. In addition, schemas and tables are created automatically when trend data records are written.

Records of trend data are always written and read from the trend data management DB via the Intelligent Integrated Management Base. To write records, JP1/IM - Manager trend data writing API is used. To read records, use the time-series data acquisition method (__timeSeriesDataGet method) of trend information acquisition implemented by the product plug-in.

The configuration of the database when trend data is managed by the intelligent integrated management database (trend data management DB) is shown below.

Figure 2‒12: Configuring the Intelligent Integrated Management Database (Trend Data Management DB)

(b) Database authentication and access control

The PostgreSQL embedded in JP1/IM - Manager uses the following two roles:

Superuser role (postgres)

This role is used for database operation commands such as setup and maintenance.
General role (imuser)

This role is used for write and read functions to the database.

The password for the above role cannot be changed. Also, direct access to PostgreSQL is not possible.

(c) Settings Files

The configuration file for using the Intelligent Integrated Management database is shown below.

Intelligent Integrated Management Database Setup Information File (jimgndbsetupinfo.conf) and model files

A file that describes the definitions that are required during the setup of the Intelligent Integrated Management database.
Cluster environment intelligent integrated management database setup information file (jimgndbclustersetupinfo.conf) and model file

This file describes the definitions required when setting up a clustered environment for the Intelligent Integrated Management database

This file describes the definitions required when setting up a clustered environment for the Intelligent Integrated Management database.
PostgreSQL configuration file (postgresql.conf)

A file that describes parameter definitions for the Intelligent Integrated Management database.

For details about each file, see the description of the corresponding file in Chapter 2 Definition Files in the JP1/Integrated Management 3 - Manager Command, Definition File and API Reference.

(d) Where related files are stored

The location of files related to the Intelligent Integrated Management database is shown below.

■ Storage destination of the executable file of the Intelligent Integrated Management Database

Store executables, commands, and Trend Data Management Service executables used by the Intelligent Integrated Management Database in the following locations:

Operating environment	Storage destination
Physical host	Created when the Intelligent Integrated Management Database is set up. A directory named "`imgndbbin`" will be created directly under the path set in the item "`IMGNDBENVDIR`" in the intelligent integrated management database <Storage destination directory> Default For Windows: `manager-path\dbms\imgndbbin` For Linux: `/var/opt/jp1imm/dbms/imgndbbin` When a path is specified For Windows: `configuration-path\imgndbbin` For Linux: `configuration-path/imgndbbin`
Logical host	Created when the Intelligent Integrated Management Database is set up. It is created with the directory name "`imgndbbinlogical-host-number`" directly under the path set in the item "`IMGNDBENVDIR`" of the cluster environment intelligent integrated management database setup information file (`jimgndbclustersetupinfo.conf`). <Storage destination directory> Default For Windows: `manager-path\dbms\imgndbbinlogical-host-number` For Linux: `/var/opt/jp1imm/dbms/imgndbbinlogical-host-number` When a path is specified For Windows: `configuration-path\imgndbbinlogical-host-number` For Linux: `configuration-path/imgndbbinlogical-host-number`

Operating environment

Storage destination

Physical host

Created when the Intelligent Integrated Management Database is set up.

A directory named "imgndbbin" will be created directly under the path set in the item "IMGNDBENVDIR" in the intelligent integrated management database

Default

For Windows: manager-path\dbms\imgndbbin

For Linux: /var/opt/jp1imm/dbms/imgndbbin
When a path is specified

For Windows: configuration-path\imgndbbin

For Linux: configuration-path/imgndbbin

Logical host

Created when the Intelligent Integrated Management Database is set up.

It is created with the directory name "imgndbbinlogical-host-number" directly under the path set in the item "IMGNDBENVDIR" of the cluster environment intelligent integrated management database setup information file (jimgndbclustersetupinfo.conf).

Default

For Windows: manager-path\dbms\imgndbbinlogical-host-number

For Linux: /var/opt/jp1imm/dbms/imgndbbinlogical-host-number
When a path is specified

For Windows: configuration-path\imgndbbinlogical-host-number

For Linux: configuration-path/imgndbbinlogical-host-number

■ Storage destination for data files of Intelligent Integrated Management Database

Store the Intelligent Integrated Management Database data files (equivalent to PostgreSQL database clusters) in the following location:

Log files of the Intelligent Integrated Management Database are also stored in the "log" directory where they are stored.

Operating environment	Storage destination
Physical host	Created during the setup of the Intelligent Integrated Management database. It is created with the directory name "`imgndb`" directly under the path set in item "`IMGNDBDIR`" in the Intelligent Integrated Management Database Setup Information File (`jimgndbsetupinfo.conf`). <Storage destination directory> Default For Windows: `manager-path\database\imgndb` For Linux: `/var/opt/jp1imm/database/imgndb` When a path is specified For Windows: `configuration-path`\im`gndb` For Linux: `configuration-path/imgndb`
Logical host	Created during the setup of the Intelligent Integrated Management database. It is created with the directory name "`imgndblogical-host-number`" directly under the path set in item "`SHAREGNDBDIR`" in the cluster environment intelligent integrated management database setup information file (`jimgndbclustersetupinfo.conf`). <Storage destination directory> For Windows: `specified-path-of-shared-disk\imgndblogical-host-number` For Linux: `specified-path-of-shared-disk/imgndblogical-host-number`

Operating environment

Storage destination

Physical host

Created during the setup of the Intelligent Integrated Management database.

It is created with the directory name "imgndb" directly under the path set in item "IMGNDBDIR" in the Intelligent Integrated Management Database Setup Information File (jimgndbsetupinfo.conf).

Default

For Windows: manager-path\database\imgndb

For Linux: /var/opt/jp1imm/database/imgndb
When a path is specified

For Windows: configuration-path\imgndb

For Linux: configuration-path/imgndb

Logical host

Created during the setup of the Intelligent Integrated Management database.

It is created with the directory name "imgndblogical-host-number" directly under the path set in item "SHAREGNDBDIR" in the cluster environment intelligent integrated management database setup information file (jimgndbclustersetupinfo.conf).

For Windows: specified-path-of-shared-disk\imgndblogical-host-number

For Linux: specified-path-of-shared-disk/imgndblogical-host-number

■ Storage destination of Intelligent Integrated Management Database's associated library (for Linux only)

In the Linux version, the message catalog used in the operation command of the Intelligent Integrated Management Database and the library used in the Intelligent Integrated Management Database are stored in the following locations.

Operating environment	Storage to
Physical and logical hosts (common)	It is created during installation. <Storage destination directory> `/opt/jp1imm/lib/imgndb`

Operating environment

Storage to

Physical and logical hosts (common)

It is created during installation.

/opt/jp1imm/lib/imgndb

■ Storage destination of the setting file of Intelligent Integrated Management Database

Store the settings file of the intelligent integrated management database in the following location.:

Operating environment	Storage to
Physical host	It is created during installation. <Storage destination directory> For Windows: `manager-path\conf\imgndb` For Linux: `/etc/opt/jp1imm/conf/imgndb`
Logical host	Created during the setup of the Intelligent Integrated Management database. <Storage destination directory> For Windows: `shared-folder`^#`\jp1imm\conf\imgndb` For Linux: `shared-directory`^#`/jp1imm/conf/imgndb` # Directory on the shared disk specified when building the JP1/IM - Manager logical host environment (directory specified separately for each logical host)

Operating environment

Storage to

Physical host

It is created during installation.

For Windows: manager-path\conf\imgndb

For Linux: /etc/opt/jp1imm/conf/imgndb

Logical host

Created during the setup of the Intelligent Integrated Management database.

For Windows: shared-folder^#\jp1imm\conf\imgndb

For Linux: shared-directory^#/jp1imm/conf/imgndb

#: Directory on the shared disk specified when building the JP1/IM - Manager logical host environment (directory specified separately for each logical host)

■ Operation command storage location

Store the Intelligent Integrated Management Database operational commands in the following location:

Operating environment	Storage to
Physical and logical hosts (common)	It is created during installation. <Storage destination directory> For Windows: `manager-path\bin\imgndb` For Linux: `/opt/jp1imm/bin/imgndb`

Operating environment

Storage to

Physical and logical hosts (common)

It is created during installation.

For Windows: manager-path\bin\imgndb

For Linux: /opt/jp1imm/bin/imgndb

■ Storage destination for individual logs of operation commands

Individual logs of operational commands of the Intelligent Integrated Management Database are stored in the following location. For logical hosts, the location of the log output for each command is different.

Operating environment	Storage to
Physical host	It is created during installation. Individual logs of all operational commands to be provided are output to the following directory. <Storage destination directory> For Windows: `manager-path\log\imgndb` For Linux: `/var/opt/jp1imm/log/imgndb`
Logical host	Created during the setup of the Intelligent Integrated Management database. For setup and unsetup commands Output to the same directory as the physical host: <Storage destination directory> For Windows: `manager-path\log\imgndb` For Linux: `/var/opt/jp1imm/log/imgndb` For commands other than the above <Storage destination directory> For Windows: `manager-path\jp1imm\log\imgndb` For Linux: `/var/opt/jp1imm/log/imgndb` And For Windows: `shared-folder`^#`\jp1imm\log\imgndb` For Linux: `shared-directory`^#`/jp1imm/log/imgndb` # Directory on the shared disk specified when building the JP1/IM - Manager logical host environment (directory specified separately for each logical host)

Operating environment

Storage to

Physical host

It is created during installation.

Individual logs of all operational commands to be provided are output to the following directory.

For Windows: manager-path\log\imgndb

For Linux: /var/opt/jp1imm/log/imgndb

Logical host

Created during the setup of the Intelligent Integrated Management database.

For setup and unsetup commands

Output to the same directory as the physical host:

<Storage destination directory>

For Windows: manager-path\log\imgndb

For Linux: /var/opt/jp1imm/log/imgndb
For commands other than the above

<Storage destination directory>

For Windows: manager-path\jp1imm\log\imgndb

For Linux: /var/opt/jp1imm/log/imgndb

And

For Windows: shared-folder^#\jp1imm\log\imgndb

For Linux: shared-directory^#/jp1imm/log/imgndb

#: Directory on the shared disk specified when building the JP1/IM - Manager logical host environment (directory specified separately for each logical host)

■ Storage location of trend data management service logs

Store the Trend Data Management Service logs in the following location:

Operating environment	Storage to
Physical host	It is created during installation. Individual logs of all operational commands to be provided are output to the following directory. <Storage destination directory> For Windows: `manager-path\log\imgndb` For Linux: `/var/opt/jp1imm/log/imgndb`
Logical host	Created during the setup of the Intelligent Integrated Management database. Created during the setup of the Intelligent Integrated Management database. For Windows: `shared-folder`^#`\jp1imm\log\imgndb` For Linux: `shared-directory`^#`/jp1imm/log/imgndb` # Directory on the shared disk specified when building the JP1/IM - Manager logical host environment (directory specified separately for each logical host)

Operating environment

Storage to

Physical host

It is created during installation.

Individual logs of all operational commands to be provided are output to the following directory.

For Windows: manager-path\log\imgndb

For Linux: /var/opt/jp1imm/log/imgndb

Logical host

Created during the setup of the Intelligent Integrated Management database.

For Windows: shared-folder^#\jp1imm\log\imgndb

For Linux: shared-directory^#/jp1imm/log/imgndb

#: Directory on the shared disk specified when building the JP1/IM - Manager logical host environment (directory specified separately for each logical host)

■ Storage destination of Intelligent Integrated Management Database socket file (for Linux only)

Store the socket file^# of the intelligent integrated management database in the following location for OSS (PostgreSQL) operation.

#

Deleting a socket file prevents the Intelligent Integrated Management database from working properly. In this case, you must restart the Intelligent Integrated Administration database service.

Operating environment	Storage to
Physical and logical hosts (common)	It is created during installation. <Storage destination directory> `/tmp`

Operating environment

Storage to

Physical and logical hosts (common)

It is created during installation.

/tmp

(e) Cluster configuration

Intelligent Integrated Management Database supports a clustered configuration of JP1/IM - Manager Integrated Manager hosts. For details on how to build a clustered environment, see the description about JP1/IM - Manager (Integrated Management Database) Setup in the JP1/Integrated Management 3 - Manager Configuration Guide.

To Page Top

(2) Install and uninstall

For information about installing and uninstalling Intelligent Integrated Management Database, see the description about Construction of Intelligent Integrated Management Database and Uninstallation procedure in the JP1/Integrated Management 3 - Manager Configuration Guide.

To Page Top

(3) functions

(a) Operational Commands

The operational commands for the Intelligent Integrated Management Database are shown below.

Intelligent Integrated Management Database Setup Command (jimgndbsetup)

This command sets up (install and configure Trend data Management Database) Intelligent Integrated Management Database (Trend data Management Database, Response Action results management database, integrated agent host Administration DB) and Trend Data Management Service.
Intelligent Integrated Management Database Unsetup Command (jimgndbunsetup)

This command unsets up (install and configure Trend data Management Database) Intelligent Integrated Management Database (Trend data Management Database, Response Action results management database, integrated agent host Administration DB) and Trend Data Management Service.
Command to stop the Intelligent Integrated Management database and the Trend Data Management service (jimgndbstop)

This command deactivates Intelligent Integrated Management Database (Trend data Management Database, Response Action results management database, integrated agent host Administration DB) and Trend Data Management Service.
Command to check the health status of the Intelligent Integrated Management Database and Trend Data Management Service (jimgndbstatus)

This command checks the operating status, such as starting and stopping, of Intelligent Integrated Management Database service (Trend data Management Database, Response Action results management database, integrated agent host administration DB) and the trend data management service.

For details about each command, see the appropriate command in Chapter 1 Commands in the JP1/Integrated Management 3 - Manager Command, Definition File and API Reference.

To Page Top

(4) About encrypted communication

The following communication points Hallow, Ltd. not encrypted for calculative communication.

Communication point	Description
Between the Intelligent Integrated Management Base and the Intelligent Integrated Management Database	Writing and retrieving trend data
Between the Intelligent Integrated Management Database operational commands and the Intelligent Integrated Management Database	Building and maintaining an intelligent integrated management database

To Page Top