Case study

Optimizing Workforce Analytics With IBM® Db2 Query Monitor for z/OS® 

A global HR solutions provider improved payroll accuracy and employee satisfaction by streamlining workflows and leveraging real-time analytics with IBM Db2 Query Monitor and IBM Db2 Query Management Facility (QMF). Here’s how IBM Db2 Query Monitor for z/OS helped. 

Challenge

Overburdened teams faced significant performance issues managing 30-plus infrastructure subsystems, which led to delays and inefficiencies in operations. 

Solution

The company implemented IBM Db2 Query Monitor and QMF for z/OS, providing advanced analytics and streamlined issue resolution to enhance system performance and data visibility. 

Results

Reduced resolution times, improved data access for 400-plus users, and accelerated digital transformation efforts. All this drove greater operational efficiency and employee satisfaction. 

With the help of these modern IBM solutions on ‘legacy systems,’ this human-resource solutions provider can anticipate the needs of their clients as they support the continuous operation of important services like payroll and benefits payments that employees everywhere count on."

Saghi Amirsoleymani VP IBM zSystems Business Unit Rocket Software

Company

Industry: IT Consultancy and Managed Services 

A global HR solutions provider servicing small businesses, Fortune 500 companies, and everything in between. With clients in over 100 countries, they ensure timely and accurate payroll and benefits payments. 

Challenge

Maintaining essential employee services like payroll faced hurdles due to limited staffing and increasing system complexities. 

The HR provider relied on over 30 Db2 subsystems supported by a small team of database administrators. Without specialized tools, the team couldn’t proactively manage database performance. They were vulnerable to delays that could impact payroll and benefits payments globally. 

 

Solution

IBM Db2 Query Monitor and QMF for z/OS revolutionized how the provider managed database performance, queries, and analytics. 

To address performance bottlenecks, the provider implemented IBM Db2 Query Monitor, which identifies underperforming queries and recommends optimizations. Coupled with IBM QMF, a real-time analytics platform, the company gained better data visibility and improved operational efficiency. Over 400 employees utilized QMF dashboards across multiple departments —from payroll to application development — and the organization transformed its workflows and reduced time-to-insights.

Results

Achieved improved service delivery, real-time operational visibility, and significantly faster issue resolution.

The implementation led to a significant reduction in query resolution times from several days to less than one, along with enhanced performance monitoring that enabled proactive query and index improvements. Real-time database performance dashboards allowed over 400 team members to collaboratively monitor key metrics, supporting digital transformation goals and enabling secure hybrid cloud deployment for future scalability. 

Downloads

Related content

Secure Host Access

U.S. Insurance Company: Streamlining Security Practices

U.S. Insurance Company: Streamlining Security Practices
Visual COBOL®

Modernizing a Major Distribution Network

Modernizing a Major Distribution Network
Visual COBOL®

U.S. County Government: Transforming Heritage Systems with Rocket® Visual COBOL®

U.S. County Government
U.S. County Government: Transforming Heritage Systems with Rocket® Visual COBOL®
See all case studies