6.1.1 Flow of maintenance tasks
When JP1/AJS3 is used over an extended period with the embedded database serving as the scheduler database, invalid areas are created in the indexes as records are erased from the database. You must clean up these invalid areas by using one of the following methods:
-
Enable the automatic maintenance function.
-
Execute the ajsembdbreclaim command to make the areas usable.
-
Reorganize the database.
Using the automatic maintenance function or the ajsembdbreclaim command, you can reclaim and reuse pages in the database that consist only of invalid areas (unused pages). You can perform these maintenance operations even while the server is running. By performing maintenance periodically, you can enable better use of data areas.
In most circumstances, you can simply perform maintenance without having to reorganize the database. However, when page usage efficiency declines (for example, pages have only one item of valid data), the number of pages that can be reclaimed declines and it might not be possible to reuse them efficiently. The database must then be reorganized.
The following table shows the flow of maintenance tasks.
|
No. |
Work |
Relevant section |
||
|---|---|---|---|---|
|
1 |
Estimate the maintenance time |
9.1 Estimating a maintenance time in the JP1/Automatic Job Management System 3 Administration Guide |
||
|
2 |
Select a maintenance method |
|||
|
3 |
Execute the ajsembdbreclaim command (When operation is normal) |
Execute the ajsembdbreclaim command manually |
9.2.2(2) Executing the ajsembdbreclaim command manually in the JP1/Automatic Job Management System 3 Administration Guide |
|
|
4 |
Execute the ajsembdbreclaim command automatically |
Use the automatic maintenance function. |
9.2.1 Using the automatic maintenance function in the JP1/Automatic Job Management System 3 Administration Guide |
|
|
5 |
Define the command as a job. |
9.2.2(1) Executing the ajsembdbreclaim command automatically in the JP1/Automatic Job Management System 3 Administration Guide |
||
|
6 |
Reorganize the database (When page reuse efficiency is low) |
Use the ajsembdbrorg command to reorganize the database |
9.2.3(1) Using the ajsembdbrorg command to reorganize the database in the JP1/Automatic Job Management System 3 Administration Guide |
|
|
7 |
Use a script to reorganize the database |
9.2.3(2) Using a script to reorganize the database in the JP1/Automatic Job Management System 3 Administration Guide |
||