Job Management Partner 1/Automatic Job Management System 3 Administration Guide
When you use a JP1/AJS3 database, you need to either periodically execute the ajsembdbreclaim command to make unavailable areas usable again or reorganize the database. Before using the ajsembdbreclaim command and estimating when to perform reorganization, you need to analyze the database area. Estimate when to perform reorganization based on the values measured in the procedure below.
When estimating the reorganization time, consider weekly and monthly peak days and weekly and monthly increases.
- Organization of this section
- (1) Analyzing the database area
- (2) Messages indicating an area shortage
(1) Analyzing the database area
Execute the ajsembdbstatus command to check the database status.
If the analysis result of the ajsembdbstatus command indicates that there are few segments and many free pages, perform database maintenance.
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 storage efficiency of data in the JP1/AJS3 database decreases, the KFPH00211-I or KFPH00212-I message is output to the Windows event log or syslog file. If either of these messages is output, use the ajsembdbstatus command to analyze the database status, and reorganize the database as required. The following shows an example of messages output.
- Example 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=xxxxxIf the message is still output immediately after you perform database maintenance or reorganization, you need to increase the RD area. For details about how to increase the RD area, see ajsembdbaddarea in 2. Commands in the manual Job Management Partner 1/Automatic Job Management System 3 Command Reference 1.
Copyright (C) 2009, 2010, Hitachi, Ltd.
Copyright (C) 2009, 2010, Hitachi Solutions, Ltd.