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 either of the following methods:

• Execute the ajsembdbreclaim command to make the areas usable.

• Reorganize the database.

Using the ajsembdbreclaim command, you can reclaim and reuse pages in the database that consist only of invalid areas (unused pages). This command can be executed even while the server is running. By executing the command periodically, you can enable better use of data areas. In most circumstances, if you use this command you will not need 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 figure shows the flow of maintenance tasks.

Figure 6‒1: Flow of maintenance tasks

To Page Top