Toronto Police Services
In 2007 MSS responded to the RFP issued by Toronto Police Service to move the CASC system from Unisys Libra mainframe to AIX Unix.
MSS International won the bid with a proposal based on the migrate!LINC and migrate!COBOL tools. The fully automated modernization approach was not only the lowest cost but also lowest risk approach.
MSS performed the core modernization - LINC and COBOL to Java (J2EE), DMSII toDB2 - with Toronto Police staff testing the resulting code.
The DMSII databases were ported to DB2 and standard database development tools already in use at TPS were used. The modernization project took 9 months and involved a team of Toronto Police staff of up to 4.
The migrate!LINC toolset was used to automatically modernize the Linc screen presentation to JSP supported by MSS’s webmanager software with business logic implemented as Java EJBs. For the batch system, freestanding Java programs, each running in its own JVM, were generated.
migrate!COBOL was used to convert the Cobol system to Java for compatibility with the modernized Linc. The resulting code was virtually line-for-line with none of the ‘bloat’ usually associated with such conversions. The new code is structured so as to be easily understood and maintained by the original programmers with minimal retraining in java, and has been well-received by the developers.
Both the Linc and Cobol systems were moderate scale – the Linc system consisted of 120 ispecs (screen layouts) and 60 reports (batch programs) and the Cobol system totalled 100,000 lines of code. Additionally 120 WFL job control programs were modernized, using migrate!WFL, to shell scripts and these were controlled by a schedules run by standard system software (cron).
The Cobol system was the first live implementation of the Java migration path for the migrate! COBOL software and required significant R&D during the project.
The database definition and data had to be modernized to a format consistent with TPS internal standards for database usage. To do this the MSS migrate!DATA was enhanced to incorporate the required customizations of the generated schemas that replace the original DMSII DASDL. migrate! DATA then also generated corresponding extract and load routines for the data.
The job control programs were complex and time-driven – effectively a scheduling system built in WFL. This was replaced by a fully functional equivalent comprising scripts, generated using the MSS migrateWFL tool, and cron tables to drive the schedule.
During the project, the stringent security requirements of the Police Service had to be respected, and the core modernization was done remotely in a “hands-off” manner. The team evolved ways of working that complemented the TPS project staff and made the task as efficient as possible.
The modernized project was completed in 9 months and went live in May 2008. The implementation was deemed to be very smooth, with minimal impact and with the online user-base (up to 6000 with 80 concurrent users on average) barely affected. Using the well-proven migrate!LINC product and the newer migrate!COBOL (Java) technology, the actual modernization was accomplished in 3 months with the remaining 6 months used in testing and integration activities.
This is an achievement considering the changes involved: Linc modernized to Java, Cobol modernized to Java, WFL to shell script, scheduling system to crontab, DMSII database to DB2, COMS replaced by WebSphere and the underlying MCP platform replaced with a standard AIX (IBM p Series) system. It was noticed straight away that performance in certain areas, especially the batch work, was substantially improved while the costs had diminished. Toronto Police are now experiencing significant savings in support costs and direct on-going IT costs. They have a more productive system than before and are well-positioned for future development.