Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Additional Support for JSON
  • Previewing the Upcoming IDUG Conference
  • Continuous Delivery the Subject of New Redbook
  • Upgrading Data Server Clients and Drivers for Db2 12
  • A New Addition to the IBM z Trial Program
  • The Latest on Data Server Manager

    I'm just back a week at the Db2 for z/OS Silicon Valley Lab (SVL), where we discussed z Analytics products. One of the sessions I really enjoyed was the hands-on lab for Data Server Manager (DSM). This recently updated solution has lots of new features to help administer, monitor, manage and optimize not just Db2 for z/OS, but the entire Db2 family (Db2 for z/OS, Db2 for LUW, Db2 on Cloud, Db2 Warehouse on Cloud, Db2 Warehouse Private).

    Read More

    Posted: February 13, 2018 |

    Big Changes for Db2 Analytics Accelerator

    Following up on last week's post on data virtualization and the ongoing effort to keep data on the mainframe, I thought it would be appropriate to provide an update on the latest release of IBM Db2 Analytics Accelerator (IDAA) V7.1.

    Read More

    Posted: February 06, 2018 |

    Data Virtualization on z/OS

    For almost 30 years I've worked with and supported business applications running in Db2 for z/OS environments. During that time, there's been a near constant effort to replicate data from the mainframe to Linux, UNIX and Windows (LUW) platforms.

    Read More

    Posted: January 30, 2018 |

    A Look at Upcoming Db2 Conferences

    I was recently asked about Db2 conferences and which provide the most technical content. Short answer: the long-standing SHARE and IDUG conferences.

    Read More

    Posted: January 23, 2018 |

    Enhancements for Db2 Native REST Web Services

    IBM recently released some fixes and new functionality for Db2 for z/OS. If you're currently using and or planning to use Db2 native RESTful web services, you should apply this maintenance. For Db2 11, apply APAR PI86867; for Db2 12, apply APAR PI86868.

    Read More

    Posted: January 16, 2018 |

    Converting from 6- to 10-byte RBA/LRSN

    Db2 11 introduced an option to convert the log relative byte address (RBA) and data sharing log record sequence number (LRSN) from the basic 6-byte format to the extended 10-byte format. Timm Zimmermann of the IBM Db2 for z/OS development "swat team" has a great presentation that goes into the details on the different formats. More importantly, Timm lays out the dwindling time that customers have left to convert their old 6-byte addresses and numbers to the soon-to-be standard 10-byte format.

    Read More

    Posted: January 09, 2018 |

    IBM Z Trial Program

    Mainframe customers running z/OS know all too well the amount of the work that comes with a proof-of-concept. The process requires months of planning among system programmers, security and storage administrators and end users.

    Read More

    Posted: January 03, 2018 |

    The Evolution of Compression: Db2 12

    With each release of Db2, enhancements have been made to improve compression performance, availability and scalability. An important change in Db2 12 is the introduction of the online deferred option, ALTER INDEX COMPRESS YES. This allows you to able compression for an index without causing an outage.

    Read More

    Posted: December 19, 2017 |

    The Evolution of Compression: Db2 11

    This is my fourth installment in a series detailing the history of Db2 compression. As is the case with all previous releases, the Db2 engine takes advantage of the z System hardware platform in Db2 Version 11 for z/OS. With Db2 11 and zEC12 hardware, compression overhead was reduced by as much as 15 percent.

    Read More

    Posted: December 12, 2017 |

    The Evolution of Compression: Db2 10

    My backgrounder on compression continues with Db2 for z/OS Version 10. This release brought compression support to SMF trace data and provided an availability option to activate data compression without placing the table space in REORG pending.

    Read More

    Posted: December 05, 2017 |

    Displaying results 11-20 (of 538)
     |<  <  1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10  >  >|