Team with the best
Db2® LUW Performance Tools
company in the World

MARATHON FREE DB2 EDUCATION WEEK on The #DB2Night Show, June 25-29

June 25, 2012, 7:34 pm
Posted by Scott in General
Updated! Season #3 of The DB2Night Show™ is coming to an end, so we thought we'd provide you with an extra dose of FREE DB2 Education. June 25-29, 2012, we'll have a special focus on Data Warehousing, InfoSphere Warehouse V10.1, Netezza, and PERFORMANCE with shows every day!
Visit The DB2Night Show™ SCHEDULE for more details and registration links. Seats in our virtual studio audience are FREE - get the chance to ask our guests questions and win prizes!

25 June 10am CDT:: Temporal Queries and Analytics in an IBM InfoSphere Warehouse Environment

You missed it! WATCH REPLAYS!

26 June 2pm CDT:: Realtime Data Warehousing with InfoSphere Warehouse V10.1

This show will explore the new features in the recently released InfoSphere Warehouse V10.1 that specifically enable realtime warehousing scenarios. New features such as Continuous Data Ingest and Adaptive Compression will be introduced and described in the context of realtime warehousing and operational BI solutions. The session will dive into how each of these functions work, best practices and implications on system architecture and model design and how they compare/contrast to existing data ingest and compression features. Several high-value business scenarios will be described to demonstrate the value of these new features.

27 June 10am CDT:: InfoSphere Warehouse V10.1 Performance Enhancements

The recently released InfoSphere Warehouse (and DB2) V10.1 introduced a number of core engine enhancements that, in particular, accelerate the performance of data warehouse queries, especially in an operational warehousing environment. This session will dive into several of the key features for data warehouse performance in turn, including:

  • Multi-core parallelism to exploit processors with increasing core capacity
  • The jump-scan feature for faster composite index access
  • Smart index prefetching and smart data prefetching
  • Zig-zag join for improved star schema performance
  • Improved RUNSTATS and other enhancements
In aggregate, the performance improvements derived from these new features enables InfoSphere Warehouse V10.1 to run up to 3 times faster, to more readily meet enterprise ELAs and to generally do more processing with less resources, allowing InfoSphere Warehouse to provide an enhanced return on investment.

28 June 10am CDT:: High Performance Analytical Data Warehouse using IBM Netezza Appliance 1000 - Best Practices

The IBM Netezza 1000 Appliance is purpose built to support very high performance analytical workloads on the relational data warehouse. The 10+ year history of the Netezza Appliance (previously known as TwinFin) has repeatedly demonstrated the superiority of the Netezza appliance parallel processing architecture for processing analytic workloads. In addition to the shared-nothing parallel processing architecture at the foundation of the Netezza appliance, there are also a number of performance features that further enhance query performance. This session will dig down into several of these key features and describe industry-proven best practices to get the best possible performance out of your IBM Netezza appliance data warehouse. Topics that will be covered include best practices for the following areas:

  • Best practices for data and processing distribution with respect to distribution key selection
  • Effective compression
  • Effective exploitation of zone maps
  • Effective usage of clustered base tables
  • Optimal use of materialized views
The discussion will cover practical usage and guidelines for best results and optimal query performance.

29 June 10am CDT:: Season #3 Finale! Reducing CPU and I/O Consumption!

Our Season #3 will end with a terrific presentation on reducing CPU and I/O utilization in DB2 LUW while concurrently achieving performance gains! Our special guest will be Andrew Endicott, DBA Manager at Cardinal Health.

Andrew, with a bit of assistance from your host, Scott Hayes, will talk about Cardinal Health's methodology and process for tuning their DB2 LUW systems, and share some of their many successes. You will hear how hardware upgrades were avoided while delivering better service to end users.

Enjoy Summer 2012

Watch Replays! A typical episode of The DB2Night Show is downloaded over 1,300 times! What are you missing?

Tweet Up! Tell your friends about these shows!

The Corporate Sponsor of The DB2Night Show:
DBI Software

DBI is offering a free Webinar "How to Improve Performance in Minutes!" on 29 June 2012 at 1pm CDT. Visit DBI Events for details and the registration link.

On 23 May 2012, DBI Announced new competitive performance tool pricing incentives. If you have IBM OPM or other performance tools, DBI invites you to trade-in, trade-up, and swap-out those tools while enjoying special license savings. Inquire with your DBI representative for qualifications and details.

DBI is Your Trusted Partner
for Breakthrough DB2 Performance Solutions
that Deliver Invaluable Results
for Organizations having the most Demanding Requirements
and Discriminating Preferences

Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!

Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

Printer friendly