View Printable Version

E18 - The Db2 Catalog - A Guided Tour

Session Number: 5039
Track: AppDev and Analytics I
Session Type: Podium Presentation
Primary Presenter: Henrik Loeser [IBM]
Time: Oct 05, 2017 (11:00 AM - 12:00 PM)

Speaker Bio: Henrik Loeser works closely with business partners and clients to help them succeed with IBM Bluemix, Db2 LUW and other products. Right now he receives his paycheck as offering manager and developer advocate for Bluemix. In a past life Henrik was development manager and technical lead for components of Db2 at IBM's Silicon Valley Lab. Henrik speaks frequently at conferences, at customer sites and user group meetings. He holds both a Ph.D. and M.Sc. in Computer Science from the University of Kaiserslautern, Germany. Read his blog at and follow him as @data_henrik on Twitter.
Audience experience level: Beginner, Intermediate
Presentation Platform: DB2 for Linux, UNIX, Windows
Presentation Category: Application Development
Audiences this presentation will apply to: Application Developers, Database Administrators, New Users
Objective 1: Understand overall structure of Db2 metadata. What is the catalog.
Objective 2: Take a look at catalog views (and tables) by topic. How to find the information that is needed to answer a specific question.
Objective 3: Understand "Packed Descriptors" and what Db2 does behind the curtain. Take a look at packed descriptors using db2cat
Objective 4: Have fun

Abstract:  Come follow me on this tour to the Db2 metadata and related tools. After taking the Roadmap to Catalog Views, we will visit the metadata for tables, indexes, and other database objects. We will look at how dependecies and privileges are recorded. Have you ever seen a Packed Descriptor? Now is the time. Book the tour and follow the experienced guide...

For questions or concerns about your event registration, please contact