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
(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.
|
(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>
|
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>
|
■ 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>
|
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 |
■ 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 |
■ 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
|
■ 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 |
■ 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.
|
■ 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
|
■ 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
(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.
(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.
(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.
(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 |