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

Big Data: 5 Considerations for Disaster Recovery

Big Data drives the issue of disaster recovery to the front of the discussion. How critical or how much benefit your Big Data business application is to the bottom line of the business is directly proportionate to your Big Data disaster recovery planning efforts. The following five considerations will help your evaluation of the data . . . → Read More: Big Data: 5 Considerations for Disaster Recovery

DB2 Performance Tuning Your DBA Staff

As a consultant over the years, I have seen the characteristics of a number of shops and discovered there are many different ways to develop, support, and get the best DB2 performance tuning out of a variety of situations. I believe the most important component of successful DB2 performance is the people, especially the DBAs. . . . → Read More: DB2 Performance Tuning Your DBA Staff

Big Data: Big Lies, Big Damn Lies and Statistics

Setting up the correct metrics is vital for measuring anything. Mean, median and a variety of other complex formulas are being used for an assortment of purposes in Big Data projects. The heart of the issue is whether these complex formulas correctly convey correct measurements for the particular situation.

For example the simple mean . . . → Read More: Big Data: Big Lies, Big Damn Lies and Statistics

DB2 10.5 Upgrade - 10 Reasons to Implement immediately!

The International DB2 User Group (IDUG) North American conference is always full of great DB2 Family presentations. I try to go through all of them because they are always full of great ideas, best practices, hints and tips. I guess that’s why IDUG celebrated both DB2 for z/OS’ 30-year anniversary and its own 25-year anniversary.

. . . → Read More: DB2 10.5 Upgrade – 10 Reasons to Implement immediately!

DB2 SQL Tips: 10 Performance Guidelines

Recently I discussed DB2 SQL tips that have provided application performance for decades with my clients’ SQL developers. These DB2 SQL tips provide developers with performance guidelines that can help their application designs and SQL coding get the best performance the first time.

Since clients have many different DB2 SQL tips, I’ve listed below 10 . . . → Read More: DB2 SQL Tips: 10 Performance Guidelines

Big Data after the IOD Conference Thoughts

As I get ready to travel to IDUG Berlin I look back at the Information on Demand (IOD) conference and remember the importance of all the components that enabled the conference theme, Big Data Analytics.

The first components are the front-end products Cognos and the new QMF. While sharing a cab to the airport . . . → Read More: Big Data after the IOD Conference Thoughts

DB2 10 Rocks Big Data

It was a good Information on Demand conference with Information Management, Business Analytics and Big Data taking their turns as the most important subject. Even the thoughts I mentioned in last week’s blog about management by magazine indicated by the latest Harvard Business Review cover story on big data and an interior article describing the . . . → Read More: DB2 10 Rocks Big Data