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

The DB2Night Show #Z67: SQL Performance Tuning in 2016

Presented by: Sheryl Larsen
Sr. DB2 Product – Specialist, BMC Software

"The DB2Night Show z67: SQL Performance Tuning in 2016"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Sheryl discussed SQL features and performance in the most recent versions of DB2. Watch the replay...



[ more .. ]
by martin in DB2 z/OS

The DB2Night Show #176: ALL ABOUT IDUG & DB2's GOT TALENT 2016 Winners!

IDUG NA 2016 Austin TX May 23-26 Details
@IDUGDB2
DB2's GOT TALENT 2016
  DB2's GOT TALENT 2016

ALL ABOUT IDUG Austin Texas May 23-26

plus DB2's GOT TALENT 2016 Winners!

1st Place Winner - IDUG Badge: Rohit Kumawat

2nd Place Winner - Apple iPad: Ankan Garg

87% of our audience learned something and 100% had a few good laughs! Terry Johnson, IDUG Chair, shared a great presentation about the IDUG conference that was packed with tips and advice, and we announced our DB2's GOT TALENT 2016 winners! Quite amazingly, "must be present to win" had incredible significance in the final outcome. Read on dear lovers of DB2...



[ more .. ]
by Scott in Cross Platform

The DB2Night Show #175: Block Party! DB2 LUW Bufferpool Tuning Techniques

Martin Hubel  on LinkedIn
@mhubel

Special Guest: Martin Hubel
IBM DB2 GOLD Consultant

DB2 LUW Bufferpool Tuning Techniques!

100% of our audience learned something! His memory is rock solid, his experiences are bountiful, and few people have mastered tuning DB2 LUW Bufferpool Memory like Martin Hubel has! You will learn the importance of block based bufferpools, how to configure them, how to monitor effectiveness, and much more! Please learn from, and enjoy, the replay...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #174: DB2's GOT TALENT -Round 4

DB2's GOT TALENT 2016

DB2's GOT TALENT 2016
ROUND #4 - Final Round!

1 Contestant Competes for YOUR Votes!

Judges and Guests give Presentations!

BREAKING NEWS: IBM & DBI Reception at IDUG!

Best show in a long time! Several top-notch, informative, presentations from a contestant, special guests, and our judges, plus breaking news about a BIG EVENT on 25 May 2016 at IDUG in Austin! Watch the entire replay for 65 minutes of pure education and enjoyment, or watch the YouTube videos to give our presenters the THUMBS UP they deserve! Watch...



[ more .. ]
by Scott in Cross Platform

The DB2Night Show #173: DB2's GOT TALENT -Round 3

DB2's GOT TALENT 2016

DB2's GOT TALENT 2016
ROUND #3!

2 Contestants Compete for YOUR Votes!

Great DB2 LUW and z/OS presentations!

Most of our studio audience learned something! We have a new format for our contest this year! Contestants only present ONE time, up to seven minutes, in hopes of earning votes from the DB2 community, their peers, and friends. Voting is achieved by simply LIKING videos on YouTube. We've embedded the videos herein for your convenience, plus we'll share the URLs for direct access. Cheers to your learning! Watch...



[ more .. ]
by Scott in Cross Platform

The DB2Night Show #172: DB2's GOT TALENT -Round 2

DB2's GOT TALENT 2016

DB2's GOT TALENT 2016
ROUND #2!

4 Contestants Compete for YOUR Votes!

Great DB2 LUW and z/OS presentations!

Most of our studio audience learned something! We have a new format for our contest this year! Contestants only present ONE time, up to seven minutes, in hopes of earning votes from the DB2 community, their peers, and friends. Voting is achieved by simply LIKING videos on YouTube. We've embedded the videos herein for your convenience, plus we'll share the URLs for direct access. Cheers to your learning! Watch...



[ more .. ]
by Scott in Cross Platform

The DB2Night Show #171: DB2's GOT TALENT -Round 1

DB2's GOT TALENT 2016

DB2's GOT TALENT 2016
ROUND #1!

3 Contestants Compete for YOUR Votes!

Great DB2 LUW and z/OS presentations!

Most of our studio audience learned something! We have a new format for our contest this year! Contestants only present ONE time, up to seven minutes, in hopes of earning votes from the DB2 community, their peers, and friends. Voting is achieved by simply LIKING videos on YouTube. We've embedded the videos herein for your convenience, plus we'll share the URLs for direct access. Cheers to your learning! Watch...



[ more .. ]
by Scott in Cross Platform

The DB2Night Show #170: DB2 LUW Data Security 102

Ian Bjorhovde on LinkedIn
@idbjorh

Special Guest: Ian Bjorhovde
Principal Consultant at DataProxy LLC

DB2 LUW Data Security 102

90% of our audience learned something! Security isn't sexy, but it is important, especially if you've been a victim of identity theft or endured a data breach. During this show, Ian Bjorhovde "The Master of DB2 Security" shares valuable information and advice on how to achieve a more secure DB2 database environment. Please learn from, and enjoy, the replay...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #169: DB2 LUW WLM (Workload Manager) Monitoring Features

Michael Tiefenbacher on LinkedIn
@globomike

Special Guest: Michael Tiefenbacher
Manager Business Services & Data Management Specialist at ids-System

Facilitate WLM Functions and Tools to Improve Your DB2 LUW Monitoring

100% of our audience learned something! If you don't have tools, you need to be clever about monitoring DB2 with built-in monitoring capabilities. During this show, Michael does a great job of explaining how DB2 Workload Manager (WLM) features and functions can be used for capturing and analyzing SQL, histograms, and system statistics. Enjoy the replay ...



[ more .. ]
by Scott in DB2 LUW

DB2 11 for z/OS: Some personal favorites

Presented by: Martin Hubel
Martin Hubel Consulting Inc.

"The DB2Night Show z66: DB2 11 for z/OS: Some personal favorites"
Replays available in WMV and M4V formats!

This show discussed some of the important but less presented features of DB2 11 including archive tables and new grouping functions. Watch the replay...



[ more .. ]
by martin in DB2 z/OS

The DB2Night Show #168: DB2 LUW Advanced Index Benefit Analysis

Scott Hayes, President DBI Software, IBM DB2 GOLD Consultant
@srhayes :: @db2performance

Special Guest: Scott Hayes, DBI Software

Sage DB2 LUW Performance Advice
Advanced Index Benefit Analysis
BLU Table Convert Row to Column Analysis

100% of our audience learned something! In Sage Advice Part 1 during Episode #142, Scott teaches audiences how to find the biggest problems in DB2 based on weights. In Sage Advice Part 2 during this Episode, Scott teaches audiences how to accurately determine the benefit of each index recommended by IBM program "db2advis". As a bonus, if you are using DB2 10.5, Scott provides a methodology and queries for quickly and easily determining if a Row based table should be converted to BLU Column based. Sage Advice Part 3 "Predictive Index Impact Analysis" will be offered at IDUG conferences in 2016 - hope to see you in AUSTIN Texas at IDUG! Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #167: Annual Eggnog Party with DB2 Experts Panel

Eggnog Party!

Special Guests: Mike Winer, David Kalmuk, Matt Huras, John Hornibrook, Adam Storm, Melanie Stopfer, Iqbal Goralwalla, Ian Bjorhovde, Michael Tiefenbacher, Mohan Saraswatipura, Ember Crooks, Cristian Molaro, Klaas Brant, Martin Hubel, David Simpson, and Scott Hayes

Eggnog Party!
Celebrating 2015 with 2016 Insights!

95% of our audience learned something! 5% attended for the eggnog, fun, and insights! We sang, we danced, and we learned what was great about DB2 in 2015 and what people are looking forward to in 2016! Scott got a little crazy with twinkling DB2 Experts. Watch or listen, and learn...



[ more .. ]
by Scott in Cross Platform

The DB2Night Show z65: Implementing Expanded RBA/LRSN in DB2 11 for z/OS

Presented by: David Simpson
Themis Education

"The DB2Night Show z65: Implementing Expanded RBA/LRSN in DB2 11 for z/OS"
Replays available in WMV and M4V formats!

This information is timely for the multitude of companies moving to DB2 11! David covered the many aspects of the expanded LRSN /RBA. Watch the replay...



[ more .. ]
by martin in DB2 z/OS

The DB2Night Show #166: DB2 LUW Tips, Tricks, SQL, & Scripts for Lazy DBAs

Pavan Kristipati on LinkedIn
@pkristipati

Special Guest: Pavan Kristipati, Sr. DBA, Huntington Bank

DB2 LUW Tips, Tricks, SQL, and Scripts for Lazy DBAs

96% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he details many of his tricks and techniques to make his DBA job easier and faster! Several examples are given and you can get his PDF! According to Pavan, these time saving techniques save him 30-60 minutes every day! Watch our replay for details...



[ more .. ]
by Scott in DB2 LUW

Z64: Understand IBM Disk and Tape Virtualization

Presented by: John Iczkovits
Senior IT Specialist - IBM

What Every DB2 for z/OS Professional Needs to Understand about IBM Disk and Tape Virtualization

EVERYBODY (100%) in our audience learned something! John did an excellent job on explaining what disk and tape virtualization is. Do you want to know what that is? Then watch, learn and enjoy...



[ more .. ]
by klaas in DB2 z/OS

The DB2Night Show #165: DB2 LUW Real World Essentials

Mohan Saraswatipura, Author Kent Collins, Author
Authors of DB2 LUW 10.1/10.5 Certification Study Guide

Special Guests: Mohan Saraswatipura & Kent Collins

Real World DB2 LUW
DBA Essentials!

100% of our audience learned something! Our guests talked about DB2 pureScale efficient page reclaims, understanding connection methods and member subsets, compression techniques with comparisons, and replicated MQT problems and solutions. Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #164: 8 High-Impact Performance Tuning Tips for DB2 LUW

Ember Crooks, IBM DB2 GOLD Consultant

@ember_crooks

Special Guest: Ember Crooks
DB2 Lead DBA & Delivery Manager, Xtivia
IBM DB2 GOLD Consultant

8 High-Impact Performance Tuning Tips
for DB2 LUW OLTP & E-Commerce Databases

97% of our audience learned something! Want to make your OLTP databases run faster? Ember offered eight terrific tips and sage advice for getting maximum performance from your transactional databases! Index Read Efficiency, finding problem SQL, finding index solutions, finding bad indexes and dropping them, pruning data, HADR impacts, when to use STMM and when NOT to use it, using parameter markers or STMT_CONC, and optimal use of Solid State Disk (SSD). Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show z63: DB2 for z/OS DBaaS & Advantages of Automated Objects

Presented by: Dan Luksetich
DanL Consulting Inc.

"The DB2Night Show z63: DB2 for z/OS DBaaS and The Advantages of Automated Objects"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! This is a must-see show. Taking the new terminology of database as a service (DBaaS), Dan presented the features in DB2 for z/OS that help reach that goal. Watch the replay...



[ more .. ]
by martin in DB2 z/OS

The DB2Night Show #163: DB2 LUW BLU Concepts and Best Practices

Matt Huras, IBM DE

@db2guy

Special Guest: Matt Huras
IBM DE, Chief Architect DB2 LUW

DB2 LUW BLU
Concepts and Best Practices!

100% of our audience learned something! Matt Huras fills session rooms at IDUG conferences, and today our studio audience size was rather large as well. And, it is no wonder - Matt has a gift for explaining complicated technical things and making them understandable. He's an excellent presenter too. As Chief Architect for DB2 LUW, who would know better about how DB2 works!?!? Enjoy our replay! Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #162: DB2 LUW pureScale Performance with Steve Rees, IBM

Steve Rees, IBM STSM
@db2steve

Special Guest: Steve Rees, IBM STSM

DB2 LUW pureScale Performance
Config, Monitoring, and Best Practices!

100% of our audience learned something! Steve is one of the top DB2 LUW performance gurus at the IBM Canada Lab, and he gives great presentations too! Today was no exception! Steve covered recommended configurations, how to monitor DB2 pureScale, and offered his sage advice based on his worldly experiences. Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show Z62: Where is the BiF?

Presented by: Roy Boxwell
Sr. DB2 Product Specialist
Segus / Software Engineering

Where is the BiF?

EVERYBODY (100%) in our audience learned something! Roy did a great job on explaining what can go wrong with the buitin functions (BiF's) when moving to DB2 11. Do you want to know what's new? Then watch, learn and enjoy...



[ more .. ]
by klaas in DB2 z/OS

The DB2Night Show #161: DB2 LUW Security & Auditing with Melanie Stopfer

Melanie Stopfer, IBM DB2 LUW Brain Surgeon

Special Guest: Melanie Stopfer, IBM DB2 LUW Brain Surgeon

Who's Knocking at Your Door?
DB2 LUW Security & Auditing

100% of our audience learned something! No surprises there! Everyone learns from Melanie! For our season #7 kickoff, Melanie gave our audience the complete scoop on DB2 LUW auditing how-to's, best practices, and some gotchas! You'll learn advice on DB2 LUW security too! And, hey, who wants to be in the news for a data breach or the victim of identity theft?!?! Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #Z61: DB2 in the Digital Age

Presented by: Sheryl Larsen
Sr. DB2 Product – Specialist, BMC Software

"The DB2Night Show z61: DB2 in the Digital Age"
Replays available in WMV and M4V formats!

90% of our studio audience learned something!Sheryl took a look into the future of technology and DB2's role. Watch the replay...



[ more .. ]
by martin in DB2 z/OS

The DB2Night Show #160: Top 10 DB2 LUW Explain Tips with John Hornibrook

John Hornibrook, STSM, IBM Canada

Special Guest: John Hornibrook, STSM, IBM Canada

Top 10 DB2 LUW Explain Tips

100% of our audience learned something! John Hornibrook is one of the top IBM brains behind DB2's optimizer. In this helpful presentation, John shares some invaluable tips for using and understanding DB2's Explain capabilities. You will learn the best ways to create Explain tables, upgrade them, and empty them, how to see actual cardinality values, how to determine if access plans have changed, and much more! Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show z60: SQL Performance for Big Data 22B row data warehouse

Presented by: Dave Beulke
Dave Beulke and Associates

"The DB2Night Show z60: SQL Performance for a Big Data 22 Billion row data warehouse"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Dave shared a wealth of SQL tuning tips aimed at very large DW environments. A must-see! Watch the replay...



[ more .. ]
by martin in DB2 z/OS

The DB2Night Show #159: DB2 LUW 10.5 BLU Monitoring In-Depth

David Kalmuk, STSM, IBM Canada

Special Guest: David Kalmuk, STSM, IBM Canada

IBM DB2 LUW 10.5 BLU Monitoring In-Depth

100% of our audience learned something! DB2 10.5 and its various fixpacks have introduced many new monitoring capabilities. During this show, David taught us what is new and how to use the new information. His presentation is loaded with great SQL examples too! Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #Z59: Comparing DB2 to Oracle

Presented by: Sheryl Larsen
Sr. DB2 Product – Specialist, BMC Software

"The DB2Night Show z59: Comparing DB2 to Oracle"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Sheryl gave a deep dive comparison of DB2 on z/OS to Oracle. Watch the replay...



[ more .. ]
by martin in DB2 z/OS

The DB2Night Show #158: DB2 LUW HADR ROS Success with Sanjay Trehan

Sanjay Trehan, Sr. DBA

Special Guest: Sanjay Trehan, Sr. DBA

DB2 LUW HADR ROS (Read on Standby) Success Story---
Continuous availability for over 8 years!

98% of our audience learned something! 84% of our live studio audience indicated that they use HADR with 41% indicating they use the ROS capability. In this unique show, our special guest is a real DB2 customer user! Sanjay and his team have a great success story to share! Through his presentation, you will learn about DB2 configuration parameters to optimize HADR performance, Websphere settings, and other best practices to achieve remarkable DB2 LUW availability! Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show z58: Must knows about DB2 for z/OS Distributed - Part 2

Presented by: Cristian Molaro
IBM Champion and Gold Consultant

"The DB2Night Show z58: Must knows about DB2 for z/OS Distributed - Part 2"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Cristian continued his excellent presentation on distributed configuration and many other topics. Watch the replay...



[ more .. ]
by martin in DB2 z/OS

The DB2Night Show #157: DB2 LUW 10.5 FP5 New Encryption with George Baklarz

George Baklarz, IBM

Special Guest: George Baklarz, IBM

DB2 V10.5 FP5 New Encryption
WMV, MP4, & PDF Available!

100% of our audience learned something! By George, IBM got Encryption Right! Beginning in DB2 LUW 10.5.5, full instance, database, and related objects and files can be easily encrypted. 89% of our studio audience indicated that "We should give due consideration to using it!" when asked "After George's presentation, what do you think about using the DB2 encryption feature?" Watch and learn...



[ more .. ]
by Scott in DB2 LUW
Page :  1 2 3 4 5 6 7 8 9 10