3 Areas to Verify When Experiencing DB2 Performance Degradation

When you experience DB2 performance degradation, you’ll discover no one has changed anything (of course), or admits to changing anything. Luckily there are a wide variety of DB2 performance dependencies to check. When DB2 processes are running consistently well, then suddenly the DB2 performance reports show degradation, or users start to complain, there are many . . . → Read More: Three DB2 Performance Areas to Verify When Experiencing DB2 Performance Degradation

Another 5 More DB2 SQL Performance Tips

As I talked about last week, good DB2 SQL performance is vital for efficient processing. I also talked previously about DB2 SQL performance here, . . . → Read More: Another 5 More DB2 SQL Performance Tips

5 More DB2 SQL Performance Tips

Writing good DB2 SQL is always difficult because it is dependent on the database table design and the various table indexes available coming together with the purpose of the processing module, There are many DB2 SQL performance tips to remember and several are documented in my . . . → Read More: 5 More DB2 SQL Performance Tips

3 Critical Storage Performance Architecture Considerations

Architecture matters and storage architecture is being optimized from many different directions to make it faster and cheaper, as detailed in the recent Baron’s article “Tech Vets Vie for New Storage Supremacy.” The article about four companies that are trying to develop the next generation of computing storage to be cheaper from its current $3.00 . . . → Read More: 3 Critical Storage Performance Architecture Considerations

IBM DB2 BLU Best Database I/O Performance

As I talked about database I/O performance the last three weeks here, here, and here, optimizing database I/O performance involves many different factors. When . . . → Read More: IBM DB2 BLU Best Database I/O Performance

Going Deeper into Improving Database I/O Performance

As I talked about last week, and the week before, tuning application and database performance by optimizing database I/O performance involves many different components. When I left off last week I referenced that the physical I/O path components need to . . . → Read More: Going Deeper into Improving Database I/O Performance

3 More Ways to Improve Database I/O Performance

As I talked about last week, the application and database performance involves constantly analyzing different DB2 I/O aspects of your environment. By analyzing the DB2 I/O reports you’ll discover there are many different aspects to examine to optimize your environment, application . . . → Read More: 3 More Ways to Improve Database I/O Performance

Three Ways to Improve DB2 Database I/O Performance

The persistent struggle to improve application and database performance involves constantly analyzing different aspects of your environment, workload, and configuration. There are many different aspects that interact within your environment that impact overall performance. Database and application I/O performance is one of most important aspects to analyze because it can have a tremendous positive and . . . → Read More: Three Ways to Improve DB2 Database I/O Performance

Five More SQL Performance Tips for your Big Data

I have talked about many DB2 SQL performance tips before (10 Performance Guidelines and Five Big Data SQL Performance Tips). Dealing recently with tables with tens of billions of rows and crazy generated SQL from GUI . . . → Read More: Five More SQL Performance Tips for your Big Data

DB2 11 for z/OS Features “Out of the Box” CPU Saving

The official DB2 11 for z/OS general availability announcement was this past week on October 25th. After hearing many detailed presentations at the IDUG European conference and reading through various white papers it looks like IBM has produced another version of DB2 for z/OS that sets the bar for the entire DBMS industry.

There are . . . → Read More: DB2 11 for z/OS Features “Out of the Box” CPU Saving