Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Dealing with Db2 10-11 Migration Incompatibilities
  • Data Compression Enhanced in Db2 12
  • A New Utility Stored Procedure
  • How to Determine Current Db2 Function Level
  • Db2 for z/OS in the Cloud: What's Ahead
  • Avoiding Indirect References in DB2 11

    When designing the physical structure “table space” used to store table data, DBAs must understand the types of processing that will occur against the table. Will the table have lots of inserts, updates or deletes, or is it mainly read-only? Will the table rows be variable length due to either VARCHAR columns or data compression? Answering these questions helps DBAs choose the appropriate table space storage options during the creation.

    Read More

    Posted: February 24, 2015 |

    How to Control Statistics Feedback

    DB2 11 introduced a feature to help identify missing or conflicting statistics that can help the optimizer choose a more efficient access path. I wrote about this feature here, however, I've since learned that two DB2 subsystem parameters can be used to reduce the amount of information collected and control how frequently information is written to memory.

    Read More

    Posted: February 17, 2015 |

    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 |

    Displaying results 131-140 (of 508)
     |<  <  10 - 11 - 12 - 13 - 14 - 15 - 16 - 17 - 18 - 19  >  >|