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 2. Commands in the manual Job Management Partner 1/Automatic Job Management System 3 Command Reference 1.
(2) Messages indicating an area shortage
When the data storage efficiency of the embedded database declines, message KFPH00211-I or KFPH00212-I is output to the Windows event log or UNIX syslog. If either of these messages is output, analyze the database status by executing the ajsembdbstatus command, and reorganize the database as required. Examples of the output messages are shown below.
- Examples of messages indicating an area shortage
KFPH00211-I RDAREA usage xxx%, RDAREA="xxxxx" xxxxx KFPH00212-I Table should be reorganized, RDAREA="xxxxx", AUTHID=xxxxx, TABLE=xxxxx
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 2. Commands in the manual Job Management Partner 1/Automatic Job Management System 3 Command Reference 1.