15.9.1 Setting up the automatic maintenance function for embedded databases
For an embedded database of JP1/AJS3 - Manager, you must perform maintenance at regular intervals by using one of the following three methods:
-
Enable the automatic maintenance function.
-
Make database areas usable by using the ajsembdbreclaim command.
-
Reorganize the database.
This subsection describes the setup procedure when you want to use the automatic maintenance function. For details about maintenance tasks, see 6.1.1 Flow of maintenance tasks in the JP1/Automatic Job Management System 3 System Design (Configuration) Guide.
- Organization of this subsection
(1) Setting up the automatic maintenance function for embedded databases
To enable the automatic maintenance function:
-
Execute the following command to set the environment setting parameter described in (2) below:
jajs_config -k definition-key-name "environment-setting-parameter-name-1"=definition-1 ["environment-setting-parameter-name-2"=definition-2]
The new settings are applied.
-
If you perform an upgrade installation of JP1/AJS3 - Manager whose version is earlier than 10-00, enhance the embedded database management function.
For details about the settings for enhancing the embedded database management function, see 13.5.1 Settings for enhancing the embedded database management function.
(2) Environment setting parameters
Definition key |
Environment setting parameter |
Explanation |
---|---|---|
[{JP1_DEFAULT|logical-host}\JP1AJS2\HOST]# |
"DBAUTOMAINTENANCE"= |
Whether to enable the automatic maintenance function for embedded databases |
"DBAUTOMAINTENANCETIME"= |
Time when maintenance is to be performed for the embedded database |
- #:
-
The specification of the {JP1_DEFAULT|logical-host} part depends on whether the host is a physical host or a logical host. For a physical host, specify JP1_DEFAULT. For a logical host, specify the logical host name.
For details about the definition of these environment setting parameters, see the following:
(3) If you want to stop the automatic maintenance function
If you want to stop automatic maintenance during operation because, for example, a failure occurs, use the jajs_config command to specify no for the DBAUTOMAINTENANCE environment setting parameter. The value of this environment setting parameter is applied immediately. Therefore, automatic maintenance stops as soon as you change the setting.
(4) Notes
-
If JP1/AJS3 is not running at the maintenance time specified for the DBAUTOMAINTENANCETIME environment setting parameter, maintenance is not performed.
-
If automatic maintenance fails, maintenance for that time period is not retried. Maintenance is performed at the specified time on the next day. If maintenance is successful the next time and later, no action is needed. If maintenance fails repeatedly, check the error message output to the log file, and then take corrective action. The log file name is dbautomaintenance[host-name].log. For the log file storage location, see 1.2.5 List of log files and directories in the manual JP1/Automatic Job Management System 3 Troubleshooting.
-
If maintenance starts at a time when the execution of jobs and jobnets creates a heavy load or when a command or JP1/AJS3 - View is operating on a unit, a timeout error might occur during maintenance. Make sure that the maintenance time specified for the DBAUTOMAINTENANCETIME environment setting parameter is different from such times.
-
If maintenance by using the automatic maintenance function and maintenance by using the ajsembdbreclaim command are performed concurrently, either maintenance might terminate abnormally. If you enable the automatic maintenance function, do not execute the ajsembdbreclaim command while maintenance is being performed.