4 Reasons to Consolidate Databases to DB2 LUW

As year-end budgets get finalized, and 2015 is planned out, you might want to reconsider your plans and look to consolidate any other database vendors into DB2 LUW. Substituting database vendors within projects is not the huge task it once was because of standard SQL, SQL PL, stored procedures, and other data access object layers . . . → Read More: 4 Reasons to Consolidate Databases to DB2 LUW

3 Game-Changing IBM DB2 pureScale Enhancements

Another set of great INSIGHT announcements that were somewhat drowned out by all the Watson hoopla were all the enhancements that are happening with DB2 pureScale. For those unfamiliar with DB2 pureScale, it is the multi-node cluster configuration providing the industry’s best scalability, performance, and data availability of any DBMS company offering today. Since DB2 . . . → Read More: 3 Game-Changing IBM DB2 pureScale Enhancements

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, here, and here describing the many attributes that can impact and improve DB2 SQL performance. Fortunately all of these blogs combined . . . → 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 DB2 SQL performance tips blogs here, here, . . . → 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 I left off last week I talked about the parameters for pinning your popular objects into DB2’s buffer pools to . . . → 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 be tracked back through the FICON channels, the storage device cache and then . . . → 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 workload, and processing. The following . . . → 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