1.800.219.7290 / Careers / About Us / Contact Us / Partner Login / Shop Online



Summary


Company Background
Our client is an IT services consulting firm and leading provider of solutions that enable companies to maximize their use of advanced technology. The firm assisted a government agency in selecting software and overseeing their ability to process information more quickly and easily, increasing operational efficiencies.

Challenges and Requirements
The volume of data being handled by the government agency’s operating system is immense. In addition to managing over six million claims per week, the agency also keeps two years of claim details in an active database. Maintaining these active claims allows for evaluation and validation of new claims within seconds.

The three-terabyte DB2 mainframe database application feeds into a data warehouse critical to the overall operations of the organization. Monthly and weekly updates from the central data warehouse are distributed to data marts maintained on-site at five remote locations. The source data for each data mart update is moved from the database and into the z/OS environment for transmission management.

Each update can fill as many as four 20-gigabyte IBM® 3590 tape cartridges. That data must be transmitted via FTP within a 12-hour operational window. Even with high speed OC3 connections, transmitting as much as 80 gigabytes of data to each of the five endpoints within the required timeframe is impossible.

The Solution - PKZIP Enterprise Edition
The consulting firm turned to PKZIP for zSeries® Enterprise Edition to compress data before distributing it to the various data marts. The agency’s update application now takes the data written to the tape cartridges and compresses them with PKZIP before transmission. Ultimately, the consulting firm chose PKZIP because of the outstanding results it delivered when used in other projects.

The agency also incorporates critical information from third party providers. An update from a provider frequently includes as many as 160 files compressed and contained in a single ZIP archive each month. This is then written to CD and sent to the consulting firm. There, the ZIP archive is transferred to the mainframe where PKZIP automatically translates the data format from ASCII to EBCDIC during the decompression and extraction process.

“PKZIP compresses the data at least 75% and frequently as high as 90-95%,” according to an Operations Analyst. “Consequently, data mart updates that may have been as large as 80 gigabytes are compressed to as little as 4 gigabytes. We wouldn’t be able to complete transmissions within the operational window without the use of PKZIP. It works with the original ASCII-oriented file names and renames them to a DSN (Data Set Name) appropriate for the mainframe during extraction—it has good flexibility.”





Related Stories