12.1.2 Procedure for changing the items specified in the ODBC file data source

The following shows the procedure for changing the items specified in an ODBC file data source:

Run the jajs_extdb command, and check whether the ODBC file data source name that you want to change is used by agent management and by the scheduler service.

Execute the following command.

jajs_extdb -v

The following shows an output example.

Host                            JP1_DEFAULT
Database Type                   SQLSVR
 
Agent management
  Status                        ENABLE
  ODBC File Data Source Name    /odbc/ajsdatasource.dsn
  Database Name                 AJSROOT1DB
 
Scheduler Service               AJSROOT1
  Status                        ENABLE
  ODBC File Data Source Name    /odbc/ajsdatasource.dsn
  Database Name                 AJSROOT1DB
 
Scheduler Service               AJSROOT2
  Status                        ENABLE
  ODBC File Data Source Name    /odbc/ajsdatasource2.dsn
  Database Name                 AJSROOT2DB

Check whether the ODBC File Data Source Name that is output for the agent management and/or a scheduler service in the output example is the change target.

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.

Stop the JP1/AJS3 services on all manager hosts on which the following exist: agent management of the change target, and the scheduler service of the change target.

On the manager host, change the settings in the ODBC file data source.

The following table lists the items that can be changed.

Table 12‒2: Items that can be changed in the ODBC file data source
No.	Item to be specified	Item in the ODBC file data source
1	Connection-destination server address^# and port number	`SERVER`
2	User name	`UID`
3	Password	`PWD`

#: Connection between JP1/AJS3 and the external database does not depend on the JP1/Base communication settings. Therefore, make sure that the IP address can be resolved by using the OS functions such as the hosts file and the DNS.

Restart the JP1/AJS3 services on all manager hosts on which the following exist: agent management of the change target, and the scheduler service of the change target.

To Page Top