The DB2Night Show #177: Sneak Peek Overview of What's New in DB2 LUW V11.1

Learn about IBM DB2 LUW V11.1 Announcement
@ibm_db2 ::: @db2guy

Learn more about IBM DB2 V11.1
on IBM.com

What's New in DB2 LUW V11.1 - Overview

Special Guests:
Matt Huras,
Chief Architect DB2 LUW

Berni Schiefer,
IBM Fellow

97% of our audience learned something! A new version of DB2 LUW is born! V11.1 will be generally available mid-June 2016. Almost 75% of our HUGE live studio audience indicated that they were very excited about the new features and capabilities becoming available in V11. V11 includes many enhancements for BLU, Analytics, OLTP, pureScale, security, SQL, and more! Please learn from, and enjoy, the replay...



[ more.. ]


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


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


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


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


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


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


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


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


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


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


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


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


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


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


The DB2Night Show #156: Using and Optimizing DataStage and DB2

Michael Tiefenbacher on LinkedIn
@globomike

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

Using and Optimizing DataStage and DB2

100% of our audience learned something! DataStage is a very popular ETL tool that is used with IBM DB2 LUW. Michael offered some very valuable advice on how to maximize performance in DPF and non-DPF environments. Enjoy the replay ...



[ more.. ]


The DB2Night Show #154: DB2's GOT TALENT - Grand Finale!

DB2's GOT TALENT 2015

DB2's GOT TALENT 2015
GRAND FINALE!

Top 5 Finalists Compete for YOUR Votes!

Great DB2 LUW presentations!

100% of our studio audience learned something! Today's presentations included topics on tuning production DB2 LUW Databases (Challenges and Solutions), Getting Connections to DB2 databases in restricted intranets (tunneling in secure environments), Pursuit of Happiness- Achieving Performance beyond SLAs, and "db2pd" - more than just problem determination! This show contains another buffet of useful tips and advice! Enjoy!



[ more.. ]


The DB2Night Show #153: DB2's GOT TALENT - Finals Round 3 - Top 6 Compete!

DB2's GOT TALENT 2015

DB2's GOT TALENT 2015
Finals Round #3

Top 6 Finalists Compete for YOUR Votes!

Great DB2 LUW presentations!

100% of our studio audience learned something! Today's presentations included topics on IBM DB2 LUW Oracle Compatibility, scheduling db2top via crontab, monitoring enhancements for BLU columnar tables, lessons learned on defining disk storage, where to get, and how to install, free drivers for DB2 10.5 Express-C, and how to connect Java to DB2 via Hibernate for good performance! This show contains another buffet of useful tips and advice! Enjoy!



[ more.. ]


The DB2Night Show #150: DB2 LUW 10.1/10.5 Certification Crammer Part 2

DB2 10.1/10.5 Certification Book on Amazon.com
See the book on Amazon.com

Special Guests: Mohan Saraswatipura & Kent Collins, Authors

DB2 LUW 10.1/10.5 Certification Crammer,
Part 2

No surprise! Again, 100% of our audience learned something! Mohan and Kent did a great job introducing their new forthcoming DB2 Certification book, plus they taught various topics from the book! The book will be available 24 April 2015, but you can pre-order it now and save money! Watch today's show and learn about DB2 PureScale, DB2 BLU Columnar Storage, DB2_WORKLOAD, capabilities, features, advice, and FACTS you need to know to pass the Certification Test!! Enjoy...



[ more.. ]


The DB2Night Show #148: DB2 LUW 10.1/10.5 Certification Crammer Part 1

DB2 10.1/10.5 Certification Book on Amazon.com
See the book on Amazon.com

Special Guests: Mohan Saraswatipura & Kent Collins, Authors

DB2 LUW 10.1/10.5 Certification Crammer,
Part 1

No surprise! 100% of our audience learned something! Mohan and Kent did a great job introducing their new forthcoming DB2 Certification book, plus they taught various topics from the book! The book will be available 24 April 2015, but you can pre-order it now and save money! Watch today's show and learn about DB2 9.7 FP3 Database Schema Transport, DB2 10.1 Storage Groups, DB2 10.1 Multi-Temperature Storage, DB2 10.1 System Period Temporal Tables, and DB2 10.5 Shadow Tables! Enjoy...



[ more.. ]


The DB2Night Show #147: DB2's GOT TALENT - LUW Auditions

DB2's GOT TALENT 2015

It's the International DB2 Olympics!

Today's Finalist Winners: Brandon, Roberto, Pratik, Sreeharsha, & Rohit

94% of our studio audience learned something! Today's presentations were surprisingly good considering that we had contestants from New Zealand, Mexico, and India! It fascinates me that we can gather around our computers and learn from industry peers all over the world. You will learn about improved indexes in V10.5, locking analysis and tips, how to improve Federated DB2 performance, a method to achieve high availability for DB2 10.5 using OS Clusters, insights from a DB2 z/OS DBA that experimented with DB2 LUW Express-C, and experiences with testing DB2 10.5 columnar tables with storage and performance results. Truly, this show contains a buffet of useful tips and advice! Enjoy!



[ more.. ]


The DB2Night Show #146: 5+ Cool Tricks for DB2 LUW, Adam Storm, IBM STSM

Adam Storm on LinkedIn
@stormadamj

Special Guest: Adam Storm, Master Inventor & STSM, IBM Canada Lab

5+ Cool Tricks for DB2 LUW

100% of our audience learned something! Based on his popular and humorous IDUG presentations, Adam treats our audience to his wit and wisdom for DB2 LUW --- and even includes a bonus trick! #6! You will learn about STMM - how it works and ideas for monitoring it, a secret decoder ring for db2diag.log, Workload Manager and how to pull pranks on your friends, how NOT to use db2dart, and more! Enjoy...



[ more.. ]


The DB2Night Show #145: db2pd Party with Melanie Stopfer, IBM

Melanie Stopfer on LinkedIn
@mstopfer1

Special Guest: Melanie Stopfer, DB2 Brain Surgeon, IBM Software Group

db2pd Party! The Power of db2pd!

99% of our audience learned something! Who knew that there were so many options for the powerful and popular "db2pd" command? Not only did Melanie share dozens of db2pd command examples and tips, but she also compared and contrasted to various MON_GET function calls and SQL commands. Bonus! Melanie also talked about DB2 security, trusted contexts, HADR, locking, indexes, and more! Enjoy...



[ more.. ]


The DB2Night Show #143: HADR & TSAMP Advanced Topics - Ember Crooks

Ember Crooks, Xtivia, IBM DB2 GOLD Consultant
@ember_crooks :: Blogs @ DB2Commerce.com

Special Guest: Ember Crooks, Xtivia
IBM DB2 GOLD Consultant

HADR and TSAMP
Advanced Topics!

100% of our audience learned something! Usually during webinars most people will wander off and peak at their email or do some holiday shopping, BUT NOT TODAY! Our studio audience attendees were super glued to Ember's awesome presentation! Not only did 100% learn something, but Attendees rated the Educational Value a 4.95 on a scale of 1-5! Watch and learn...



[ more.. ]


The DB2Night Show #142: DB2 LUW Sage Performance Advice with Scott Hayes

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

Special Guest: Scott Hayes, DBI Software

Sage DB2 LUW Performance Advice
A "New" Way to Analyze Performance

100% of our audience learned something! Based on his IDUG Phoenix Top 10 presentation, Scott presents a new way to think about and analyze DB2 LUW performance. Today's show even includes a 6 minute video clip taken from IDUG in Prague. ATTENDEES will receive all the cool SQL commands electronically! Watch and learn...



[ more.. ]


The DB2Night Show #141: DB2 LUW V10.5 CANCUN Shadow Table Experiences

Iqbal Goralwalla, Triton Consulting
@iqbalgoralwalla

Special Guest: Iqbal Goralwalla, Triton Consulting

DB2 V10.5 FP4 "Cancun" Shadow Tables
and pureScale "Lite"
Early Hands-on Experiences

100% of our audience learned something! During today's show, Iqbal gave us an excellent presentation on his early user experiences with IBM BLU CANCUN (aka 10.5.0.4) Shadow Tables and pureScale "Lite". You will see performance results and many excellent recommendations on DB2 configuration settings, registry settings, and physical design. Watch and learn...



[ more.. ]


The DB2Night Show #140: DB2 LUW V10.5 CANCUN with George Baklarz

George Baklarz, IBM

Special Guest: George Baklarz, IBM

DB2 V10.5 FP4 "Cancun"

100% of our audience learned something! During today's show, George shared with us the significant improvements and enhancements that are delivered via Fixpack 4 of DB2 V10.5 BLU. You will learn about shadow tables, pureScale enhancements, improved Oracle compatibility and compression, improved performance, and more! Watch and learn...



[ more.. ]


The DB2Night Show #139: DB2 LUW db2batch command Tips and Advice

Paul Turpin on LinkedIn
@pault99

Special Guest: Paul Turpin, Sr. DBA, BB&T Bank

Advanced "db2batch" command Tips and Techniques

98% of our audience learned something! During today's show, Paul shared his excellent IDUG presentation in which he details his experiences, tips, and advice for using the IBM DB2 LUW "db2batch" command. There are many options to consider. By using the right options, you can Run and Explain your SQL, limit outputs, and choose various levels of performance details. Watch our replay to learn all the tricks...



[ more.. ]


The DB2Night Show #138: Upgrading to DB2 V10.5 Best Practices!

Melanie Stopfer on LinkedIn
@mstopfer1

Special Guest: Melanie Stopfer, DB2 Brain Surgeon, IBM Software Group

Upgrading to IBM DB2 LUW V10.5 Best Practices and tips!

100% of our audience learned something! Our studio audience was filled with inspiration and gratitude for Melanie's presentation! Watch our replay and you will see a complete cookbook for how to upgrade, what to watch out for, undocumented tricks that will speed up your upgrade, and even a recipe for falling back to your original release if your upgrade has a hiccup! With 34% of our DB2 community currently running V10.5, the timing for this presentation is "just right" and it will undoubtedly be in our top Replays for 2014! Enjoy...



[ more.. ]


The DB2Night Show #137: IBM CLOUD UPDATE with Leon Katsnelson

Leon Katsnelson on LinkedIn
@katsnelson

Special Guest: Leon Katsnelson, Director, Information Management Cloud & Mobile, IBM Canada

IBM CLOUD UPDATE!

100% of our audience learned something! Awesome! IBM has three pillars of priorities: 1) Cloud, 2) Analytics (big data), and 3) Engagement (including mobile). If you check Leon's title again (above), LEON IS THE MAN covering two of the three important IBM priorities! Leon gave us an excellent presentation on Cloud computing plus an impressive demo! Check out our polling questions to see what your peers think about Cloud! Watch our replay for details...



[ more.. ]


Page :  1 2 3 4 5 6