Hitachi

JP1 Version 12 JP1/Automatic Job Management System 3 Command Reference


jajs_extdb

Organization of this page

Format

jajs_extdb
     [-v | -p | -r]
     [-F scheduler-service-name | -a]
     [-y]

Format1 (for displaying the connection information of the external database)

jajs_extdb
     [-v]

Format2 (for setting a combination of connections between JP1/AJS3 - Manager and the database on an external database)

jajs_extdb
     -p
     {-F scheduler-service-name | -a}
     [-y]

Format3 (for canceling the execution-suppression startup status for a scheduler service)

jajs_extdb
     -r
     -F scheduler-service-name

Description

You can use this command if you are using an external database to operate JP1/AJS3.

The command performs the following processing according to the specified options:

Execution privileges

In Windows: Administrators privilege

In Linux: Superuser privilege

Arguments

-v

Displays the connection information of the external database.

You can specify this option regardless of the status of the JP1/AJS3 service.

If you specify this option at the same time as the -p or -r option, the command terminates abnormally.

-p

Sets a connection relation between JP1/AJS3 - Manager and the database on the external database after recovering JP1/AJS3 - Manager or external database from a system error.

When you execute the command, a message asking you whether you want to set the connection relation appears. Enter y or Y to set the connection relation, or enter any other character (including n) to cancel.

If you specify this option with the -a option, the command sets the connection relation between JP1/AJS3 - Manager and the agent management database.

If you specify this option with the -F option, the command sets the connection relation between the scheduler service specified in the -F option and the database on the external database. The target scheduler is also placed in the execution-suppression startup status. Disaster recovery starts are performed for JP1/AJS3 services that are in the execution-suppression start status. For details about performing a disaster recovery start, see 6.2.1 Temporarily changing the start mode of JP1/AJS3 in the JP1/Automatic Job Management System 3 Administration Guide.

To cancel the execution-suppression start status, run the command with the -r option specified.

If you specify this option at the same time as the -v or -r option, the command terminates abnormally.

If JP1/AJS3 - Manager is not connected to an external database (if you are using the embedded database in a standard configuration), the command terminates abnormally.

-r

Cancels the execution-suppression start status for the scheduler service specified in the -F option.

If you specify this option at the same time as the -v or -p option, the command terminates abnormally.

-F scheduler-service-name

Specify the name of the scheduler service for which you want to perform the desired operation (addition, renaming, or deletion).

You can specify a character string of 1 to 30 bytes.

You must specify this option with the -p or -r options.

If you specify this option at the same time as the -v or -a option, the command terminates abnormally.

-a

Specifies the agent management database as the target of setting a connection relation by using the -p option.

You must specify this option with the -p options.

If you specify this option at the same time as the -v , -r or -F option, the command terminates abnormally.

-y

Specify this option if you do not want to output a message that confirms execution of the command when a connection relation is set by using the -p option.

You must specify this option with the -p options.

If you specify this option at the same time as the -v or -r option, the command terminates abnormally.

Notes

Return values

0

Normal end

Values other than 0

Abnormal end

Example 1

The following command displays information about the physical host, information about the agent management database on an external database, and the connection information for all scheduler databases.

jajs_extdb -v

Example 2

The following command sets a connection relation between JP1/AJS3 - Manager and the database of the scheduler service (AJSROOT1).

jajs_extdb -p -F AJSROOT1

Example 3

The following command sets a connection relation between JP1/AJS3 - Manager and the database of the scheduler service (AJSROOT2) without displaying a message that confirms execution of the command.

jajs_extdb -p -F AJSROOT2 -y

Example 4

The following command sets a connection relation between JP1/AJS3 - Manager and the agent management database on an external database.

jajs_extdb -p -a

Example 5

The following command cancels the execution-suppression start status for the scheduler service (AJSROOT1).

jajs_extdb -r -F AJSROOT1

Output example

The following shows a sample execution of the command with the -v option specified:

(1) Host                           JP1_DEFAULT
(2) Database Type                  SQLSVR
 
(3) Agent management
(4)  Status                        ENABLE
(5)  ODBC File Data Source Name    /odbc/ajsdatasource.dsn
(6)  Database Name                 AJSROOT1DB
 
(7) Scheduler Service              AJSROOT1
(8)  Status                        ENABLE
(5)  ODBC File Data Source Name    /odbc/ajsdatasource.dsn
(6)  Database Name                 AJSROOT1DB
 
(7) Scheduler Service              AJSROOT2
(8)  Status                        ENABLE
(5)  ODBC File Data Source Name    /odbc/ajsdatasource2.dsn
(6)  Database Name                 AJSROOT2DB

The output items are as follows:

(1) Host

Indicates the physical host name (JP1_DEFAULT).

(2) Database Type

Indicates the database type of the database used on the external database.

  • When Microsoft SQL Server is used: SQLSVR

(3) Agent management

Indicates the item name.

(4) Status

Indicates the status of the agent management database on the external database.

The status to be displayed is as follows:

No.

Status

Meaning

1

ENABLE

Available as the agent management database.

2

DISABLE

Not available as the agent management database. A connection relation between JP1/AJS3 - Manager and the agent management database must be set.

3

NOT CONNECTABLE

A connection with the target database cannot be established.

(5) ODBC File Data Source Name

Indicates the ODBC file data source name to be used.

(6) Database Name

Indicates the database name to be used.

(7) Scheduler Service

Indicates the name of the scheduler service.

(8) Status

Indicates the status of the scheduler database on the external database.

The status to be displayed is as follows:

No.

Status

Meaning

1

ENABLE

Available as a scheduler database.

2

DISABLE

Not available as a scheduler database. A connection relation between JP1/AJS3 - Manager and the scheduler database must be set.

3

SUPPRESS

JP1/AJS3 is started in the execution-suppression start status because the connection between JP1/AJS3 - Manager and the database was set up with the -p option specified.

To start job operation, you need to:

  • Execute the jajs_extdb -r command to cancel the execution-suppression start status.

  • Execute the ajsalter -s none command to cancel the suppression of job execution.

4

NOT CONNECTABLE

A connection with the target database cannot be established.