6.1.2 Estimating when to perform maintenance
With an embedded database, you must either execute the ajsembdbreclaim command, allowing invalid areas to be reused, or reorganize the database at regular intervals. To estimate when to execute the ajsembdbreclaim command or reorganize the database, you need to analyze the database areas. Work out how often maintenance tasks will be required, based on the analysis results described below.
When estimating when to reorganize the database, consider on which day usage of the database peaks, and by how much usage increases, on a weekly and monthly basis.
The following describes how to analyze database areas.
- Organization of this subsection
(1) Analyzing database areas
Execute the ajsembdbstatus command to check the database status.
If the analysis result of the ajsembdbstatus command shows that there are few unused segments and many unused pages, reorganize the database.
For details about the ajsembdbstatus command, see ajsembdbstatus in 3. Commands Used for Normal Operations in the manual JP1/Automatic Job Management System 3 Command Reference.
(2) Messages indicating an area shortage
When the data storage efficiency of the embedded database declines, messages is output to the Windows event log or UNIX syslog. If the messages is output, analyze the database status by executing the ajsembdbstatus command, and reorganize the database as required. For details about the output messages, see 5.2.1 How to check the database usage in the JP1/Automatic Job Management System 3 Administration Guide.
If either of these messages is output immediately after you execute the ajsembdbreclaim command or reorganize the database, you will need to expand the indicated RD area. For details about how to expand an RD area, see ajsembdbaddarea in 3. Commands Used for Normal Operations in the manual JP1/Automatic Job Management System 3 Command Reference.