Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • A Happy 10 Years
    07/18/2017
  • Db2: A Small but Significant Change
    07/11/2017
  • Subsystem Parameter Changes in DB2 12
    06/27/2017
  • New and Changed Subsystem Parameters in DB2 11
    06/20/2017
  • MERGE Statement Enhancements in DB2 12
    06/13/2017
  • An Intro to IBM Data Server Manager

    In March IBM announced IBM Data Server Manager. I find this product interesting because, in contrast to the Windows/Eclipse-based Data Studio, Data Server Manager is a browser-based tool for managing and optimizing the performance of IBM DB2 for Linux, UNIX and Windows databases.

    Read More

    Posted: October 06, 2015 |

    Column Masking With Fewer Restrictions

    For at least as long as there's been a public Internet, there's been a need to mask sensitive personal data. Of course many different software solutions are available in the market today, including IBM's built-in column masking feature that was introduced with DB2 10 for z/OS.

    Read More

    Posted: September 29, 2015 |

    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 |

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