San Jose, Calif. —
The purpose of the project was to use a standard automated method to identify and change the field definition and length of 69 different DB2 columns (including policy number, street names, form numbers and status codes) across multiple databases in the Progressive enterprise.
ATERAS used DB-Shuttle Enterprise Change technology to collect and analyze 11,186,985 lines of code. During the analysis, DB-Shuttle identified 41,431 lines of code impacted by the changes and identified 2,827 possible lines of code to change. DB-Shuttle generated the required change rules and applied them to 1,993 programs and copybooks, including changes required within the logic for handling numeric to alphanumeric changes. The modified programs were delivered to the Progressive teams ready for installation and testing. All modifications were migrated to production on April 26, 2008.
Enterprise Field Change Manager identifies every line of code that might be affected by the required change. Recommendations on the required code changes also are made automatically. The tool also can determine additional “watch fields” as data moves between fields and programs. DB-Shuttle generates the change rules to make all the source code changes. Once the changes are accepted, the rules are automatically applied, and the revised application code is generated ready for testing.
The automated process that Enterprise Field Change Manager offers allowed Progressive to continue with production changes throughout the testing phase. New production changes were collected each month, and the change manager analysis repeated with the new code, then the deltas were delivered to Progressive.
Source: ATERAS
