About Services Products Stories Events Contact

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

June 29, 2012, 4:01 pm
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 #76: Netezza Architecture, Compression, Performance, ...

June 28, 2012, 8:13 pm
Pat Bates

Special Guest: Pat Bates, WW Tech Sales, IBM

High Performance Analytical Data Warehouse using IBM Netezza Appliance 1000 - Best Practices

Our serial guest, Pat Bates, shared with our audience information about Netezza! He covered architecture, the "secret sauce", compression, performance, administration, do's and don'ts, and best practices too. Watch and learn...



[ more.. ]


by scott in Cross Platform

The DB2Night Show Z27: Explaining EXPLAIN - DB2 10 Edition

June 28, 2012, 10:27 am

Presented by: Willie Favero
Senior Certified Consulting IT Software Specialist Data Warehouse for System z Swat Team - DB2 SME

Explaining EXPLAIN - DB2 10 Edition
Replays available in WMV and M4V formats!

EVERYBODY (100%) in our audience learned something! Our studio poll showed that explain is not a piece of cake. But Willie did a great job on explaining all the new thhings in explain. Do you want to know what's new? Then watch, learn and enjoy...



[ more.. ]


by klaas in DB2 z/OS

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

June 27, 2012, 11:53 am
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

June 26, 2012, 3:58 pm
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

June 25, 2012, 2:13 pm
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!

June 22, 2012, 2:06 pm
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

June 15, 2012, 3:47 pm
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

June 8, 2012, 5:41 pm
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 Z26: Memory Management in DB2 10 for z/OS

June 7, 2012, 10:12 am

Presented by: Julian Stuhler
An IBM Gold Consultant, Data Champion and former IDUG President - Director / Head of Solutions Delivery at Triton Consulting - UK

Memory Management in DB2 10 for z/OS
Replays available in WMV and M4V formats!

98 % of our audience learned something! The one thing we cannot enough from is memory. DB2 has always had a reputation for being memory hungry. Any idea where all that memory goes? Then watch, learn and enjoy...



[ more.. ]


by klaas in DB2 z/OS

The DB2Night Show Z25: Hash Access - The HDAM DB2 Table?

May 31, 2012, 10:08 am

Presented by: Phil Grainger
IBM Champion - Grainger Database Solutions Ltd. - UK

Hash Access - The HDAM DB2 Table?
Replays available in WMV and M4V formats!

100% of our audience learned something! Today we have a topic that makes IMS people smile. DB2 has a new type of table called hashing which looks a lot like a HDAM database in IMS. Back to the future! No idea what HDAM is? Then watch, learn and enjoy...



[ more.. ]


by klaas in DB2 z/OS

The DB2Night Show Z23: Information Governance for MDM and Reference data

May 29, 2012, 10:35 am

Presented by: Jan Henderykcx
IBM Gold Consultant - Envizion Cvba - Belgium

Information Governance for MDM and Reference data. Replays available in WMV and M4V formats!

95% of our audience learned something! Today we have a "off-topic" subject. Not hard-core but very interesting! Do you want to know more about Master Data Management is? Then watch, learn and enjoy...



[ more.. ]


by klaas in DB2 z/OS

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

May 25, 2012, 1:38 pm
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 Z24: DB2 Utilities - An update

May 17, 2012, 10:15 am

Presented by: Klaas Brant
IBM Gold Consultant - KBCE b.v.

DB2 Utilities - An update
Replays available in WMV and M4V formats!

98% of our audience learned something! Today we have a whole chapter from the official KBCE DB2 V8 to V10 training. All about utilities and what has changed in V9 and V10. Watch, learn and enjoy...



[ more.. ]


by klaas in DB2 z/OS

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

May 11, 2012, 12:22 pm
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

May 4, 2012, 5:37 pm

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 Z22: Essential things you must know about DB2 and WLM

May 3, 2012, 10:30 am

Special Guest: Cristian Molaro
IBM Gold Consultant - Mconsulting

Essential things you must know about DB2 and WLM
Replays available in WMV and M4V formats!

98% of our audience learned something! Our special guest, Cristian Molaro, presented about WLM in a very practical way. This session has many hints and tips how to get the maximum out of DB2 with WLM enabled as performance manager. Did you know that DDF runs at a very low priority when you run with default WLM settings? This is just one of the tips from Cristian. Watch, learn and enjoy...



[ more.. ]


by klaas in DB2 z/OS

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

April 27, 2012, 12:55 pm

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

Episode #Z21: DB2 10 Data Sharing: New Features and Member Consolidation

April 26, 2012, 10:51 am

Special Guest: Susan Lawson
IBM Gold Consultant - Principal YL&A Inc.

All about new features in DB2 10 and member consolidation
Replays available in WMV and M4V formats!

98% of our audience learned something! Our special guest, Susan Lawson, presented what is new in Data Sharing in the DB2 10 release. Her second part is all about member consolidation. As you will see in the presentation is removing members a task that needs a lot of planning. Watch and learn...



[ more.. ]


by klaas in DB2 z/OS

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

April 22, 2012, 10:16 am

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

Episode #78: All About IDUG and DB2's GOT TALENT Winners!

April 13, 2012, 11:05 am

Thank you IDUG and DB2's GOT TALENT Contestants!
Get Insider Tips on IDUG and Learn who Won DB2's GOT TALENT!

Replays available in WMV and M4V formats!

89% of our audience learned something! Special guests Rob Crane and Vijay Sitaram from IDUG shared with us their tips and advice for making the most of your IDUG DB2 Tech Conference Experience. And, we announced 2012 DB2's GOT TALENT Winners! Get the details...



[ more.. ]


by scott in Cross Platform

Episode #75: DB2's GOT TALENT Finals Round #3! Watch, Learn, and VOTE!

March 30, 2012, 12:52 pm

Thank you Top 7 Finalists!
Another Buffet of DB2 LUW and z/OS Tips and Advice

Replays available in WMV and M4V formats!

100% of our audience learned something! Our Top 4 Finalists need YOUR votes! Their futures and BIG prizes depend on impressing YOU with their sage advice and presentation skills! Watch the replay, learn valuable DB2 LUW and z/OS tips and techniques, and then cast your votes for the finalists that impressed you the most!



[ more.. ]


by scott in Cross Platform

Episode #74: DB2's GOT TALENT Finals Round #2! Watch, Learn, and VOTE!

March 16, 2012, 11:30 am

Thank you Top 10 Finalists!
Another Buffet of DB2 LUW and z/OS Tips and Advice

Replays available in WMV and M4V formats!

96% of our audience learned something! Our Top 10 Finalists need YOUR votes! Their futures and BIG prizes depend on impressing YOU with their sage advice and presentation skills! Watch the replay, learn valuable DB2 LUW and z/OS tips and techniques, and then cast your votes for the finalists that impressed you the most!



[ more.. ]


by scott in Cross Platform

Episode #73: DB2's GOT TALENT Finals Round #1! Watch, Learn, and VOTE!

March 2, 2012, 7:01 pm

Thank you Top 10 Finalists!
Another Buffet of DB2 LUW and z/OS Tips and Advice

Replays available in WMV and M4V formats!

95% of our audience learned something! Our Top 10 Finalists need YOUR votes! Their futures and BIG prizes depend on impressing YOU with their sage advice and presentation skills! Watch the replay, learn valuable DB2 LUW and z/OS tips and techniques, and then cast your votes for the finalists that impressed you the most!



[ more.. ]


by scott in Cross Platform

The DB2Night Show #72: DB2's GOT TALENT Contestant Auditions 4

February 24, 2012, 4:17 pm

Congratulations Ember, Brian, and Jean!
Another Buffet of DB2 LUW Tips and Advice

Replays available in WMV and M4V formats!

90% of our audience learned something! Today's "special guests" included seven contestants that shared some very helpful and creative DB2 LUW tips. Our judges chose their favorite three to advance to the March finals. Watch the replay to learn about tips for Online Index Reorgs, Testing Recovery Strategies, using Workload Manager, debugging CPU spikes, maintaining 24x7 availability while implementing schema and application changes, virtual indexes, optimizing Prefetch I/O, and advice for using the DB2 LOAD utility!



[ more.. ]


by scott in Cross Platform

The DB2Night Show #71: DB2's GOT TALENT Contestant Auditions 3

February 17, 2012, 12:38 pm

Congratulations Rodolfo and Kingo!
Another Buffet of DB2 Tips and Advice

Replays available in WMV and M4V formats!

At GOLD's Gym, there is a sign on the front door that reads "The hardest part is simply showing up." We were supposed to have seven contestants today. One had audio problems and three didn't show up. Of the three that showed up and presented, our judges chose two finalists. While it wasn't our best show, 75% of our studio audience indicated they learned something. There are some good tips...



[ more.. ]


by scott in Cross Platform

The DB2Night Show #70: DB2's GOT TALENT Contestant Auditions 2

February 10, 2012, 4:50 pm

Congratulations Kohli and Elder!
A Buffet of DB2 LUW Tips and Advice

Replays available in WMV and M4V formats!

100% of our audience learned something! Today's "special guests" included six contestants that shared some very helpful and creative DB2 LUW tips. Our judges chose their favorite two to advance to the March finals. Watch the replay to learn about redirected restores, alternatives to db2imigr and db2iupgrade, statistical views, the db2gcf command, MQTs, and the ADMIN_MOVE_TABLE stored procedure! Watch the replay, learn, and VOTE!



[ more.. ]


by scott in Cross Platform

The DB2Night Show #69: DB2's GOT TALENT Contestant Auditions 1

February 3, 2012, 2:48 pm

Congratulations Richard, Douglas, and Yonghang!
A Buffet of DB2 LUW Tips and Advice

Replays available in WMV and M4V formats!

96% of our audience learned something! Today's "special guests" included five contestants that shared some very helpful and creative DB2 LUW tips. Our judges chose their favorite three to advance to the March finals. Watch the replay to learn about the "db2greg" command, performance tips for migrating from Oracle to DB2 LUW, an excellent technique for diagnosing lock contention, and much more!



[ more.. ]


by scott in Cross Platform

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

January 27, 2012, 1:26 pm

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 #Z20: Data Skew and Real World Performance Solutions

January 24, 2012, 12:39 am

Special Guest: Cristian Molaro
IBM DB2 GOLD Consultant

Expert Advice and Solid Solutions
Replays available in WMV and M4V formats!

98% of our audience learned something! Our special guest, Christian Molaro, DB2 Independent Specialist, shared with our audience the perils of Data Skew and provided solid, workable performance solutions. What did you miss? Watch the replay...



[ more.. ]


by scott in DB2 z/OS
Page :  1 2 3 4 5 6 7 8 9 10 
 
© 2017 DBI Software. All rights reserved.
Sitemap :: Services :: Downloads :: Home :: Privacy :: Legal