The client’s lottery system was in need of database conversion and restructuring. M&R’s DB2 experts assisted with developing Conceptual/Physical data models, data tuning and database administration for 12 TB of data. Tuned the Database by distributing data on DMS raw logical volumes, SMS file system, setting DB, DBM configurations.

Improved the query access time for 400 million records from 30 min to 6 minutes.