Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • Dealing with Db2 10-11 Migration Incompatibilities
    09/19/2017
  • Data Compression Enhanced in Db2 12
    09/12/2017
  • A New Utility Stored Procedure
    09/05/2017
  • How to Determine Current Db2 Function Level
    08/30/2017
  • Db2 for z/OS in the Cloud: What's Ahead
    08/21/2017
  • NoSQL and JSON

    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 |

    A Word About Web Account Passwords

    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 |

    More on Safe Access Path Changes

    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 |

    Avoiding Problematic Access Path Changes

    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 |

    Computers You Can Wear

    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 |

    z13 Designed for Cloud, Analytics and More

    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 |

    Hosted DB2

    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 |

    DB2 11 Improves Duplicate Removal in SQL Result Set

    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 |

    A Great Time at IDUG NA 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 |

    Using SQL in a UTS Conversion

    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 |

    Displaying results 111-120 (of 508)
     |<  <  8 - 9 - 10 - 11 - 12 - 13 - 14 - 15 - 16 - 17  >  >|