A database rearchitecture solved an issue that could have brought down mission-critical systems for first responders.
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.
get better software support for your business
See how much you could save by switching to Origina
Outstanding Cognos support helps company migrate to align with strategic initiatives – and save 50% on IBM support costs
A quick response and resolution mitigates prolonged downtime for critical employee and customer applications. Read our case study to learn more
A telecommunication company received priority one assistance for a technical issue within its testing environment. Read our case study to learn more.