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:
-
Displays the connection information of the external database connected to JP1/AJS3 - Manager.
-
Sets a connection relation between JP1/AJS3 - Manager and the database on an external database.
-
Cancels the execution-suppression startup status for a scheduler service after recovering the database from a system error.
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
-
Do not execute this command repeatedly in quick succession.
-
You can execute this command only for a manager host or scheduler service that uses an external database. If you execute the command for an agent management database or scheduler database that does not use an external database, the command terminates abnormally.
-
Do not forcibly terminate this command during execution.
-
If you specify the -p option, the command forcibly sets a connection relation between a database and JP1/AJS3 - Manager or scheduler service even if the database is already in use. If you specify the -p option, confirm the target database for setting a connection relation before you execute the command.
-
Before specifying the -p option, make sure that the JP1/AJS3 service is not running.
-
You can execute this command only for a physical host or for scheduler services that are set up on a physical host.
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.
-