This month we will be focusing on temporal table design and Archive tables. DB2 11 for z/OS brought many interesting improvements for temporal tables, which will be addressed during the upcoming month. On top of that in gave us archive tables, which we can use for “transparent archiving”. As a...
Introduction Throughout the history of DB2 on z/OS, DB2 development has continuously improved the product so that larger quantities of data can be maintained in a single table. Nonetheless, there is certainly value in separating data that is still subject to change or referenced very...
We are all witnessing boundaries between OLTP and OLAP applications more and more blurring. Many of today enterprise level applications share the same challenge: manage vast amounts of data, maintain high performance results and keep historical data only a click away. We bring a production...
EU13F03.pdf
This is your first disaster recovery drill, and you are wondering what is involved. We will go thru the process from A to Z. Our discussion will start with an overview of the fundamentals of DB2 infrastructure: the catalog and directory, the BSDS, and the active and archive logs. After a...
EU13F09.pdf
DATE: 2010-5-14 (09:45 AM - 10:45 AM) SPEAKERS: Robert Donaldson (LSSiData) This presentation discusses full text search options in DB2. Solutions compared from a performance perspective are: Word support tables, old legacy NSE, Text Search (introduced in DB2 9.5) and the new NSE introduced in...
NA10D14.pdf
DATE: 2010-5-14 (09:45 AM - 10:45 AM) SPEAKERS: Namik Hrle (IBM) IBM Smart Analytics Optimizer (ISAO) is an appliance that seamlessly connects to DB2 for z/OS and dramatically accelerates selected data warehouse queries. Your Business Intelligence and Data Warehouse application do not need to...
NA10A14.pdf
DATE: 2010-5-13 (01:30 PM - 02:30 PM) SPEAKERS: Suresh Sane (DST Systems Inc) ?This query used to run in 5 seconds and now takes an hour! How could the optimizer do this to me?? Sounds familiar? But are you sure it is DB2's fault? In this session, we will examine the challenges faced by cost...
NA10A11.pdf
DATE: 2010-5-12 (08:30 AM - 09:30 AM) SPEAKERS: Mike Winer (IBM) Mike Winer is a Senior Technical Staff Member and Kernel Architect in DB2 for LUW. During his 17+ years experience in DB2, Mike has worked on a number of key DB2 components such as locking, logging, data and index management,...
NA10D05.pdf
DATE: 2010-5-11 (12:30 PM - 01:30 PM) SPEAKERS: Bill Minor (IBM) Controlling data growth and optimizing storage use are critical for keeping costs in check and ensuring peak performance. Consolidation or mergers, regulatory compliance and increased demand for business analytics and data mining...
NA10D01.pdf
DATE: 2009-5-12 (11:00 AM - 12:00 PM) SPEAKERS: Curt Cotner (IBM Silicon Valley Lab) Data Studio was introduced in Fall of 2007. The Daa Studio portfolio will be 18 months old when IDUG NA in Denver occurs. This presentation will bring you up to date on all the new offerings that are available...
NA09H02.pdf