Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • DB2 12 Pending Column Alterations
    03/28/2017
  • Using Installation SYSOPR Authority
    03/21/2017
  • Converting DBRMs to Packages in DB2 12
    03/14/2017
  • DB2 12 Enhancements to System Profiles
    03/07/2017
  • DB2 12 Active Logs Greater than 4 GB
    02/28/2017
  • Setting Special Registers Using Profiles

    DB2 11 introduced a powerful feature that allows you to set special registers for remote applications by creating a profile in the profile tables. Information on the install jobs used to create these tables, as well as rules for inserting rows into the tables, can be found in the DB2 Administration Guide or the IBM Knowledge Center.

    Read More

    Posted: August 23, 2016 |

    How DSN1COPY Improves Data Validation

    DSN1COPY is a high-performance copy utility that should have a place in every DBA's toolbox.
    DBAs love using DSN1COPY because it quickly copies files from one system to another. You just need to be careful about how to use it. Test out the process and make sure you understand the impact database changes have on your test system and production systems.

    Read More

    Posted: August 16, 2016 |

    Data Studio Tools Included in Data Server Manager 2.1

    In January I wrote about IBM Data Server Manager, noting that the packaging and delivery of features is different for z/OS than it is for other supported platforms. Now that the latest version, Data Server Manager 2.1, is available, I want to get back to this.

    Read More

    Posted: August 09, 2016 |

    Controlling DDF Threads using Profiles

    Recently I wrote about IBM's strategy to move customers from DB2 Connect Gateway to DB2 Connect Client. The customers I've heard from aren't happy with this development.

    Read More

    Posted: August 02, 2016 |

    Why You Should Move to Universal Table Space

    Almost six years ago, I wrote that the future for all DB2 data storage on z/OS will be Universal Table Space (UTS). The purpose of this post isn't to pat myself on the back, but to note that the future is here.

    Read More

    Posted: July 26, 2016 |

    Spark Takes Data Analysis to the Next Level

    I must admit that, until very recently, I'd never heard of Spark. But since it was such a big deal at this spring's IDUG NA conference --  an entire day was devoted to it -- I figured I should take some time and learn about it.

    Read More

    Posted: July 19, 2016 |

    RESTful APIs Unlock the Value of z/OS Assets

    If you work on the mainframe using z/OS and haven't heard of RESTful APIs, you need to wake up and smell the coffee. Seriously, even though RESTful APIs are still a fairly new thing, they're already essential. If you don't know about them, ask the people on the distributed side of your business -- who I can assure you already rely upon them -- to help bring you up to speed.

    Read More

    Posted: July 12, 2016 |

    Moving to the DB2 Connect Client

    Recently I’ve fielded a number of questions about the best use of DB2 Connect. Specifically, customers want to know if they should continue to use the DB2 Connect gateway or move applications toward a direct connection using the DB2 Connect client with IBM DB2 data server drivers.

    Read More

    Posted: July 05, 2016 |

    Best Practices for Tuning Local and Group Bufferpools

    During May's IDUG NA conference, I attended a session by IBM's John Campbell. A question came up on how to size and configure local and group bufferpools. John mentioned that a presentation he'd given on this in 2013 is available as a webcast.

    Read More

    Posted: June 28, 2016 |

    Really, We're All Experts Here

    Since joining IBM last year I've been spending more time speaking to user groups. This got me thinking about a post I wrote back in December 2012 on the professional benefits of public speaking. While I'd love for you to read the whole thing, I'll sum it up in four words: You can do this.

    Read More

    Posted: June 21, 2016 |

    Displaying results 31-40 (of 484)
     |<  <  1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10  >  >|