A database rearchitecture solved an issue that could have brought down mission-critical systems for first responders.
THE PROBLEM
CapWIN’s software provides first responders with access to multiple data sources on-demand supporting law enforcement queries and real-time transportation incident information via a secure networking environment. Geographical Information System maps are transmitted to users on various devices, which guide parties to emergency locations when the associated services are requested. These data sources and locations are also analyzed by CapWIN on a regular basis and sent to each state agency, allowing them to ensure their operations continue to run smoothly and to prepare for upcoming events.
CapWIN was experiencing some issues with its Db2 Replication server. The problem caused outages and slowdowns in replicating data from its main Db2 database to its Db2 for Linux, Unix and Windows (LUW) reporting database. The Db2 reporting warehouse generates the various reports needed by the different state departments served by CapWIN.
Due to the growth in data and usage over time, the Replication server became overloaded and was running at below optimal speed. This caused the recurring data replication process to slow down, as well as the volume of data being replicated to significantly decrease. To combat the issue, the CapWIN technical team had to replicate the data through a manual process. This workaround meant that the reports could continue to be published intermittently, however it was not sustainable for more than a few days. If the replications were to halt or be delayed for any duration, it could have a detrimental effect on any of the department’s operations.
Fortunately, CapWIN’s senior engineer observed the issue right away and, in understanding its criticality, he reached out to Origina for immediate support.
CUSTOMER PROFILE
ABOUT
INDUSTRY:
Education
COMPANY SIZE:
Small
LOCATION:
USA
PRODUCT:
Db2
THE SOLUTION
Origina’s independent Global IBM Expert with over 27 years of experience with Db2 immediately got on a call with the CapWIN team to help it find and resolve the issue. Origina’s Global IBM® expert reviewed CapWIN’s log files and helped them locate the issue.
It was identified that due to the continuously large increase in the volume of data, the LUX environment was unable to run at its optimal level and needed to be rearchitected. Luckily, due to the vast experience of Origina’s independent Global IBM Expert a fix was found. The solution ensured that operations continued to run smoothly whilst the environment was being re-architected by the CapWIN team.
THE RESULT
get better software support for your business
See how much you could save by switching to Origina
More case studies
IBM® Domino Security: Global Consultant Avoids Massive 80,000-User Upgrade
The best business partners don’t just react – they advise, even if it has the potential to ruffle feathers. Learn how we helped a leading global consultancy avoid upgrading 80,000 Domino users.
Sporting Goods Chain Conquers Retail Peak Season with Origina’s On-Point Software Maintenance Advice
It’s the most wonderful time of the year for retailers, but also the most stressful and most difficult to plan for. Here’s how Origina helped a leader in the sporting goods space keep their IBM estate stable during huge holiday projected activity spikes. Learn more in this case study.
Disneyland Paris Gains Innovation and Long-Term Support from Multiyear Migration Project
With 35 IBM® software products being phased out and several questions regarding next steps, Disneyland Paris turned to Origina to help bring clarity to the IT roadmap – and saved millions. Discover their path in this case study.