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.