Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Dealing with Db2 10-11 Migration Incompatibilities
  • Data Compression Enhanced in Db2 12
  • A New Utility Stored Procedure
  • How to Determine Current Db2 Function Level
  • Db2 for z/OS in the Cloud: What's Ahead
  • DB2 11 Index Cleanup Threads

    IBM continues to focus on improving index management, with a goal of reducing the overall cost of storing and retrieving data from DB2 by helping customers avoid I/Os.

    Read More

    Posted: December 09, 2014 |

    The Differences in Databases

    While I've spent most of my career with DB2 for z/OS, I did work on DB2 for LUW for a few years. So I know what it's like to jump to a new environment. I understand that the terminology and architecture can be confusing when you're starting out. With this in mind, I've collected some resources that provide a helpful introduction for those who are new to DB2.

    Read More

    Posted: December 02, 2014 |

    DB2 11 Built-In Global Variables

    Last week I wrote about defining, authorizing and using user-defined global variables. This week I'll introduce and explain the built-in global variables that are delivered with DB2 11.

    Read More

    Posted: November 25, 2014 |

    DB2 11 Global Variables

    Standard query language (SQL) is used by applications to access and process data stored in relational databases such as DB2. It's common for an application to process some data and pass information to another program so it can process the same data. Using global variables -- now available with DB2 11 for z/OS -- minimizes this type of data movement, thus reducing your CPU usage.

    Read More

    Posted: November 17, 2014 |

    How EXPLAIN Tables are Used for Tuning SQL: Part 2

    Over the years I’ve written about the EXPLAIN command how it can be used to capture information with SQL statements. Last week I reviewed some of the EXPLAIN tables and explained how information in these tables can be to help improve performance and lower data access costs.

    Read More

    Posted: November 07, 2014 |

    How EXPLAIN Tables are Used for Tuning SQL: Part 1

    EXPLAIN tables are designed to help you diagnose what DB2 is doing to access the data. With each DB2 release, IBM increases the amount of EXPLAIN analysis information available through these tables.

    Read More

    Posted: November 03, 2014 |

    Modern Storage and its Impact on DB2 Performance

    While I've often written about the value of IBM Redbooks, I was surprised when a friend recommended I check out "IBM DS8870 with Firmware Release 7.3 Product Guide."

    Read More

    Posted: October 27, 2014 |

    Batch SPUFI

    Recently I was asked about running SQL and DDL in batch rather than ONLINE using SPUFI. DB2 is delivered with some sample programs that support running DDL or SQL in batch. These programs are called DSNTIAD, DSNTEP2 and DSNTEP4, and detailed information about them can be found in the Utility Guide and Reference manual.

    Read More

    Posted: October 21, 2014 |

    Accessing DB2 Directory Tables Using SQL

    DB2 for z/OS includes a set of directory tables, which are internal tables stored in a system database named DSNDB01. These tables are "internal" because they're intended strictly for DB2 use. However, DBAs can gather key information -- such as listing active or stopped utility jobs -- from directory tables.

    Read More

    Posted: October 14, 2014 |

    Another Sign of XML's Growth

    As I've mentioned several times over the years, when I research DB2 for z/OS topics, I'll generally start by visiting the online library and downloading any manuals that have changed. Here's my latest finding: almost every manual in the DB2 for z/OS library -- including DB2 9, 10 and 11 -- has been updated in the past two months. So rather than list the manuals that changed, I'll simply advise you to go to the library and download anything that's been updated as of August 2014.

    Read More

    Posted: October 07, 2014 |

    Displaying results 141-150 (of 508)
     |<  <  11 - 12 - 13 - 14 - 15 - 16 - 17 - 18 - 19 - 20  >  >|