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

The DB2Night Show #114: DB2 BLU Early Experiences and Best Practices

Berni Schiefer, Jessica Rockwood, Michael Kwok, IBM DB2 BLU

Special Guests: Berni Schiefer, Jessica Rockwood, Michael Kwok, IBM Canada

IBM DB2 10.5 BLU Early Experiences and Best Practices

96% of our studio audience learned something! During this episode of The DB2Night Show™, our IBM Canada guests took us on an informational BLU adventure! Berni introduced this exciting new technology, Michael shared with us several early customer success stories, and then Jessica did an outstanding job of sharing current ( and evolving! ) BLU best practices! Our live audience asked several excellent questions at the end! Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #113: DB2 Customer Success Story from a REAL DB2 customer

Kshitij Kohli, Church Mutual Insurance

Special Guest: Kshitij Kohli, Sr. DBA, Church Mutual Insurance Company

DB2 Customer Success Story - Implementing a NEW DB2 LUW Application

100% of our studio audience learned something! During this episode of The DB2Night Show™, "Kohli", Sr. DBA at Church Mutual and 2012 DB2's GOT TALENT Winner, shared with us several valuable tips and techniques for achieving GREAT performance from DB2! How can you get fast index access from a LIKE %string% predicate? How can you tune your I/O subsystem? How can you measure performance and make the case for safely and successfully upgrading to a new DB2 release or version? Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #112: DB2 LUW 10 Index Jump Scans & Index Best Practices

Scott Hayes, DBI

Host & Guest: Scott Hayes, DBI Software

DB2 LUW 10 Index Jump Scans and Index Best Practices

100% of our studio audience learned something! During this episode of The DB2Night Show™, Scott Hayes, IBM DB2 GOLD Consultant and Information Management Champion, wore two hats and doubled as show host and guest! Scott shared an updated edition of his IDUG Orlando presentation on DB2 LUW 10 Jump Scans that adds DB2/AIX tests to the original DB2/Windows tests. Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #111: What's New in DB2 LUW 10.5 "BLU and More!"

George Baklarz, IBM

Special Guest: George Baklarz, IBM

What's New in DB2 LUW 10.5 - BLU and More!

97% of our studio audience learned something! During this episode of The DB2Night Show™, George Baklarz, IBM's most frequent flier, shared with our audience great information about DB2 BLU Acceleration, pureScale enhancements, Oracle Compatibility Updates, JSON, DB2 Packaging Updates, and more! Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #109: ATTACK of the BLOB! with guest Michael Krafick

Michael Krafick, Sr. DB2 LUW DBA

Special Guest: Michael Krafick, DB2 Comic and "Blob Master"!

DB2 Customer teaches BLOBs obedience!

100% of our studio audience learned something! During this unique episode of The DB2Night Show™, Michael Krafick, Sr. DB2 LUW DBA, DB2 comic, and database obedience trainer shared with us his "school of hard knocks" lessons learned about achieving maximum, remarkable, awesome performance from BLOB objects in his organization's database! Do you have BLOBS? YES, you do! The DB2 Catalog contains LOB and LONG objects! Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #108: "EXPLAIN Reality"

Presented by: Michael Tiefenbacher
Manager Business Systems, ids-System Munich, Germany

""
Replays available in WMV and M4V formats!

96% of our studio audience learned something! Michael presented recent improvements to DB2 LUW Explain facilities, with many practical tips. Watch the replay...



[ more .. ]
by martin in DB2 LUW

The DB2Night Show #99: DB2's GOT TALENT Contestant Search #1

DB2's GOT TALENT

Special Guests: Worldwide Contestants!

Tips from Ember, Mohankumar, and Eric!

100% of our studio audience learned something! Today's contestants talked about tips for running db2haicu, DB2 LUW data movement utilities, and the best ways to build an audit table using the partitioning feature of DB2 LUW. Watch our replay for details...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #98: DB2 LUW 10 Performance Updates with Berni Schiefer

Berni Schiefer, IBM

Special Guest: Berni Schiefer, Distinguished Engineer, IBM Canada

DB2 LUW 10 Performance Updates from the Lab

97% of our studio audience learned something! Berni's life has been all about DB2 performance since 1988. During today's show, Berni generously shared the latest DB2 10 performance news, tips, and insights with our audience. Watch our replay for details...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #97: DB2 LUW 10.1 Cool Features No One is Talking About

Iqbal Goralwalla, Triton Consulting

Special Guest: Iqbal Goralwalla, Triton Consulting

DB2 LUW 10.1 Cool Features that No One is Talking About!

100% of our studio audience learned something! IBM marketing has drilled Adaptive Compression, Temporal Tables, Zigzag joins and more into our heads. Yet, beyond all the front page hype and hysteria, there are many new and awesome features in DB2 10.1 that aren't getting the attention they deserve. Iqbal lifts the hood and reveals the cool stuff you need to know about. Watch our replay for details...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #95: Back out strategies for DB2 LUW Database Changes

Ember Crooks, Rosetta

Special Guest: Ember Crooks, Rosetta

Do What I Mean - Not What I Say! Back out strategies for DB2 LUW Database Changes

97% of our studio audience learned something! Have you ever made a database change and then had an "oh crap!" moment? Mistakes happen! Upgrades go wrong! Ember gave us some very helpful advice on what to do to be prepared in the event that you need an "Undo" button! Watch our replay for details...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #94: IBM DB2 LUW Data Warehouse Performance

Glen Sheffield, Haider Rizvi, Mike Kwok, Scott Hayes

Special Guests: Glen Sheffield, Haider Rizvi, Michael Kwok, IBM Canada

IBM DB2 LUW Data Warehouse Performance

97% of our studio audience learned something! Our IBM Canada guests shared with us the latest news, tips, and advice for Data Warehouse Performance. Their updates included information about IBM pureSystems and DB2 10 for LUW. Watch our replay for details...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #92: Breaking News from IBM Canada with guest Les King

Les King, IBM

Special Guest: Les King, Director Data Management, IBM Canada

Breaking News from IBM! New IBM PureSystems!

100% of our studio audience learned something! Les shared with us information about new IBM PureData Systems for Transactions, Analytics, and Operational Analytics. No cost evaluations are available. Watch our replay for details...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #91: Top DB2 LUW Performance FAQs with Steve Rees, Part 2

Steve Rees, IBM

Special Guest: Steve Rees, Performance Specialist, IBM Canada

Top DB2 LUW Performance FAQs, Part 2

100% of our studio audience learned something! Steve talked about monitor table functions and admin views, strange numbers in the monitors, literals versus parameter markers in dynamic SQL, the Statement Concentrator (STMT_CONC) - when to use it and when not to use it, improving performance of LOBs, temporary tables, virtualizing DB2 workloads, tips for large partitions, and much more!!! Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #90: Top DB2 LUW Performance FAQs with Steve Rees, IBM

Steve Rees, IBM

Special Guest: Steve Rees, Performance Specialist, IBM Canada

Top 11 DB2 LUW Performance FAQs, Part 1

100% of our studio audience learned something! Steve talked about DB2 archive logs, solid state disk, prefetchers and cleaners, DB2_PARALLEL_IO, dirty steals, bulk insert performance, currently committed isolation level, and much, much more!!! Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #87: DB2 LUW Reducing CPU and I/O Consumption

Andrew Endicott

Special Guest: Andrew Endicott, DBA Manager, Cardinal Health

DB2 LUW Performance Tuning: Reducing CPU and I/O, Achieving Performance Gains, while lowering IT Infrastructure Costs

In our Season #3 finale, Scott Hayes was joined by Andrew Endicott, DBA Manager at Cardinal Health, for a lively discussion about DB2 LUW Performance Tuning. Andrew described how he has helped his organization avoid costly hardware and license upgrades while improving quality of service for his user community. Remarkably, all of this has been achieved while doubling the size of his SAP footprint and without adding any head count. How did Andrew achieve all this? Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #89: DB2 LUW 10 Performance Enhancements! PERFORMANCE!

Pat Bates

Special Guest: Pat Bates, WW Tech Sales, IBM

DB2 LUW 10.1 Performance Enhancements

100% of our audience learned something! Our special guest, Pat Bates, shared with our audience information about new features of DB2 10 that deliver remarkable performance gains. CPU Parallelism, Index Jump Scans, Zig-Zag Joins, Index Read-Ahead, and more were discussed! Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #88: DB2 LUW 10 Real-Time Data Warehousing

Pat Bates

Special Guest: Pat Bates, WW Tech Sales, IBM

DB2 LUW 10.1 Real-Time Data Warehousing

100% of our audience learned something! Our special guest, Pat Bates, shared with our audience information about the new INGEST utility and adaptive compression in DB2 10.1. Pat's presentation is rich with examples, illustrations, and sample DDL and SQL commands. Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #77: DB2 LUW 10 Temporal Queries and Analytics

Pat Bates

Special Guest: Pat Bates, WW Tech Sales, IBM

Temporal Queries and Analytics in an IBM InfoSphere Warehouse Environment

100% of our audience learned something! Our special guest, Pat Bates, shared with our audience information about temporal tables and queries in DB2 10.1. Pat's presentation is rich with examples, illustrations, and sample DDL and SQL commands. Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #86: DB2 LUW Workload Manager Best Practices - Updated!

Paul Bird

Special Guest: Paul Bird, STSM, IBM Canada

DB2 LUW Workload Manager Best Practices!
Replays available in WMV and MP4 formats!

100% of our audience learned something! Our special guest, Paul Bird, shared with our audience his latest work in the area of DB2 LUW Workload Manager Best Practices with a focus on data warehouse databases. He was joined by Serge Boivin, Senior Writer, IBM, who shared information about the portfolio of best practices papers that are available. Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #85: Advanced Application Design Techniques

Sanjay Kumar

Special Guest: Sanjay Kumar, Author

DB2 LUW Advance Application Design Techniques
Replays available in WMV and MP4 formats!

100% of our audience learned something! Our special guest, Sanjay Kumar, shared with our audience information from his book IBM DB2 9.7 Advanced Application Developer Cookbook. Sanjay covered Stored Procedures, OLAP Functions, DB2 Optimization Profiles, and many tips for writing good performing SQL! Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #84: DB2 LUW HADR Updates and Best Practices

Vikram Khatri, IBM

Special Guest: Vikram Khatri, IBM

DB2 LUW HADR: Updates and Best Practices
Replays available in WMV and MP4 formats!

100% of our audience learned something! Our special guest, Vikram Khatri, shared with our audience his expert advice, experience, and best practices on DB2 LUW HADR, including DB2 10.1 updates! Vikram provided sample commands and outputs! His presentation is your recipe for HADR success! Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #83: DB2 pureScale - WHAT EVERY DBA NEEDS to KNOW!

Maria Schwenger, IBM

Special Guest: Maria Schwenger, IBM

DB2 pureScale: CRUCIAL Things EVERY DBA Must Know!
Replays available in WMV and MP4 formats!

96% of our audience learned something! Our special guest, Maria Schwenger, shared with our audience her expert advice, experience, and best practices on DB2 pureScale. From installation to configuration, hardware, and monitoring, Maria covered "the works"! Several command examples were included as well. Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #82: DB2 LUW 9.7 Fixpack "Pearls" - cool new stuff!

Iqbal Goralwalla, Triton Consulting

Special Guest: Iqbal Goralwalla
Principal Consultant, Triton Consulting, UK

LISTAGG, db2cklog, db2pd, db2caem, db2support, and more!
Replays available in WMV and MP4 formats!

100% of our audience learned something! Our special guest, Iqbal Goralwalla, shared with our audience his advice, tips, and experience with new commands and features delivered via DB2 9.7 Fixpacks. His findings and advice are PRICELESS. Several command examples are presented. Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #81: DB2 LUW V10 Breaking News Part 2 with IBM Guests


Special Guests: Danny Arnold and Glen Sheffield
Destined to be another 2012 Top 10 Downloads Favorite!

DB2 LUW 10.1! Adaptive Compression, HADR, Time Travel Queries, ZigZag Joins, and MORE!
Replays available in WMV and M4V formats!

Again, 100% of our audience learned something! Our special guests, Danny Arnold, IBM Executive IT Specialist, and Glen Sheffield, IBM Toronto Data Warehouse and Big Data Specialist, shared with us Part 2 of our deep dive into What's New in DB2 LUW V10. Adaptive Compression, High Availability Disaster Recovery (HADR) Enhancements, Time Travel Queries, ZigZag joins, and more performance enhancements were discussed, and sample SQL commands were shared to illustrate the concepts! What did you miss? Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #80: DB2 LUW V10 Breaking News Part 1 with IBM Guests


Special Guests: Danny Arnold and Glen Sheffield
Destined to be a 2012 Top 10 Downloads Favorite!

DB2 LUW 10.1! STOGROUPS, WLM, RCAC, and More!
Replays available in WMV and M4V formats!

100% of our audience learned something! Our special guests, Danny Arnold, IBM Executive IT Specialist, and Glen Sheffield, IBM Toronto Data Warehouse and Big Data Specialist, shared with us Part 1 of our deep dive into What's New in DB2 LUW V10. Storage Groups, Workload Manager Enhancements, and Row and Column Access Controls were covered, and many example SQL commands were shared to illustrate the concepts! What did you miss? Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #79: The PROACTIVE DBA with guest Michael Tiefenbacher

Special Guest: Michael Tiefenbacher
Data Management Specialist, IDS Systems, Germany

Several Useful SQL Examples!
Replays available in WMV and M4V formats!

93% of our audience learned something! Our special guest, Michael Tiefenbacher, shared with our audience his advice and tips for reporting key database performance metrics to management. Michael provided several example SQL commands that you can use to report service levels, up-time, and more. Watch and learn...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #68: Problem Determination for SQL/PL, PL/SQL, & Triggers

Special Guest: Serge Rielau
STSM, IBM Canada

Destined for Top 25 of 2012!
Replays available in WMV and M4V formats!

96% of our audience learned something! Our special guest, Serge Rielau, Senior Technical Staff Member at IBM Canada, shared with our audience advanced techniques for problem determination in SQL/PL, PL/SQL, and triggers - complete with demonstrations! And, the source codes are available! If you use these capabilities of DB2 LUW, you must watch this show...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #66: Top 10 Tips for e-Commerce Databases, Ember Crooks

Special Guest: Ember Crooks
Technology Manager, Rosetta

Destined for "Most Popular" of 2012!
Replays available in WMV and M4V formats!

Over the top! Our special guest, Ember Crooks, Technology Manager for Rosetta, under committed and OVER DELIVERED! Each of her Top 10 tips for e-Commerce database success were filled with important ideas and considerations! While her focus was e-Commerce databases, many of her ideas and recommendations are applicable to OLTP databases in general. 97% of our studio audience indicated that they learned something! WHAT DID YOU MISS?? Watch the replay...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #64: Top Things I learned at IDUG EMEA

Special Guest: Norberto Gasparotto Filho, IBM
2011 DB2's GOT TALENT WINNER

In episode #64, our special guest Norberto did a brilliant job of highlighting the top things he learned while attending IDUG EMEA in Prague. It was like "IDUG's Greatest Hits." For each technical session that Norberto attended, he shared excerpts and some of the most important, most valuable tips. He also talked a bit about his IDUG experience and the great value that he received. 94% of our studio audience indicated that they learned something! (I suppose the other 6% attended IDUG EMEA themselves and this show was review) WHAT DID YOU MISS?? Watch the replay...



[ more .. ]
by scott in DB2 LUW

The DB2Night Show #61: Tips from DB2 Community Experts

90% of our studio audience indicated they learned something! During this show, we had two special guests. Thiru Swamy shared a terrific presentation that talked about how he uses the SAP DB2 DBA Cockpit to successfully analyze and tune DB2/SAP databases. Nadir Doctor offered up some very clever SQL to analyze a database for redundant indexes and the need to run RUNSTATS. Nadir's SQL is available within the IDUG Code Place. Watch and learn!

[ more .. ]
by scott in DB2 LUW
Page :  1 2 3 4 5 6