Data Warehousing on System z Best Practices

Data warehousing on System z is getting a lot of interest today. However, that interest is also generating a lot of questions. If you want to put your warehouse on System z using DB2, or if you all ready have a warehouse on System z, you may want to know what are some of the Best Practices that have been learned over the years. This presentation will help answer your questions about doing warehousing on System z successfully. Some examples of what we will be discussing are DB2s DSNZPARMs, buffer pools, table space choices, caching structures, sorting, and utility processing. Well also examine query performance, SQL structure choices, and SQL analysis along looking at some of the tools available.

Tracks: Application Development, Software Architecture, Storage Administration and z/OS Systems Programming