Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • A Study of zparm Settings
  • developerWorks Blog Provides Db2 for z/OS Updates
  • Mobile Apps for Mainframe Pros
  • Db2 11 for z/OS End of Support
  • Learning to Code Efficient Db2 SQL
  • Contest Introduces Students to the Mainframe

    For years I've discussed the aging mainframe workforce and the need to get young IT pros onto the platform. I've written about zNextGen, the great SHARE program that helps recent graduates who are entering the workforce connect with one another. I've also covered the IBM Academic Initiative, which works with high schools and universities and provide the curriculum and access to systems educators need to teach mainframe skills to the next generation. The Academic Initiative has provided mainframe training and resources to students at more than 1,000 schools in 70 countries.

    Read More

    Posted: October 24, 2017 |

    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 |

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