Hitachi

JP1 Version 12 JP1/Automatic Job Management System 3 System Design (Configuration) Guide


2.11.1 Considering use of an external database

This subsection describes the points that you must consider if you want to operate a manager host in a cloud environment in which an external database is used for the manager host.

The following figure shows an example of a database configuration in which an external database is used.

Figure 2‒67: Database configuration in which an external database is used

[Figure]

Organization of this subsection

(1) Advantages and disadvantages of an external database

An external database has both advantages and disadvantages. Determine whether to use an external database considering how the advantages and disadvantages will affect the purpose of your operations.

Advantages of using an external database

The following shows the probable advantages of using an external database. If reduction of the workload in daily operations is important in your environment, use of an external database might be a better choice.

  • You can use functionality of the external database provided as a cloud service to automatically back up job definitions, execution results, execution statuses and other information during operation.

  • If a failure occurs in the external database, you can use functionality of the external database to recover the database to any point in time prior to the failure#. For this reason, you can quickly restart operation of JP1/AJS3 jobs by using recovered information such as the execution statuses and execution results of jobs.

  • If a failure occurs in a manager host, by recovering a manager host environment that was backed up, you can quickly restart operation of JP1/AJS3 jobs by using recovered information such as the execution statuses and execution results of jobs.

#

For details, see the documentation for the cloud service.

Disadvantages of using an external database

The following shows disadvantages that you will probably encounter when using an external database. If you are building a mission-critical system, use of the embedded database might be a better choice.

  • The user is responsible for the set-up and operation of an external database. With respect to the investigation of the cause of failure in the cloud service or in the DBMS product, if a failure occurs during operation, the user will need to take actions such as making inquiries to the parties managing the cloud.

  • Because the external database is accessed via a network, performance in operations such as job execution and command execution is lower for the external database than for the embedded database.

  • Some JP1/AJS3 functions become unavailable. For details about the functions that become unavailable, see (7) Functions that cannot be used in an environment in which an external database is used.

(2) DBMS product that can be used

The following shows the DBMS product that JP1/AJS3 can use for an external database.

For details about the cloud services supported by this product, see the Release Notes.

Note that ODBC is used for connection with the external database. The following figure shows an overview of ODBC-based connection with the external database.

Figure 2‒68: ODBC-based connection to the external database

[Figure]

Cautionary note

To use ODBC, you must install the ODBC driver on the manager host.

(3) Conditions for using an external database and the basic configuration in which an external database is used

This subsection describes the conditions for using the external database and the configuration of the manager host and external database.

(a) Conditions for using an external database

An external database can be used if all of the following conditions are met:

  • The OS of the manager host that is to be connected with the external database is Windows or Linux.

  • The manager host is operating in a cloud environment.

  • The manager host is operating on only a physical host.

  • The database is in the standard configuration without ISAM.

(b) Restrictions on using an external database

To use SQL Server or another DBMS product that can produce multiple instances of an external database, the following restrictions are placed on the database and its instances:

  • The databases of the external database used for JP1/AJS3 must contain the data related to JP1/AJS3 only.

  • Prepare one database for each scheduler service.

    The following figure shows an example of database and scheduler service configurations that are supported and not supported.

    Figure 2‒69: Database and scheduler service configurations

    [Figure]

  • If multiple scheduler services are used on one manager host, all of the scheduler services must use the external database.

    It is impossible to use both the embedded database and an external database for each scheduler service. The following shows an example of configurations of a manager host connected with external databases.

    Figure 2‒70: Example of configurations of a manager host connected with external databases

    [Figure]

(c) Basic configuration of external databases and a manager host

External databases can be used in either of the following configurations:

  • Configuration in which one manager host uses multiple instances of the external database

  • Configuration in which multiple manager hosts use one instance of the external database

The following figure shows configurations in which manager hosts use instances of the external database.

Figure 2‒71: Configuration in which one manager host uses one instance of the external database

[Figure]

Figure 2‒72: Configuration in which one manager host uses different instances of the external database

[Figure]

Figure 2‒73: Configuration in which different manager hosts use one instance of the external database

[Figure]

(d) Version compatibility between a manager host that uses an external database, and other products

The version compatibility between JP1/AJS3 - Manager when an external database is used as its database, and other products (other JP1/AJS3 products, the prerequisite product JP1/Base, and optional products) is the same as the version compatibility when an embedded database is used, with the exclusion of the special notes. For details about version compatibility for each product, see 8.1 Version compatibility.

(4) Connection relationship between the external database and JP1/AJS3 - Manager

The external database and JP1/AJS3 - Manager have the following connection relationship:

Use the jajs_extdb command to set the connections again. For details about the jajs_extdb command, see jajs_extdb in 3. Commands Used for Normal Operations in the manual JP1/Automatic Job Management System 3 Command Reference.

For details about how to recover the manager host in a cloud environment and how to recover the external database, see 12.2 Recovery from a failure in an environment that uses an external database in the JP1/Automatic Job Management System 3 Administration Guide.

(5) Setting up a manager host that connects to an external database

When you perform a new installation of JP1/AJS3, you can specify whether to automatically set up a scheduler service and embedded database. To use an external database, do not set up a scheduler service and embedded database during the new installation. After the new installation has finished, set up the external database. For details, see 24.2 Setting up JP1/AJS3 to use an external database in the JP1/Automatic Job Management System 3 Configuration Guide.

If JP1/AJS3 is already operating with the embedded database, you can switch the embedded database to the external database by exporting the data to the external database. You can export the following types of data:

For details about how to export data from the embedded database to the external database, see 24.3 Exporting data from the embedded database currently in use to the external database in the JP1/Automatic Job Management System 3 Configuration Guide.

(6) Operation using an external database

While JP1/AJS3 is operating with an external database, job information, jobnet information, and other information that is required for continuation of operation is stored in the external database. Therefore, if the data in the external database has been backed up, operation can be quickly restored when a failure occurs in the external database.

Also, if the same environment as the manager host environment has been prepared and the manager host fails, operation can be quickly restored by using the environment in which the failure has not occurred.

For details about how to restore operation that uses the external database, see 12.2 Recovery from a failure in an environment that uses an external database in the JP1/Automatic Job Management System 3 Administration Guide.

If operation is restored in an environment that uses an external database, the JP1/AJS3 service and the scheduler service perform a disaster recovery start. At this time, the statuses of jobs and jobnets change because of the disaster recovery start. Therefore, confirm safety, and then rerun the jobs and jobnets.

For details about the status of each job and jobnet when disaster recovery start is performed, see 6.2.1 Temporarily changing the start mode of JP1/AJS3 in the JP1/Automatic Job Management System 3 Administration Guide.

(7) Functions that cannot be used in an environment in which an external database is used

The following shows the functions that cannot be used in an environment in which an external database is used:

(8) Notes on using an external database

Note the following points when you use JP1/AJS3 that is operating with an external database: