Articles & Content

Archives

E10 - Generic design is generic performance can be good!

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2014



During one of my first DB2 classes Susan Lawson stated: “generic design is generic performance”. This statement has been in my mind since then and helped me to be a good DBA on DB2 for z/OS for years: I had to repeat it more times than I had hoped when talking to managers, architects, designers and developers. Until 2008, when I entered the world of data warehousing and business intelligence. I learned that generic performance by generic design can be good! How is that possible?

In this presentation I would like to share with you what we have learned in the last six years while building the Enterprise Data Warehouse at the Dutch Tax Office. The Enterprise Data Warehouse (EDW) runs on System z, with DB2 z/OS as database server and SAS as programming environment.

I’ll start with an overview of the architecture, both functional and technical. Then you will learn what Data Vault (the generic datamodeling method used for EDW) is, what the challenges for the DBAs are and which solutions we have developed. After that I’ll talk about SAS and the way SAS behaves in a System z and DB2 z/OS environment. I’ll talk further about specific DB2 features we use, like partitioning, aliases, utility usage, bufferpool usage, etc and how we keep the EDW healthy. I’ll show some DB2 10 features we have tested and (not) have implemented and the last part will discuss the IDAA as a possible booster for the EDW.

During the presentation I’ll show you that generic design can be good and I’ll give you some examples on the differences between building an OLTP system and a data warehouse for business intelligence (and there are some huge differences!).

This presentation will give you a lot of information about the way we have implemented the Enterprise Data Warehouse and hopefully will give you some ideas, food for thought and inspiration to take with you to your own environment.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.