Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Subsystem Parameter Changes in DB2 12
  • New and Changed Subsystem Parameters in DB2 11
  • MERGE Statement Enhancements in DB2 12
  • DB2 12 Technical Workshops
  • DB2 Tools Fix Lists
  • Using Autonomous Procedures

    DB2 11 introduced autonomous procedures, which give a called stored procedure the capability to COMMIT its work without committing the work in the calling program. Why would you need this? Let's consider one scenario where this feature would be useful.

    Read More

    Posted: September 22, 2015 |

    The Future in Three Words: Cloud, Web, Mobile

    Since this spring's IDUG conference, I've written extensively about the future of IBM z Systems and DB2, and specifically the new capabilities that are enabling the mainframe to serve as a development platform for cloud, web and mobile applications.

    Read More

    Posted: September 15, 2015 |

    IBM Unveils the Linux-Only Mainframe

    IBM's recent announcement of the LinuxONE family is another milestone in the mainframe's long-term support of Linux. While I encourage you to read the IBM Systems Magazine overview, I'll briefly cover the highlights here.

    Read More

    Posted: September 08, 2015 |

    Developing Mobile Applications on z/OS and DB2

    As I was researching options for developing mobile applications that access data stored on z/OS -- and specifically, data in DB2 -- I discovered an IBM development platform with which I was unfamiliar. Read about the IBM MobileFirst Platform Foundation Developer Edition:

    Read More

    Posted: September 01, 2015 |

    Physical Data Modeling Using IBM Data Studio

    I haven't written about IBM Data Studio in awhile, so I thought I'd dig into the latest version. In addition to downloading version 4.1.1, I also downloaded the current version of DB2 Express-C (V10.5) so I could have a working database.

    Read More

    Posted: August 25, 2015 |

    A Look at NoSQL and Where It's Headed

    I first heard about NoSQL at an IDUG NA conference a few years ago. At the time, I wondered how DBAs using DB2 would benefit from it. However, now that DB2 supports NoSQL databases, its importance is apparent.

    Read More

    Posted: August 18, 2015 |

    A Brief History of Autonomics and DB2 for z/OS

    While "autonomic computing" may sound like a futuristic term, it's been around awhile -- at least as it relates to DB2. IBM has supported autonomic function in DB2 for z/OS since the release of Version 9 in 2007.

    Read More

    Posted: August 11, 2015 |

    DB2 11 OSE Enhancements

    For customers that support very large tables and require 24 X 7 availability, the capability to change the definition of a table without having to drop it or take an outage is critical. Recreating tables and reloading data represents a huge cost, in terms of both money and lost uptime.

    Read More

    Posted: August 04, 2015 |

    DB2 11 for z/OS Accelerator Only Table

    IBM continues to make improvements to its DB2 Analytics Accelerator at, yes, an accelerating rate. The company releases new features through its maintenance stream.

    Read More

    Posted: July 21, 2015 |

    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 |

    Displaying results 91-100 (of 497)
     |<  <  6 - 7 - 8 - 9 - 10 - 11 - 12 - 13 - 14 - 15  >  >|