Pennsylvania Department of Transportation keeps construction costs down

IBM Information Management software helps engineers deliver critical information ahead of schedule

Published on 19-Dec-2012

"The IBM software makes a significant difference in our ability to deliver updates ahead of schedule. The improvements reduce the risk of noncompliance and help our internal and external users get the information they need, when they need it." - Gregory S. Gelnett, Operations Division Chief, Bureau of Infrastructure and Operations, Pennsylvania Department of Transportation

Customer:
Pennsylvania Department of Transportation

Industry:
Government

Deployment country:
United States

Solution:
System z Software

Overview

The Pennsylvania Department of Transportation (PennDOT) is a state - government agency responsible for the planning, design, construction and maintenance of the state’s multimodal transportation system. The department directly manages nearly 40,000 miles of roads and highways, including approximately 25,000 bridges. It also registers and licenses more than 11 million motor vehicles and nearly 9 million drivers. In addition, PennDOT oversees and supports other modes of transportation, helping maintain airports, railways, mass-transit systems and statewide shipping.

Business need:
With growing response times in a system that provides functions related to advertising and contracting for design and construction related work, PennDOT risked bid process delays.

Solution:
IBM DB2 Query Monitor for z/OS and IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS software optimize CPU usage and slash application response times.

Benefits:
PennDOT saved 100 hours a week in manual labor, reduced CPU usage by 19 percent and helped enable timely updates to keep projects on schedule.

Case Study

The Pennsylvania Department of Transportation (PennDOT) is a state - government agency responsible for the planning, design, construction and maintenance of the state’s multimodal transportation system. The department directly manages nearly 40,000 miles of roads and highways, including approximately 25,000 bridges. It also registers and licenses more than 11 million motor vehicles and nearly 9 million drivers. In addition, PennDOT oversees and supports other modes of transportation, helping maintain airports, railways, mass-transit systems and statewide shipping. Headquartered in Harrisburg, PennDOT employs approximately 13,000 people and operates with a budget of USD6 billion.

Challenge
PennDOT runs an Engineering and Construction Management System (ECMS) that supports web - based delivery of information on its construction projects and related contracts and agreements. Because construction and safety engineers use this information to make key project decisions, federal and state laws mandate that PennDOT keep up to date at all times. However, the construction management system consumed 5 percent to 10 percent more CPU resources each year. Under this growth, dynamic and static queries in the supporting database took more and more time, and Non-Mission Critical activities had to be suspended to allow the ECMS Bid Opening process to complete on time. The PennDOT IT team’s manual efforts to alleviate the problems weren’t fast enough to prevent slow application response times in ECMS. To mitigate the risk of project delays, PennDOT sought a more efficient way to improve application performance.

Solution
Working with IBM, PennDOT integrated two IBM Information Management software solutions with the department’s existing IBM® DB2® data server software. PennDOT uses IBM DB2 Query Monitor for z/OS® software to identify long - running queries and efficiently customize and tune SQL workloads. IBM InfoSphere® Optim™ Query Workload Tuner for DB2 for z/OS software generates recommendations to database administrators and developers to help fine - tune query workloads for optimized performance. In addition to refining existing queries, PennDOT runs all new queries through the IBM tools before using the code in production.

Within one year of implementing the IBM software, PennDOT significantly reduced the ECMS CPU usage rate while improving its performance. “ECMS is no longer our biggest consumer of computing resources,”says Greg Gelnett, Operations Division Chief, Bureau of Infrastructure and Operations. “Using the DB2 and InfoSphere software, our database administrators have transformed the application into a lean, high-performance system. And they’ve saved a lot of time for themselves, thanks to the efficiency of the IBM tools.”

Even more important, the improved performance helps PennDOT satisfy its service level agreements (SLAs) for application availability and information updates. “The query tuning with the IBM software makes a significant difference in our ability to deliver updates ahead of schedule,” says Gelnett. “The improvements reduce the risk of noncompliance and help our internal and external users get the information they need, when they need it. As a result, we can keep construction projects across the state moving forward as planned.”

Benefits
• Saved more than 100 hours a week in manual diagnostics and remedies
• Reduced the portion of total CPU resources consumed by ECMS from 35 percent to 16 percent
• Improved overall system performance, supporting SLAs and regulatory compliance
• Decreased downtime and associated costs by eliminating manual labor

For more information
To learn more about IBM Information Management solutions, please contact your IBM marketing representative or IBM Business Partner, or visit the following website: ibm.com/software/systemz

Products and services used

IBM products and services that were used in this case study.

Hardware:
System z

Software:
DB2 Query Monitor for z/OS, InfoSphere Optim Query Workload Tuner for DB2 for z/OS

Legal Information

© Copyright IBM Corporation 2013 IBM Corporation Software Group Route 100 Somers, NY 10589 Produced in the United States of America April 2013 IBM, the IBM logo, ibm.com, DB2, InfoSphere, Optim and z/OS are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml. This document is current as of the initial date of publication and may be changed by IBM at any time. Not all offerings are available in every country in which IBM operates. The performance data discussed herein is presented as derived under specific operating conditions. Actual results may vary. THE INFORMATION IN THIS DOCUMENT IS PROVIDED “AS IS” WITHOUT ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING WITHOUT ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND ANY WARRANTY OR CONDITION OF NONINFRINGEMENT. IBM products are warranted according to the terms and conditions of the agreements under which they are provided. The client is responsible for ensuring compliance with laws and regulations applicable to it. IBM does not provide legal advice or represent or warrant that its services or products will ensure that the client is in compliance with any law or regulation.