While posting about the new z13 IBM Redbook last week, I discussed some of the hottest topics in the technology marketplace. It's a certainty that more and more devices will continue to drive up data storage on z Systems.
Posted: June 16, 2015 |
As a follow-on to last week's post about hosted DB2, I'd like to tell you about a new IBM Redbook.
Posted: June 09, 2015 |
Software as a service (SaaS) is a way of delivering applications over the Internet. Rather than hire an in-house staff to install and maintain the software, company developers simply access the tools they need online.
Posted: June 02, 2015 |
When DBAs tune SQL, one of their priorities is to find SQL that invokes sorts, because sorts are expensive.
The statements that typically cause sorts are SELECT DISTINCT and GROUP BY. Other causes of sorts include the use of MAX/MIN aggregate functions and certain non-correlated subqueries (not transformed). The latest DB2 release, DB2 11, is designed to bring improved query performance to applications that use these types of statements.
Posted: May 26, 2015 |
The recent IDUG NA 2015 conference was, in my opinion, the best IDUG event in years. Attendance was way up, and you could feel the energy and excitement during the sessions. Maybe best moment came out of the opening session. When the first-time attendees in the audience were asked to identify themselves, by my count about 30 to 40 hands went up.
Posted: May 19, 2015 |
Last week I wrote about converting simple table spaces to partition by growth (PBG) Universal Table Spaces (UTS). This week I'll share some SQL that can be used in this conversion process.
Posted: May 12, 2015 |
After seeing recent discussions about converting simple or segmented table space to partition-by-growth (PBG) universal table space (UTS) on the DB2 mailing list,. I thought I'd cover this topic. I've previously written about UTS, but it's been awhile. My first UTS post was back in 2007. Then in 2009 I wrote about IBM's migration path to UTS.
Posted: May 05, 2015 |
I was recently asked how to calculate the moving average for a given metric. To be honest, I've only done minimal work with OLAP functions, so I consulted the SQL Reference guide for help. I need to see examples to get an understanding of how things work; unfortunately, those were lacking in the reference guide.
Posted: April 28, 2015 |
In a recent blog post, Denis Tronin discussed DB2 for z/OS performance monitoring.
Denis provides a nice introduction to this topic by examining the different types of trace information. To me, the single most important take-away comes toward the end of the article, when he says: “It is important to understand that traces bring an overhead to your DB2 subsystem, so they should be used wisely.”
Posted: April 21, 2015 |
In writing about the upcoming IDUG DB2 tech conference last week, I noted that the event includes expanded content for developers. This is no isolated occurrence. The IDUG organization has been expanding its focus to include greater education and support for developers (in addition to its traditional audience of DB2 systems programmers and database administrators). With this in mind, I want to mention the "online SQL challenge" that's going on throughout April.
Posted: April 14, 2015 |