Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Db2 12 Brings Enhanced Data Validation Capabilities to DSN1COPY
  • Db2 12 Avoids CPU and I/O During PIT Recovery
  • DBaaS and Streamlined Development
  • Use of NEWFUN versus APPLCOMPAT
  • Dealing with Db2 10-11 Migration Incompatibilities
  • Db2 12 Brings Enhanced Data Validation Capabilities to DSN1COPY

    This post is outlines DSN1COPY, which is a stand-alone utility to copy Db2 VSAM data sets.

    Read More

    Posted: October 17, 2017 |

    Db2 12 Avoids CPU and I/O During PIT Recovery

    Traditionally when a point-in-time (PIT) recovery is needed, all the tables that have a referential relationship will be recovered simultaneously to the same PIT. The problem is there's no way to determine whether one or more parent tables or related child tables have changed. Besides substantially lengthening the recovery time, this can consume a lot of CPU resources, which of course drives up recovery costs.

    Read More

    Posted: October 10, 2017 |

    DBaaS and Streamlined Development

    The term Database-as-a-Service (DBaaS) can convey different things. You may think of off-premise cloud deployment of a DBMS, like IBM's Db2 on Cloud (formerly known as dashDB).

    Read More

    Posted: October 03, 2017 |

    Use of NEWFUN versus APPLCOMPAT

    I was recently asked about the differences between DSNHDECP NEWFUN(V11) and the APPLCOMPAT=V11R1 zparm system parameter. It's certainly an interesting question, so let's answer it here.

    Read More

    Posted: September 26, 2017 |

    Dealing with Db2 10-11 Migration Incompatibilities

    Recently, someone on the DB2-L forum was seeking help with an application that started failing following an upgrade from Db2 for z/OS 10 to Db2 for z/OS 11. With Db2 10 going out of support on Sept. 30, there's undoubtedly a lot of migrations going on right now. With this in mind, I thought I'd point out some places to go for migration information.

    Read More

    Posted: September 19, 2017 |

    Data Compression Enhanced in Db2 12

    Db2 12 function level V12R1M500 introduces the capability to compress LOB table space using zEnterprise data compression (zEDC) hardware.

    Read More

    Posted: September 12, 2017 |

    A New Utility Stored Procedure

    The stored procedure DSNUTILS has been deprecated as of Db2 12. It's used to call utility program DSNUTILB using EBCIDIC encoded parameters. While your application will continue to function when DSNUTILS is called, it could be removed from future releases. For this reason, you should replace DSNUTILS with either of two current support procedures, DSNUTILU and DSNUTILV.

    Read More

    Posted: September 05, 2017 |

    How to Determine Current Db2 Function Level

    With the introduction of continuous delivery making it possible for customers to put new features into production through regular maintenance, awareness of Db2 function levels takes on greater importance. So how do you determine what level you're at and what level of maintenance has been applied?

    Read More

    Posted: August 30, 2017 |

    Db2 for z/OS in the Cloud: What's Ahead

    Troy Coleman explores how Db2 for z/OS on the IBM mainframe fits into the cloud.

    Read More

    Posted: August 21, 2017 |

    System z Apprentice Program

    Long-time readers of this blog know I've often discussed the mainframe skills shortage and cited various initiatives that aim to attract the next generation of talent. I came across new organization while attending last month's SHARE conference: LEAD-IT (Leadership, Empowerment, Apprenticeship and Diversity in Information Technology).

    Read More

    Posted: August 15, 2017 |

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