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 . . . → 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, . . . → 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 . . . → 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 . . . → 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 . . . → 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 interfaces has resulted in these five more SQL performance tips for your big data systems. . . . → 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

3 Big Data Disaster Recovery Performance Factors

As I talked recently in my blog “Big Data: 5 Considerations for Disaster Recovery,” Big Data disaster recovery drives companies to intense analysis of the big data usage and its importance. Getting the business to discuss and define the Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Big Data is a . . . → Read More: 3 Big Data Disaster Recovery Performance Factors