Data Warehousing on System z Best Practices

Project and Program: Information Management, Database

Tags: Proceedings , SHARE in Anaheim 2012 , 2012

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. Willie Favero ; IBM Corporation

Back to Proceedings File Library