Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • The Future of Db2 Documentation: More PDFs, More Frequent Updates.
  • IBM Champions: Nomination Period Ends Soon
  • Planning for a Db2 for z/OS Upgrade: Application Testing
  • Contest Introduces Students to the Mainframe
  • Db2 12 Brings Enhanced Data Validation Capabilities to DSN1COPY
  • DB2 Resource Limit Facility

    With early DB2 releases, many customers would restrict dynamic SQL on a production online transaction processing system (OLTP). DBAs had no way to lock in the access path to avoid unexpected performance problems that could occur due to ad hoc queries impacting business critical applications. To help provide some controls and allow access to production data, DB2 provides a resource “governor” through the resource limit facility (RLF). The RLF can be set to cancel the query once a given amount of processor service units (CPU) have been consumed. This is known as “reactive” governing.

    Read More

    Posted: February 10, 2015 |

    IBM z13 Announcement Review

    If you missed out on IBM's live streaming of the System z13 announcement, do yourself a favor and watch the replay. Though the entire events lasts almost three hours, it's well worth your time.

    Read More

    Posted: February 03, 2015 |

    Solving SQL Error -805

    In my career as a DBA, developers have asked me countless times about SQL Error -805. I'll tell you what I've always told them: This error can be triggered for any number of reasons.

    Read More

    Posted: January 27, 2015 |

    DB2 Catalog Cleanup Best Practices

    DB2 for z/OS maintains a set of tables called the DB2 catalog. These tables, which are maintained in the DSNDB06 database, contain information about DB2 database objects and application objects, as well as object recovery information.


    Read More

    Posted: January 20, 2015 |

    The Value of Presenting at IDUG

    Early in my career, not long after I became a DB2 database administrator, I wanted to attend my first IDUG conference. Management consented -- but only if I would give my own presentation.

    Read More

    Posted: January 13, 2015 |

    DB2 Accelerator: What's Next

    IBM DB2 Analytics Accelerator is a relatively new but increasingly important component of DB2 for z/OS. I’ve had several posts on DB2 Accelerator (once known as IDAA). See here, here and here. I also discussed an IBM Redbook devoted to DB2 Accelerator 4.1.

    Read More

    Posted: January 06, 2015 |

    Are REORGs Still Necessary?

    In most of my postings to this blog I conclude by asking for your comments. As I've said numerous times, feedback from readers often serves as the basis for things I write about. This is another example of that.

    Read More

    Posted: December 23, 2014 |

    Active/Active Replication and DB2 DR Planning

    Sometime in your career as a DB2 systems programmer, you may be asked to develop a disaster recovery plan for DB2. Of course your recovery plan will have to fit in with the overall DR plan for the data center.

    Read More

    Posted: December 16, 2014 |

    DB2 11 Index Cleanup Threads

    IBM continues to focus on improving index management, with a goal of reducing the overall cost of storing and retrieving data from DB2 by helping customers avoid I/Os.

    Read More

    Posted: December 09, 2014 |

    The Differences in Databases

    While I've spent most of my career with DB2 for z/OS, I did work on DB2 for LUW for a few years. So I know what it's like to jump to a new environment. I understand that the terminology and architecture can be confusing when you're starting out. With this in mind, I've collected some resources that provide a helpful introduction for those who are new to DB2.

    Read More

    Posted: December 02, 2014 |

    Displaying results 141-150 (of 516)
     |<  <  11 - 12 - 13 - 14 - 15 - 16 - 17 - 18 - 19 - 20  >  >|