IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

A new Catalog and Directory Structure in DB2 for z/OS

Session Number: 2139
Track: DB2 10 for z/OS (A)
Session Type: Podium Presentation
Primary Presenter: Steve Thomas [Principal Software Consultant - BMC Software]
Time: Nov 17, 2011 (11:15 AM - 12:15 PM)
Room: Tycho

Speaker Bio: Steve is a Principal Consultant at BMC Software, and supports customers across the UK, Northern Europe, Greece, Turkey and Israel. He has been a DB2 specialist since 1989 and an IBM Information Champion since 2009. Steve has presented on a wide range of topics at events across the UK and in Europe. He helps organize the UK DB2 RUG and has been a member of the IDUG EMEA Conference Planning Committee for the past 5 years.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Database Administrators, Systems Programmers
Technical areas this presentation will apply to: High Availability (DB2 for z/OS), New Release (DB2 for z/OS)
Objective 1: Which of the Catalog objects now use UTS Tabslepaces and what does this mean
Objective 2: Understand Links in the catalog and the implications of their removal
Objective 3: How inline LOBS are being used in the Catalog
Objective 4: What changes have been made the Directory
Objective 5: New Columns, Tables and other miscellaneous Catalog and Directory changes in DB2 10 for z/OS

Abstract:  For the second time in three releases of DB2 for z/OS we have a significant set of changes to the Catalog and Directory structure. At first the introduction of Unicode and Long Names in DB2 V8 look to be more critical as any application accessing the Catalog and Directory needed to change, but the changes in DB2 10 for z/OS are likely to equally important in other areas. Chief among the changes are the use of UTS objects and the removal of internal links, but that's not all that was changed. For the first time we can issue SQL against some Directory objects, and we also have Inline LOBs used in some tables, so this is a pretty significant set of changes in iot's own right and probably the second most significant (at least) since DB2 was first released back in the mid-1980's. This session describes the changes that have been made and how they may impact the way we treat and access the Catalog and Directory moving forwards.

For questions or concerns about your event registration, please contact