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
  • 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 |

    developerWorks Community for DB2 Analytics Accelerator

    Last year I noted that IBM was accelerating development of the DB2 Analytics Accelerator. With new maintenance releases coming out about every 3-6 months, it's a challenge to keep up with all the changes. That's why I was excited to discover the IBM developerWorks Community for DB2 Analytics Accelerator.

    Read More

    Posted: June 14, 2016 |

    Plan Management Best Practices for Upgrades

    Each new DB2 release brings enhancements to the SQL optimizer, which is designed to speed response times by improving the access path used to return qualified data to the application. However, these improvements can only be realized by first REBINDing the program package.

    Read More

    Posted: June 07, 2016 |

    Setting Maximum Open Datasets to Greater Than 10,000

    Recently I was sitting in on a customer review and the topic of maximum number of open data sets came up. In DB2 11, the maximum number of open datasets is increased from 10,000 to 200,000.

    Read More

    Posted: May 31, 2016 |

    Using Trusted Context on a Local Connection

    Back in August 2011, I wrote about the use of roles and trusted context in auditing DBA activity. Just recently two separate customers have asked me about how and when to use this. Given that -- not to mention the increased attention on enterprise security, the growing demand for remote access through mobile devices, and the ongoing need to audit all management activities -- this topic is well worth revisiting.

    Read More

    Posted: May 24, 2016 |

    Using Predicate Selectivity Overrides

    Back in 2011, I wrote a series of posts about the evolution of optimization hints and the new DB2 10 statement-level optimization hints.
    Now with DB2 11, the statement-level optimization hint can override the selectivity of predicates for matching statements. This is needed because DB2 cannot estimate filter factors for certain types of predicates. It must rely on inaccurate estimates or even default filter factors to select access paths for statements that use such predicates.

    Read More

    Posted: May 17, 2016 |

    DB2 11 REORG Optimum Parallel Processing

    I recently worked with a customer who hadn't been using the PARALLEL parameter for REORG TABLESPACE. They'd set the LISTDEF parameter at the database level, which qualifies a large number of table spaces with hundreds of partitions per table space. Because the customer lacked the disk space to process hundreds of partitions simultaneously, they set the REORG_LIST_PROCESSING system parameter to SERIAL, which defaults the value of PARALLEL to (NO).

    Read More

    Posted: May 10, 2016 |

    z/OS Continuous Delivery

    With the adoption of software development methodologies such as Agile, consumers have come to expect new solutions and product updates to come at a much faster pace. This same expectation now exists for business applications that rely upon mobile computing, cloud storage, real-time analytics and other emerging technologies.

    Read More

    Posted: May 03, 2016 |

    IDUG NA Conference Reminder

    I'm very excited about the upcoming IDUG DB2 Tech Conference for North America. Though DB2 for z/OS 12 doesn't have an official release date, it will be prominent of discussion at the conference.

    Read More

    Posted: April 26, 2016 |

    Displaying results 71-80 (of 516)
     |<  <  4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 - 12 - 13  >  >|