I've been doing some reading about NoSQL and how DB2 for z/OS will support it. This 2014 article examines the relationship between NoSQL and DB2 Java Scriipt Object Notation (JSON), and predicts that relational databases will begin to support JSON. This IBM Information APAR lists APARs to be applied to DB2 10 for z/OS in support of using JSON. Finally, I came across this great IBM developerWorks white paper about determining whether JSON or XML is right for a given task.
Read More
Posted: July 14, 2015 |
Recently I was talking with my brother about the best way to store account user IDs and passwords. I trust my brother’s advice on this topic because at one point in his career he was a white-hat hacker.
Read More
Posted: July 07, 2015 |
Last week I discussed some parameters that are designed to prevent poor access path changes following a REBIND. As a follow-up, I want to tell you about another new feature introduced in DB2 11 that allows you to not only see current access paths, but determine if a new REBIND will introduce a poor access path change.
Read More
Posted: June 30, 2015 |
This message, with the subject “application performance issues,” was recently posted to the DB2 listserv.
The gist of it is that an application that once took only a few minutes to run now requires more than 70 minutes to process. The application previously used three indexes, but after the rebind it doesn't. So what's the problem?
Read More
Posted: June 23, 2015 |
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
Posted: May 12, 2015 |