CapWIN Maintains Critical System Uptime Through Rearchitecture

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.