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 12 REORG Enhancements

    The REORG utility is one of the most important tools in the DBA toolbox. Traditionally, the REORG table space or index utility is used to reorganize the data to improve access performance as well as reclaim fragmented space.

    Read More

    Posted: January 31, 2017 |

    DB2 12 Table Space with Relative Page Numbers

    In my career as a DBA, I’ve done a lot work working around table space size limits. Managing this involves resizing, rebalancing, adding partitions, and much more. With this perspective, I can assure you that the dramatically increased partition sizes allowed in DB2 12 are a big deal.

    Read More

    Posted: January 24, 2017 |

    DB2 12 for z/OS Technical Overview

    I don't need to tell you that a career working with DB2 for z/OS is never boring. DB2 for z/OS continues to evolve at an ever-increasing pace. To help you keep up with all these changes, IBM has delivered a new Redbook, "DB2 12 for z/OS Technical Overview."

    Read More

    Posted: January 17, 2017 |

    DB2 for z/OS Native RESTful Services in DB2 11 & 12

    I’ve previously written about RESTful services, noting how these services will enable data and applications running on DB2 for z/OS to become a strategic component of your enterprise API strategy.

    Read More

    Posted: January 10, 2017 |

    Comparing DB2 12 Function Levels M100 and M500

    I was recently reading the DB2 12 for z/OS What’s New guide. It's interesting comparing the features available in the initial Function Level M100 with what you can get when you activate Function Level M500.

    Read More

    Posted: January 03, 2017 |

    Deprecated Functions: A Primer

    When IBM decides to remove a function from DB2 for z/OS (or any DB2 offering), it's generally publicized in in the DB2 for z/OS announcement letter. See the DB2 12 for z/OS announcement letter, for instance.

    Read More

    Posted: December 20, 2016 |

    Monitoring Index Cleanup Threads

    I was recently asked about activating a trace that sends information about DB2 11 index cleanup threads to the IBM System Management Facility (SMF).

    Read More

    Posted: December 13, 2016 |

    How Customers are Benefiting from DB2 Accelerator Tables

    Following up on my recent posts on the latest version of IBM DB2 Analytics Accelerator for z/OS (DB2 Accelerator) as well as the new Accelerator cloud-centric solution, I wanted to step back a bit and discuss an IBM Redbook.

    Read More

    Posted: December 06, 2016 |

    Continuous Delivery and DB2 12 Function Levels

    I recently attended a regional DB2 user group meeting, and the subject of continuous delivery came up frequently. People were wondering about the process of adding new features being added through the maintenance stream and how to fallback if it's determined that the new features are causing a problem.

    Read More

    Posted: November 29, 2016 |

    DB2 12 for z/OS Manuals Available

    Long-time readers of DB2utor know that I prefer using the DB2 manuals in PDF form as opposed to the electronic versions available from the IBM Knowledge Center. After hearing rumors that IBM would no longer make documents available in PDF, I was very pleased to find the DB2 12 for z/OS manuals available in PDF form.

    Read More

    Posted: November 22, 2016 |

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