13.5.2 Settings for reducing the data area usage in the embedded database

(1) Setup procedure for reducing the data area usage of an embedded database

To reduce the data area usage of an embedded database, perform the procedure below.

Supplementary note:

For a cluster environment, perform this procedure on the executing host. This procedure is unnecessary on the standby host.

1. Back up the execution agent information and unit definition information contained in the embedded database.

   For details about how to back up the information, see 2.2.3(2) Backing up the execution agent information in the JP1/Automatic Job Management System 3 Administration Guide and 2.2.3(4) Backing up the unit definition in the JP1/Automatic Job Management System 3 Administration Guide.

2. On the JP1/AJS3 - Manager physical host and all logical hosts, stop all the services, including the JP1/AJS3 service, that access the embedded database.

   For a cluster environment, confirm the following before starting the subsequent procedure:

   • The physical host of the primary node can access the shared disk.

   • The IP address of the logical host is enabled.

3. Execute the ajsembdbunset command to delete the embedded database.

   For example, execute the ajsembdbunset command as follows:

   ajsembdbunset -e -id setup-identifier

   For details about the ajsembdbunset command, see ajsembdbunset in 2. Commands Used during Setup in the manual JP1/Automatic Job Management System 3 Command Reference.

4. Execute the ajsembdbbuild command to create an embedded database.

   For example, execute the ajsembdbbuild command as follows.

   For an embedded database automatically created by JP1/AJS3:

   ajsembdbbuild {-s|-m|-l} -d data-area-directory

   -p embedded-database-port-number^#

   -i embedded-database-practical-directory -id setup-identifier

   [-mh logical-host-name -eh executing-physical-host -r

   -ld work-area-directory] -ext_db -ext_log

   #: Specify the value of the RDBPORT environment setting parameter for the scheduler service used in the embedded database.

   For an embedded database created by performing advanced setup:

   ajsembdbbuild option-used-for-creation-before-upgrade

   For details about the ajsembdbbuild command, see ajsembdbbuild in 2. Commands Used during Setup in the manual JP1/Automatic Job Management System 3 Command Reference.

5. Execute the ajsembdbsetup command to set up the embedded database.

   For example, execute the ajsembdbsetup command as follows.

   For an embedded database automatically created by JP1/AJS3:

   ajsembdbsetup -ru {s|m|l} -F scheduler-service-name^#1

   -p embedded-database-port-number^#2 -id setup-identifier^#2

   -tp table-name-prefix^#3 [-mh logical-host-name]

   #1: Specify the scheduler service name that was previously used.

   #2: Specify the value you specified for the ajsembdbbuild command in step 4.

   #3: Specify the value of the TABLENAMEPREFIX environment setting parameter for the relevant scheduler service.

   For an embedded database created by performing advanced setup:

   ajsembdbsetup option-used-for-setup-before-upgrade

   For details about the ajsembdbsetup command, see ajsembdbsetup in 2. Commands Used during Setup in the manual JP1/Automatic Job Management System 3 Command Reference.

6. Cold-start the JP1/AJS3 service.

7. Recover the execution agent information and unit definition information from the backup.

   For details about how to recover the information, see 2.3.4(8) Recovering the execution agent information in the JP1/Automatic Job Management System 3 Administration Guide and 2.3.4(9) Recovering the unit definition in the JP1/Automatic Job Management System 3 Administration Guide.

To Page Top