9.1.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 3. Commands Used for Normal Operations in the manual JP1/Automatic Job Management System 3 Command Reference.
If you execute the ajsembdbreclaim command in a state in which large quantities of unavailable areas occur in the database, a lot of data is sent to the system log. If large quantities of unavailable areas occur because maintenance has not been performed for a long time, estimate the system log size necessary for executing the ajsembdbreclaim command. The necessary system log size is the maximum value obtained when the expression below is calculated for each table and index. To check the values for the individual items in the expression, execute the ajsembdbstatus command with the -db and -d options specified.
((Collect On Segment) + (Collect Prearranged Page#) / 10) x 0.004 (units: megabytes)
- #:
-
For tables other than the AJSJINF table, substitute the value of the Collect Prearranged Page in the Base row segment.
For the AJSJINF table, add the value of the Collect Prearranged Page in the Base row segment to that in the BINARY segment, and then substitute the value in the formula.
Note that the AJSJINF table exists only when the backup enhancement function is enabled.
If, as a result of estimating the necessary system log capacity, you determine that the system log will be insufficient, add a system log by executing the ajsembdbaddlog command, and then execute the ajsembdbreclaim command.
For details about the ajsembdbaddlog command, see ajsembdbaddlog in 3. Commands Used for Normal Operations in the manual JP1/Automatic Job Management System 3 Command Reference.
For details about the ajsembdbreclaim command, see ajsembdbreclaim in 3. Commands Used for Normal Operations in the manual JP1/Automatic Job Management System 3 Command Reference.
For details about the Collect On Segment / Collect Prearranged Page / Collect On Page, see ajsembdbstatus in 3. Commands Used for Normal Operations in the manual JP1/Automatic Job Management System 3 Command Reference.