5.2.2 How to check the unused area of the ISAM files used in the execution environment for QUEUE jobs and submit jobs, and when the database should be reorganized
Execute the jpqdbcond command to check the unused area in the ISAM database.
Notes on using the jpqdbcond command are provided below. For details about the jpqdbcond command, see jpqdbcond in 3. Commands Used for Normal Operations in the manual JP1/Automatic Job Management System 3 Command Reference.
- Organization of this subsection
(1) How to check the unused area
Use the jpqdbcond command to check the unused area in the database.
The following are examples of using the jpqdbcond command:
jpqdbcond -L -a -t se,10
This command outputs information about the ISAM files used in the execution environment for QUEUE jobs and submit jobs to the standard output. If the size of the unused area has reached the threshold (10 MB), the command also outputs a message to the standard error output, and Windows event log or syslog. By using the options indicated to schedule the jpqdbcond command for execution as a JP1/AJS3 job when not many jobs are executed, you can periodically check the ISAM file status and set the output of warning messages.
jpqdbcond -l -a
This command outputs the status of the ISAM file used in the execution environment for QUEUE jobs and submit jobs. The output information includes the percentage of unused area, the unused area size, and a percentage value for data file fragmentation.
jpqdbcond -L -a -t j,10
This command outputs the following JP1 event when the size of the unused area reaches the threshold (10 MB):
-
Event ID: 00004164
-
Event name: Event for reporting that the size of the ISAM unused area reached the threshold
-
Message ID: KAVU5984-W
Reorganize the database if the predefined threshold is exceeded.
(2) When the database needs to be reorganized
To determine when to reorganize the execution environment for QUEUE jobs and submit jobs, use as a guideline the size of the JPQJOBINFO.K02 file and the number of days for saving job information. For details about reorganization, see 9.3 Reorganizing a database when QUEUE jobs and submit jobs are used. For details about setting the number of days for saving job information, see 20.5 Setting up the job execution environment in the JP1/Automatic Job Management System 3 Configuration Guide.
For details about the JP1 event output by the jpqdbcond command, see A. JP1 Events Issued by JP1/AJS3.
(3) Notes on the jpqdbcond command
-
Before you execute the jpqdbcond command with the -l option specified, make sure that the ISAM files are closed. To close the ISAM files, stop JP1/AJS3. If you execute the command when the ISAM files are open, the operational results are not guaranteed.
-
If you specify the command with the -L option specified, you can also obtain information about the ISAM files being used by other processes. However, if other concurrently running processes update the ISAM files, differences arise between the information you have obtained and the ISAM files. While the command is being executed, accesses to ISAM files from other processes are suspended to protect the integrity of ISAM files. Therefore, avoid using this command during a busy period when many jobs are being executed.
-
Information output by the -l or -L option indicates the percentage of unused area, not the fragmentation percentage. Therefore, if the ISAM file contains no records or only a few records, 100% is output as the percentage of unused area for the reserved free area that is still unused.