VIRTUAL-DBA: LAWSON APPLICATION TO DB2®

ORGANIZATION

Large manufacturer turns to XTIVIA’s Virtual-DBA to migrate from Lawson application to DB2®

CHALLENGE

Following Lawson’s announcement that it would no longer support Informix® with the 8.1 release of the Lawson environment, a large packaging manufacturer sought our help to migrate their Lawson application database platform from Informix to DB2® LUW on AIX.

SOLUTION

The company had been an XTIVIA client for more than four years when the need to migrate arose. Our team of Informix Database Administrators had been providing broad operational support, maintenance, tuning, troubleshooting, mentoring and consulting services. This long-standing relationship made XTIVIA the natural choice to help guide them through their database migration to DB2.

Our Virtual-DBA IBM Certified DB2 administrators supervised the migration. We provided the client with DB2 architectural and configuration recommendations based on IBM Best Practices. We worked closely with Lawson consultants to create the new DB2 databases and to execute database scripts provided by Lawson to build tables in the new databases. XTIVIA also worked closely with the client’s Lawson application development team to complete tasks such as table export and import, database backups, the refresh of data into development systems and enabling database connectivity and security. XTIVIA’s DB2 experts also provided scripts to automate nightly database backups and critical weekly maintenance utilities.

Through the monitoring feature of our Virtual-DBA services, XTIVIA has implemented monitoring of key DB2 metrics allowing proactive optimization of database operations rather than simply reactive responses to service interruptions and performance problems. The Virtual-DBA client portal allows this customer to track these metrics and their trends while also reviewing the case history associated with the actions performed by the XTIVIA support team.

 

RESULTS

The migration complete, the company continues to utilize XTIVIA’s Virtual-DBA services to augment its team and provide 24×7 monitoring and support.

KEY COMPONENTS

SOFTWARE

Application: Lawson

Source Database Informix®

Target Database DB2® LUW

OS AIX

SERVICES

Database Migration

Ongoing Managed Service

Download the Case Study PDF here