Do you want to improve the performance of your database? Do you want to get the maximum potential from your database? Are you staring at an SLA problem, or a potential system upgrade? 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, SQL, or database design.

YL&A can provide you 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 also show you how to perform the audit yourself. We have performed performance audits for some of the largest DB2 customers in the United States, as well as Europe. With each of these performance audits we draw on our vast real world practical experience to give each customer a simple and practical approach to solving their problem. In every single performance audit we’ve performed, we have delivered solutions that saved millions!

A YL&A performance audit, depending upon your needs, consists of a three to five day onsite visit by one or two consultants. The onsite visit is followed with a report detailing the performance issues, and making recommendations to resolve the performance issues. This includes, but is not limited to; system changes, installation parameter changes, DASD configuration changes, database design changes, SQL changes, and application program code changes. Enough detail is provided to allow your staff to perform the changes. While we are available to help you implement the changes, our goal is not to sell you more services. The goal is instead to give you exactly what you ask for…recommendations to save considerable money and meet performance objectives, and enough education for you to make the changes yourself. This gives us no ulterior motives! We don’t want to sell you anything else! We will tell you the truth and then we’ll go away.

We can do DB2 performance audits for DB2 for z/OS and DB2 for LUW implementations. In any situation, we can save you time and money. No long term contracts, no sales pitch, just a solution. References are available upon request, and most of them are familiar names that you are buying products and services from every day!