YL&A's consulting services are among the highest-rated in the country.
We have worked with many clients, ranging from government agencies to Fortune 500 companies.


Database Design and Development

Can your company benefit from getting more information from your database? Are your departments not sharing information that is critical to the performance of your company? Then YL&A is the solution for you.

We strive to build the most efficient database systems for our clients. Many of our consultants are responsible for building some of the world's largest databases and data warehouses. Our database expertise includes DB2 (all platforms), Oracle, SQL Server, Sybase, Informix, mySQL, FoxPro and Access. We can build a database from scratch, administer an existing database, re-design an existing database, or migrate your current database to a different database.


Database Performance Audits and Tuning

Do you want to improve the performance of your database? Do you want to get the maximum potential from your database? Then YL&A is the solution for you.

Often applications are put into production and do not meet the performance expectations we know DB2 can deliver. The most common reason for this is lack of system performance tuning and poor application or database design.

YL&A can provide you a with a Performance Audit of your current DB2 subsystem and application. If we find a performance issue, we can help you determine the root of the issue and how to go about resolving it. We not only provide detailed reports on our audits but show you how to perform the audit yourself.


Version 8 Migration

YL&A now offers a service to formally help customers migrate to DB2 z/OS Version 8. This migration plan has been developed from experience with customers who have already migrated to V8. We can help develop customized test plans for the various modes of migration and prepare you for what is new (via formal classes and/or informal knowledge transfer). We can also help plan testing to best utilize V8 and avoid any unexpected surprises. This release migration is very different and important to properly test - be prepared and let us assist you in making the transition a success.


Legacy Migration

YL&A can help you migrate to DB2 z/OS Version 8 from your legacy system. Developed from experience, we can customize test plans for the various modes of migration and prepare you for what is new (via formal classes and/or informal knowledge transfer). We can also help plan testing to best utilize V8 and avoid any unexpected surprises.


| Home | Education | Consulting | Performance | V8 & V9 | Legacy Migrations | Design | Development | DB2 Experts | Contact |



©1997-2008 YL&A

IBM is a registered trademark of International Business Machines Incorporated
DB2 is a registered trademark of International Business Machines Incorporated