6.1.3 Estimating when to perform maintenance
You must periodically perform maintenance of an embedded database to allow invalid areas to be reused, or reorganize the database. If the automatic maintenance function is enabled, maintenance of the embedded database is automatically performed every day at the user-specified time. For maintenance performed by using the ajsembdbreclaim command, you can execute the command at any time to perform maintenance periodically. You can also check database usage from a web browser by using the Web GUI (Management Portal).
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.
(3) Checking using the Web GUI (Management Portal)
You can check database usage from a web browser by using the Web GUI (Management Portal).
To use the Web GUI (Management Portal), you must set up the manager host. For details, see 6.7 Settings related to the Web GUI (Management Portal) in the JP1/Automatic Job Management System 3 Configuration Guide (for Windows) or 15.8 Settings related to the Web GUI (Management Portal) in the JP1/Automatic Job Management System 3 Configuration Guide (for UXIN).
For details about the operation procedure in the Web GUI (Management Portal), see 16. Management Portal of the Web GUI in the JP1/Automatic Job Management System 3 Operator's Guide.