CapWIN Maintains Critical System Uptime Through Rearchitecture
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
THE RESULT
get better software support for your business
See how much you could save by switching to Origina
More case studies
IBM Cognos Lifecycle Extended to Give a Bold I.T. Roadmap a Boost
Outstanding Cognos support helps company migrate to align with strategic initiatives – and save 50% on IBM support costs
ISAM® Certificate Issue Found and Fixes to Restore App Uptime Fast
A quick response and resolution mitigates prolonged downtime for critical employee and customer applications. Read our case study to learn more
Telecommunication Company’s P4 Issues Resolved at a P1 Pace
A telecommunication company received priority one assistance for a technical issue within its testing environment. Read our case study to learn more.