Hitachi

JP1 Version 12 JP1/Automatic Job Management System 3 Configuration Guide


23.3 Maintaining an embedded database

This section describes considerations for maintaining an embedded database.

JP1/AJS3 uses a database to manage information about job definitions, job execution registrations, and other items. Repeated addition and deletion of data will degrade the efficiency of database use. Therefore, you must periodically perform maintenance of the database to reclaim or reorganize unavailable areas. Also, increased information about job definitions and job execution registrations, or increased unavailable areas will put pressure on the disk capacity, preventing JP1/AJS3 from operating normally. To avoid this, you must also monitor the data area usage.

Table 23‒9: Points to consider regarding maintenance of an embedded database

No.

Key decisions

Relevant chapter

1

Flow of tasks for maintaining an embedded database

6. Maintenance Planning in the JP1/Automatic Job Management System 3 System Design (Configuration) Guide

2

How to maintain an embedded database

9.2 Performing maintenance in the JP1/Automatic Job Management System 3 Administration Guide

For JP1/AJS3, we recommend that you perform maintenance once a day by using the automatic maintenance function or by using the ajsembdbreclaim command.

For details about the setting for using the automatic maintenance function, see 9.2.1 Using the automatic maintenance function in the JP1/Automatic Job Management System 3 Administration Guide. For details about the settings for automatically executing the ajsembdbreclaim command, see 9.2.2(1) Executing the ajsembdbreclaim command automatically in the JP1/Automatic Job Management System 3 Administration Guide.

Note that if an embedded database has not been maintained for a long time, a large area might be unavailable. In such cases, if the ajsembdbreclaim command is executed, the embedded database terminates abnormally (as a result of insufficient system logs).

If the system logs become insufficient, you must estimate the number of system logs required for executing the ajsembdbreclaim command, and expand system logs. For details about estimating the number of system logs, see 9.1.1 Analyzing the database area in the JP1/Automatic Job Management System 3 Administration Guide.