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
  • DB2 12 In-Memory Index Optimization

    Last month I wrote about the trend of increasing the amount of real storage when configuring new mainframe systems. DB2 12 (which is set for delivery in the fourth quarter of 2016) features many new performance improvements that are designed to take advantage of available real storage. One of these enhancements is called In-Memory Index Optimization -- aka, index fast traversal blocks (FTBs).

    Read More

    Posted: September 27, 2016 |

    Open Source Tools and Languages for z/OS

    The application development landscape on the mainframe -- which for me is really z/OS -- continues to evolve. Now businesses that are moving to cloud and mobile applications use not only Java, but also Perl, PHP, Python, R and TCL. These open source languages are very powerful because they can facilitate certain types of processing through a minimal amount of coding.

    Read More

    Posted: September 20, 2016 |

    Become a Part of Generation z

    In my job with IBM, I spend a lot of time at customer sites. During these visits, I’m seeing an increasing number of young IT professionals who are just starting their careers on z/OS.

    Read More

    Posted: September 13, 2016 |

    DB2 12 Continuous Delivery Model Webinar

    Software development on z/OS has traditionally adhered to tried and true practices to ensure that poorly constructed application code does not make it into production. In many shops we call these change control people the “gatekeepers.” Nothing gets past these individuals. Developers must rigorously test their code before an application or update goes live. Beyond that, fallback procedures must be devised in case there's a problem once the code is moved into production. On top of that, changes to production systems are subject to a strict schedule to ensure that no critical business event are interrupted.

    Read More

    Posted: September 06, 2016 |

    Greater Memory Already Making a Great Impact

    In November 2015 I wrote about the launch of DB2 12 for z/OS ESP, citing all the various enhancements DB2 has made by exploiting significantly greater amounts of available memory. Well, it isn't just DB2 12 that will benefit from additional memory to reduce CPU cost.

    Read More

    Posted: August 30, 2016 |

    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 |

    Displaying results 41-50 (of 499)
     |<  <  1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10  >  >|