Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • A Happy 10 Years
  • Db2: A Small but Significant Change
  • Subsystem Parameter Changes in DB2 12
  • New and Changed Subsystem Parameters in DB2 11
  • MERGE Statement Enhancements in DB2 12
  • 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 |

    How Data Server Manager Fits with z/OS

    I’ve written a lot about Data Server Manager (DSM) since its release in October and the announcement of DB2 for z/OS support in January.

    Read More

    Posted: April 19, 2016 |

    DB2 11 Block Fetch Capabilities

    Last week I briefly went through the history of block fetch. Today I look at the block fetch enhancements delivered in DB2 11 for z/OS, known as package-based continuous block fetch, or blasting.

    Read More

    Posted: April 12, 2016 |

    The Evolution of DB2 Block Fetch

    When DB2 was first released, a distributed application would open a cursor and fetch a single row of data. This fetch request would go to DB2, then DB2 would return one row to the application. If the application requested 20 rows to be displayed on the screen, then 20 cross-network requests had to be made. This would greatly reduce the response time for the given application.

    Read More

    Posted: April 05, 2016 |

    Big News About DB2 11 for z/OS Certification

    IBM just made available a new DB2 for z/OS certification test, DB2 11 Fundamentals for z/OS (C2090-320). To put it mildly, this is great news.

    Read More

    Posted: March 29, 2016 |

    Access Database Command Improvements

    DB2 11 brings a number of enhancements to the ACCESS DATABASE command. Before getting into those improvements, I want to discuss how the ACCESS DATABASE command is used.

    Read More

    Posted: March 22, 2016 |


    At times a transaction executing on DB2 for z/OS could cause resource problems with other transactions. It could be driving up CPU usage, holding locks and blocking critical transactions, or causing a number of other issues.

    Read More

    Posted: March 15, 2016 |

    DB2 11 Autonomous Procedures

    DB2 11 introduced autonomous procedures, which are native SQL procedures that commit independently from the calling application. They execute under their own units of work, separate from the calling program.

    Read More

    Posted: March 08, 2016 |

    Displaying results 61-70 (of 499)
     |<  <  3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 - 12  >  >|