Reporting
You can use the information in the messages described in this topic to monitor REORG PLUS performance and to fine-tune future runs.
REORG PLUS issues performance-related messages if you specify MSGLEVEL(1) on your EXEC statement or in your installation options. For more information about specifying this utility parameter, see Utility parameters on the REORG PLUS EXEC statement.
For message explanations, access the BMC Documentation Center from the BMC Support Central site (http://www.bmc.com/support).
This message indicates that BMCSORT found that the memory resources available are insufficient to provide the most efficient sorting. To allow the utility job to complete, BMCSORT might choose a less efficient sorting algorithm, which can increase the elapsed time of the job.
Also see message BMC50474I, which reports the memory that is available to the utility at the time of optimization. If the value for ABOVE as indicated in BMC50474I is substantially less than the value for your REGION parameter, your system might have a memory-limiting exit active.
One of the following actions might improve the sort efficiency for future jobs:
- Increase your region size, if possible.
- Limit the scope of the job that you are running to reduce the amount of work that the utility needs to do.
- Contact your systems programmer to increase the memory limit, if possible.
This message indicates that the reorganization is constrained because the amount of virtual memory available is insufficient for optimal performance. For most jobs, REORG PLUS continues processing. If you also receive the message BMC50399E, however, the amount of virtual memory available to REORG PLUS is insufficient to continue.
We recommend that you specify REGION=0M on the JOB or EXEC statement of your execution JCL to tell the system to allocate the optimal amount of available virtual storage to the REORG PLUS job. However, if you are processing a large number of partitions, processing might be constrained, even if you specified REGION=0M. In this case, consider reorganizing fewer partitions in a single job.
This message indicates that the reorganization is constrained because the number of sort work files or the total amount of space for the sort work files is insufficient for optimal performance. For most jobs, REORG PLUS continues processing. If you also receive the message BMC50399E, however, the number or size of the sort work files is insufficient for REORG PLUS to continue.
No action is required. However, consider specifying larger sort work files or more sort work files to improve performance.
The reorganization is unable to continue because of constrained resources. Message BMC50397I, message BMC50398I, or both are issued before this message.
Make one or more of the following adjustments:
- Specify a larger region size.
- Specify larger sort work files or more sort work files.
- Adjust the installation options to improve performance.
This message indicates that the reorganization is constrained because insufficient index work files are available, but the reorganization continues.
Specify additional index work data sets (SYSUT1nn).
This message displays current values for each option in the installation options module. Use this information to verify that REORG PLUS is using the option value that you want to use.
This message displays the following information about virtual storage and CPU usage:
- Amount of virtual storage available below the 16-MB line
- Amount of virtual storage available above the 16-MB line
- Number of physical general CPUs available in the processor
Use this information to ensure that adequate virtual storage is available for REORG PLUS to use. For more information, see Providing maximum virtual storage and messages BMC50475I and BMC50479I.
This message displays the following performance information about I/O operations to sequential data sets:
- The ddname associated with the I/O operations
- Number of I/Os (blocks) written to or read from the data set
- Number of waits issued for I/O completion
- Number of waits for serialization of the data set
A wait count that is greater than 10 percent of the block count might indicate degraded performance.
Try allowing REORG PLUS additional buffer space for the associated data set (see Performance-considerations-for-buffer-installation-options) or using multiple data sets. A high number of serialization waits might indicate the need to decrease the number of concurrent tasks or use multiple data sets. Also, with a single-phase reorganization, you have the option of not using SYSREC (for a table space reorganization) or SYSUT1 (for an index reorganization) data sets.
This message displays the following performance information about I/O operations to VSAM data sets:
- Processing task number
- Table space partition number
- Number of rows or keys in the partition
- Number of waits issued for I/O completion
- The ddname associated with the I/O operations
Use the ddname to find the actual number of I/Os that were issued to the associated data set. A wait count that is greater than 20 percent of the actual I/Os might indicate degraded performance. Try allowing REORG PLUS more virtual storage if REORG PLUS also issues message BMC50397I. Provide more sort work file space if REORG PLUS also issues message BMC50398I. Changing these values enables REORG PLUS to start more concurrent tasks.
This message displays information that REORG PLUS obtains from the operating system (not the region). The allowedAvailablePages value is the value that you specified for the TOTALPAGEPCT option, and allowedFreePages is the value that you specified for the AVAILPAGEPCT option.
REORG PLUS considers the percentage of available and free pages when determining the maximum amount of memory that is allowed for sort processing. If insufficient memory exists to perform a minimum number of optimal sort processes, the job terminates with a constrained memory message.
No action is required. However, if you experience frequent system memory shortages, if possible, schedule your REORG PLUS jobs during periods of lower system activity.
This message displays the maximum amount of memory and 4-KB pages of hyperspace that the utility allows for each sort task. No action is required.
This message displays buffer information for the log apply process. The initial maximum value is the number of buffers that the utility determined that it needs for each log apply task. No action is required. However, the information displayed in this message can help you tune the performance of the utility.
This message displays the following results of task optimization for unload processing:
- Maximum number of concurrent tasks
- Maximum number of partitions that can be processed per task
- Number of sort work files assigned to each task
- Maximum number of open partitions per task
The maximum number of tasks that REORG PLUS runs depends on the available system resources, such as:
- Virtual storage
- Number of physical CPUs
- Number of unload index work and sort work files
- Sort work file space
REORG PLUS might be able to run more tasks concurrently if you increase the amount of virtual storage and allocate more sort work files.
Based on the size of the partition and available sort work file space, REORG PLUS determines the number of partitions to process per task in order to allow the sort to run in the fastest manner. The actual number of partitions processed per task might be less than the maximum stated in the message.
This message displays the following results of index build task optimization:
- Maximum number of concurrent tasks
- Number of indexes per task
- Number of sort work files assigned to each task
- Maximum number of open index partitions per task
The maximum number of tasks depends on the available system resources, such as
- Virtual storage
- Number of physical CPUs
- Number of unload index work and sort work files
- Sort work file space
REORG PLUS might be able to run more tasks concurrently if you increase the amount of virtual storage and allocate more sort work files.
Based on the number of indexes, work data sets, and sort work file space, REORG PLUS determines the number of indexes to process per task in order to allow the sort to run in the fastest manner.