1 to 10 of 51
Sort by

Blog Entry
Temporal and Archive - How to Manage Data Over Time

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...

Kurt Struyf's profile image

Blog Entry
DB2 11 for z/OS Transparent Archiving

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...

Archive User's profile image

Library Entry
[F03] Data archived, yet accessible in real-time

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...


Library Entry
[F09] The ABC’s of Disaster Recovery

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...


Library Entry
Introducing IBM Smart Analytics Optimizer - DB2 Performance Revolution (A14)

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...


Namik Hrle's profile image

Library Entry
Ask not what the Optimizer can do for you? ask what you can do for the Optimizer! (A11)

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...


Suresh Sane's profile image

Library Entry
Partitioned Tables: Significant Enhancements in DB2 9.7 (and beyond) (D05)

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,...


Library Entry
Data Studio Strategy and Vision (H02)

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...


Curt Cotner's profile image