Select Page

Webinar: Building a Performance Centric Organization

Author: Craig Mullins | 3 min read | November 11, 2013

Database performance problems are not caused by magic. Indeed, all performance problems are always caused by change. That statement flies in the face of what I normally say, which is “Almost never say always or never”… but in this case, it is true.

Think about it for a moment. If everything remains stable and unchanging in your environment, then why would performance vary? That’s right, it wouldn’t.

Something tangible must change before a performance problem can be experienced. The challenge of performance tuning is to find the source of the change, gauge its impact, and formulate a solution. Change can take many forms – environmental, system, database, application – but regardless of the type of change, if it impacts CPU usage, I/O requests or concurrent data access it can have a significant impact on performance.

But perhaps even more important than reacting to change is to build a performance-centric development organization where you focus on how things will perform early in the application development process. After all, designing an application that accesses hundreds of rows is simple, but many production applications access thousands or even millions of rows of DB2 data. An up-front approach to supporting such volume can reduce the back-end changes required to retrofit applications once they have been migrated to production.

Although the majority of your performance problems are likely to be application-oriented, you must be prepared to explore all other areas when application tuning has little effect. Things like database reorganization, tuning memory usage and setting appropriate system parameters all contribute to the overall performance of your DB2 applications.

With all of that in mind, a best practices approach to DB2 development and performance is required to assure an optimal result. If you are interested in learning about DB2 performance best practices, be sure to attend my upcoming webinar, sponsored by Datavail, titled Best Practices for Optimizing DB2 Performance. Register today for the webinar which is being held on Thursday, November 14th, at 10 a.m. MST.

The presentation will discuss DB2 performance tuning and management from a best practices perspective, outlining the issues involved in maintaining efficient DB2 applications, databases, and subsystems. Along the way, I will go over a variety of guidelines and tips for achieving optimal performance in a DB2 for z/OS environment.

What better use can you make of an hour out of your day to learn techniques for developing, monitoring and tuning DB2 applications, databases, and systems with performance in mind?

See you there!

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

Oracle RMAN Backup and Recovery with Restore Points

Oracle restore points are useful for benchmark testing. Find out how you can use Oracle’s Recovery Manager (RMAN) tool to create and use restore points.

Cindy Putnam | May 3, 2019

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.