Optimizing IMS Message Processing Regions via Dynamic Workload Analysis
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
IBM IMS database management systems face inefficiencies in transaction scheduling, leading to delayed transaction execution, high CPU usage, and inefficient allocation of message processing regions (MPRs), resulting in poor response times and resource overallocation or underallocation, which complicates workload management across varying time frames.
Innovation Solution
A computer-implemented method to determine the optimal number of regions in an IMS system by analyzing transaction reports, identifying eligible regions for shutdown, and recommending the optimal number of MPRs based on workload analysis, thereby improving transaction scheduling and resource allocation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If the maximum number of MPRs is allocated to handle peak-time workload, then the system can handle the largest workload during peak hours, but the regions remain idle during off-hours causing resource waste
Solution Approach 1:
The system dynamically adjusts the number of active MPRs based on real-time workload conditions. During peak hours, more regions are activated to handle increased transaction volumes, while during off-hours, fewer regions remain active. This dynamic configuration allows the system to optimize resource utilization across different time periods, preventing both resource waste during low-utilization periods and insufficient capacity during high-demand periods.
2Productivity
If more MPRs are allocated to handle growing transaction volumes, then the system can accommodate increased workload, but the number of regions becomes too large to manage efficiently
Solution Approach 1:
The system consolidates multiple transaction classes into fewer, multi-functional MPRs. Instead of dedicating one region per transaction class, a single MPR can handle multiple different transaction classes sequentially. This universal approach reduces the total number of regions needed while maintaining the ability to handle diverse workloads, thereby reducing management complexity while preserving productivity.
3Productivity
If MPRs are allocated for different time frames, then the system can optimize for specific workload patterns, but uneven allocation causes transaction queuing and performance degradation
Solution Approach 1:
The system merges the workload from multiple time frames into a unified pool of MPRs. Instead of allocating separate regions for different time periods, the same set of MPRs serves multiple time frames by dynamically adjusting their activation and workload assignment. This consolidation eliminates transaction queuing that occurs at boundaries between time-frame allocations, as transactions can be smoothly routed to available regions regardless of time frame transitions.
Data Source
AI summary
System and techniques for determining an optimal number of regions in an IMS system include receiving a transaction report from a log dataset. A first table is generated from the transaction report, where the first table includes a class identified by a class identifier (ID), a number of regions the class is assigned, and a total percent region occupancy by the class. Classes ineligible to be shut down are identified based on a set of criteria and the classes ineligible to be shut down are eliminated. For each remaining class assigned to a threshold number of regions, candidate regions from the threshold number of regions eligible for shut down are identified and remaining regions from the threshold number of regions that can handle a workload from the candidate regions eligible for shut down are identified, where the remaining regions represent the optimal number of regions in the IMS system.