A new catalog and directory structure in DB2 for z/OS

For the second time in three releases of DB2 for z/OS a larger number of changes than normal have been made to the Catalog and Directory structure. At first sight the introduction of Unicode and Long Names along with DB2 V8 might appear to be more fundamental, but the improvements made in DB2 10 for z/OS are likely to yield equally important benefits. Chief among the changes are introduction of UTS objects and the removal of the internal links, but that’s not all. We will soon be able to issue SQL against some Directory objects, and the introduction of many more LOBs, some of which can be Inline, will affect the way we need to manage the Catalog. These changes are very significant in their own right and taken together are probably the second most wide ranging (at least) since DB2 was first released back in the mid-1980′s. This session describes all the changes that have been made, their benefits and how they will impact the way we need to manage the Catalog and Directory moving forwards.