The DB2Night Show #209: The Perfect Db2 Server and What's New Db2 V11.1.4.4

Klaas Brant, KBCE, IBM Gold Consultant

@klaas_brant

Special Guest: Klaas Brant
Owner, KBCE
IBM Gold Consultant

The PERFECT Db2 Server!
Bonus: What's New in Db2 V11.1.4.4

100% of our audience learned something!Klaas Brant's presentation was amazing! From monitoring commands to configuration recommendations, Klaas covered it all! Watch our replay to learn MON_GET queries, OS commands, configuration settings, and best practices for making your Db2 servers run optimally! What's more, Kelly Rodger ( @kdrodger ) from the IBM Canada Lab briefed us on What's New in Db2 V11.1.4.4!



[ more.. ]


The DB2Night Show #208: 10 Minute Triage: Troubleshooting Db2 Performance

Michael Krafick, IBM Champion, Sr. DBA

@MKrafick

Special Guest: Michael Krafick
IBM Champion
Senior DBA

10 Minute Triage: Troubleshooting Db2 LUW Production Issues

100% of our audience learned something!Per Michael's tweet this morning, "I will teach you how to say #holdmybeer while triaging #Db2 on production databases." Downtime is expensive. Most DBAs have been in the hot seat with management demanding rapid information and problem resolution. Michael shares his robust triage plan. Watch and learn from an experienced pro...



[ more.. ]


The DB2Night Show #207: Db2 News from the IBM Canada Lab with Les King

Les King, Director, IBM Canada Lab

@LesKing00

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

Db2 News from IBM Canada Lab

93% of our audience learned something!We kicked off our 10th season of The Db2Night Show with Db2 News presented by Les King. All of the advances and updates with IBM Data Management are pretty amazing. Watch our replay and learn about pureScale, BIGSQL, Db2 Event Store, Cloud, Hadoop, and more! Watch and learn...



[ more.. ]


The DB2Night Show #204: Db2 LUW success story with SAP on AWS

Arwel Owen
Follow @sap_aws

Special Guest: Arwel Owen, Enterprise Systems Manager, Princess LTD, UK

Db2 LUW Success Story with SAP on AWS

83% of our audience learned something! 17% of our audience were Arwel's co-workers! icon_lol Arwel completed a VERY successful migration from Oracle to Db2, and then another migration to Db2 V11.1.2.2 SAP on AWS Cloud. The compression, cost savings, and performance results are simply ASTOUNDING! Watch our fun and informative replay for details...



[ more.. ]


The DB2Night Show #206: A crash course on Db2 pureScale and Advantages

Mohan and Kent
Follow @mohankumarsp
Follow @rcollins963

Special Guests: Kent Collins and Mohan Saraswatipura, Authors

A crash course on Db2 pureScale and Advantages

100% of our audience learned something! Kent provided a wealth of excellent information on Db2 pureScale including best practices, database manager configuration settings, database configuration settings, registry variables, HADR considerations, how to size memory, monitoring, workload manager (WLM), and much more! Get the PDF for reference AND watch our replay so that you don't miss Kent's helpful explanations! Continue...



[ more.. ]


The DB2Night Show #205: Deep Dive Db2 LUW Locks, Logs, and pureScale

Mohan and Kent
Follow @mohankumarsp
Follow @rcollins963

Special Guests: Mohan Saraswatipura and Kent Collins, Authors

DEEP DIVE on Db2 LUW Locks, Logs, and pureScale

100% of our audience learned something! Mohan took us into the bowels of Db2 pureScale locking and logging, complete with sample SQL, monitoring commands, configuration considerations, important stuff you need to know for Db2 V11.1 Certification Testing, and much more! Get the PDF for reference AND watch our replay so that you don't miss Mohan's brilliant explanations! Continue...



[ more.. ]


The DB2Night Show #202: Using Jupyter Notebook for Db2 Administration

Ember Crooks, IBM DB2 GOLD Consultant

@ember_crooks

Special Guest: Ember Crooks
Director, Xtivia
IBM DB2 GOLD Consultant

Using Jupyter Notebook for Db2 Administration

100% of our audience learned something! If you like tools that help make your Db2 Administration tasks easier, then watch this replay and learn about Jupyter Notebook from IBM GOLD Consultant Ember Crooks! Ember teaches how to organize your favorite administrative SQLs, plus create graphs and reports, and more! The CLP is so yesterday! Watch and learn...



[ more.. ]


The DB2Night Show #201: Favorite Tuning Tips and Tricks for Db2 LUW

Joe Geller, Db2 Performance Specialist, JP Morgan Chase

Special Guest: Joe Geller, JP Morgan Chase

Favorite Tuning Tips and Tricks for Db2 LUW

100% of our audience learned something! SELECTIVITY, OPTGUIDELINES, Runstats, Indexes, Bufferpool Design, REORGs, monitoring advice, and more!! No wonder Joe won Best User Speaker at IDUG Lisbon 2017! Joe's presentation is full of terrific advice and tips! Watch and learn...



[ more.. ]


The DB2Night Show #200: IBM Db2 V11 Performance: BLU Hits and Misses!

Mark Gillis, Db2 Performance Specialist, Triton

Follow @db2geek

Special Guest: Mark Gillis, Triton Consulting

Db2 V11 Performance: BLU Hits and Misses

100% of our audience learned something! Based on his popular IDUG Lisbon Db2 technical session, Mark covered an overview of BLU, examples of workload performance in Db2 V10.5, the benefits of Db2 V11 for some workloads, showed examples of BLU savings, and shared a few BLU gotchas. If you're using Db2 BLU, or thinking about it, you must watch this replay! Watch and learn...



[ more.. ]


The DB2Night Show #199: Awaken your Data with RESTful Access to Db2!

George Baklarz, Program Director, IBM

Follow @upintheairyyz

Special Guest: George Baklarz, Program Director, IBM Canada

Awaken your Data with RESTful Access to Db2! OData!

100% of our audience learned something! The new IBM Data Server Gateway for OData is a standards-based way for customers to leverage Db2 in modern Cloud and Mobile application development environments without requiring database drivers on the client. This show described what OData is, how it works with RESTful calls, and what you need to get it working in your environment. Enjoy the replay!



[ more.. ]


The DB2Night Show #198: The 5 W's of Db2 HADR with guest Dale McInnis, IBM

Dale McInnis, IBM

@dalemmcinnis

Special Guest: Dale McInnis
STSM / NA Data Server Tech Sales
IBM Canada

The 5 W's of Db2 HADR

98% of our audience learned something! What is HADR? Why should you use HADR? Where should HADR be deployed? When should you use HADR? Who is using HADR? And, bonus, How is HADR being used by Db2 Customers? Our live audience was HUGE- clearly HADR is an important, and popular, topic of concern for the Db2 community! Watch and learn...



[ more.. ]


The DB2Night Show #197: Db2 IoT, Project Pollinator, and GWLM

Roger Sanders, IBM Paul Bird, IBM
IoT Computer running Db2 Db2 Logo, IBM
Follow @Roger_E_Sanders
Follow @IBM_Paul_Bird

Special Guests: Roger Sanders and Paul Bird, IBM

Db2 Science Projects: IoT Project Pollinator and GWLM Tool

100% of our audience learned something! It's a special show when we have two guests! Roger Sanders introduced us to Project Pollinator and showed us his pet Internet of Things (IoT) Db2 project - Fascinating! And Paul Bird introduced us to a rather new "free" Graphical Workload Manager (GWLM) tool that is available to help make administering Db2 workload management easier! Watch the replay, get the details, follow the links, and enjoy the PDFs!



[ more.. ]


The DB2Night Show #196: Db2 LUW Transaction Log Expedition w/ Ember Crooks

Ember Crooks, IBM DB2 GOLD Consultant

@ember_crooks

Special Guest: Ember Crooks
Director, Xtivia
IBM DB2 GOLD Consultant

SQL Infusion: A Db2 LUW Transaction Log Expedition!

96% of our audience learned something! Ember took us on an educational journey that covered just about everything related to Db2 transaction logs, active logs, archive logs, configuration settings, recommendations, and sample SQL for examining your systems. As for the 4% that didn't learn something --- they were IBM Canada Lab staff! Watch and learn...



[ more.. ]


The DB2Night Show #195: Breaking News from IBM Canada Db2 Lab!

Roger Sanders, IBM Jessica Rockwood, IBM
Jessica Rockwood, IBM Roger Sanders, IBM
Follow @Roger_E_Sanders
Follow @jrockwood

Special Guests: Roger Sanders and Jessica Rockwood, IBM

Breaking Db2 (LUW) News from the IBM Canada Lab

100% of our audience learned something! Shocker! "DB2 for LUW" is now just "Db2". Mainframe folks will still have to type out "Db2 for z/OS". Some IBM products, or solution offerings, have been renamed. What's new? Well, V11.1.2.2 is new, and there are plenty of goodies and enhancements in it. There's a new DSM release. There are new (free) editions of Db2. A PDF is available for reference, but make sure you download and watch a replay too! So much more is said than what is on the slides, and the questions at the end are excellent. Enjoy...



[ more.. ]


The DB2Night Show #194: Interviewing the DB2 LUW Optimizer w/ Ember Crooks

Ember Crooks, IBM DB2 GOLD Consultant

@ember_crooks

Special Guest: Ember Crooks
Director, Xtivia
IBM DB2 GOLD Consultant

Interviewing the DB2 LUW Optimizer

100% of our audience learned something! Ember took us on a deep dive journey through DB2 LUW Explain information including how to get it, how to interpret it, how to make the most of it, and much more. You will learn about db2exfmt, DB2 Explain from Actuals, IBM DSM, dsmtop, db2top, other tools, and just what the heck all those numbers actually mean! Watch and learn...



[ more.. ]


The DB2Night Show #193: DB2 LUW V11 Certification Training - Part 3

Mohan and Kent
Follow @mohankumarsp
Follow @rcollins963

Special Guests: Mohan Saraswatipura and Kent Collins, Authors

DB2 LUW V11 Certification Training - Part 3

92% of our audience learned something! If you want to earn DB2 LUW V11 IBM Certifications, there are no better teachers than the professionals that are writing the exams and Certification Study Guides! Watch this replay and learn about DB2 LUW V11, RCAC, Security, Trusted Contexts, utilities, and more! Sample Certification Questions are included in the video replay too!



[ more.. ]


The DB2Night Show #191: DB2 LUW V11 Certification Training - Part 2

Mohan and Kent
Follow @mohankumarsp
Follow @rcollins963

Special Guests: Mohan Saraswatipura and Kent Collins, Authors

DB2 LUW V11 Certification Training - Part 2

100% of our audience learned something! If you want to earn DB2 LUW V11 IBM Certifications, there are no better teachers than the professionals that are writing the exams and Certification Study Guides! Watch this replay and learn about DB2 LUW V11, BLU, DPF/MPP, pureScale, and more! Sample Certification Questions are provided too!



[ more.. ]


The DB2Night Show #190: DB2 LUW V11 Certification Training - Part 1

Mohan and Kent
Follow @mohankumarsp
Follow @rcollins963

Special Guests: Mohan Saraswatipura and Kent Collins, Authors

DB2 LUW V11 Certification Training - Part 1

100% of our audience learned something! If you want to earn DB2 LUW V11 IBM Certifications, there are no better teachers than the professionals that are writing the exams and Certification Study Guides! Watch this replay and learn about DB2 LUW V11, BLU, DPF/MPP, pureScale, and more! Sample Certification Questions are provided too!



[ more.. ]


The DB2Night Show #189: DB2 LUW Optimized for SAP - The rest of the story!

Martin Hubel  on LinkedIn
@mhubel

Special Guest: Martin Hubel
IBM DB2 GOLD Consultant

DB2 LUW Optimized for SAP - The Rest of the Story!

76% of our audience learned something! For 24%, it was review and validation they were doing the right things to tune and manage SAP on DB2 LUW! You will learn about registry variables for SAP, dropping and adding indexes, and more best practices. What's more, Martin talks about how to defend your DB2 turf from Hana! Please learn from, and enjoy, the replay...



[ more.. ]


The DB2Night Show #188: DB2 LUW Predictive Index Impact Analysis

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

Special Guest: Scott Hayes, DBI Software

Sage DB2 LUW Performance Advice
Predictive Index Impact Analysis -
Know Before you Create!

100% of our audience learned something! Sage Advice Part 3 - Predictive Index Impact Analysis - Know Before you Create - extends the performance tuning journey that began with Parts 1 and 2. Don't worry if you missed Parts 1 and 2 because they are briefly reviewed during this show, plus we have links to prior shows where you can watch the full presentations. Learn how to figure out what to fix or improve, then learn how to get optimized design solutions, and then, in Part 3, you will learn how to gain confidence in your solutions and make your change control people very happy! Watch and learn...



[ more.. ]


The DB2Night Show #187: FREE Resources to help you succeed with DB2 LUW V11

George Baklarz, Program Director, IBM

Follow @upintheairyyz

Special Guest: George Baklarz, Program Director, IBM Canada

New & Updated FREE Resources to help you succeed with DB2 LUW V11.1

Again, 100% of our audience learned something! When you listen to our replay, take note of the millions of miles that George has flown around the world. While he's on the airplanes, he writes books and develops really cool tools to help learn about DB2. During this show, you'll learn about his new V11 e-book and updated tools: "DB2 Demo", "DB2 Compression Estimator", and "pureScale Simulator." Links to these resources are provided. Bonus: Learn about DB2 V11's unofficial support of JSON and please take our one question poll. Enjoy...



[ more.. ]


The DB2Night Show #186: IBM Big Insights 4.2 and Big SQL Drill Down

Les King, Director, IBM

Follow @LesKing00

Special Guest: Les King, Director of Big Things, IBM

BigInsights 4.2 and BigSQL Drill Down!

Again, 100% of our audience learned something!For DB2 Folks, Les King took us on an informative journey into some IBM BigData solutions with a focus on BigSQL. Watch our replay and you'll see how IBM BigInsights BigSQL will allow you to run your favorite SQL against Hadoop. BigSQL is powered by DB2 - The Common Analytics Engine (CAE). Fascinating... Enjoy...



[ more.. ]


The DB2Night Show #185: Monitoring IBM BigSQL - Similarities to DB2 LUW

Nailah Bissoon, Performance Architect, IBM BigSQL, IBM Canada

Special Guest: Nailah Bissoon, Performance Architect, IBM BigSQL

Monitoring IBM BigInsights BigSQL
How does it compare to monitoring DB2 LUW?

100% of our audience learned something! Your cheese is moving! Someday, if not already, you may be asked to monitor the performance of IBM BigSQL. As you'll learn in this replay, there are a few differences and many similarities to monitoring DB2 LUW. Nailah provided a fantastic comparison of DB2 LUW and BigSQL, their architectures, how they work, and how to monitor both- complete with examples and useful SQL! Enjoy...



[ more.. ]


The DB2Night Show #184: DB2 - The Corner Stone of IBM Analytics

Les King, Director, IBM

Special Guest: Les King, Director of Big Things, IBM

DB2 - The Corner Stone of the
IBM Analytics Platform Strategy

100% of our audience learned something! What is the future of DB2? How will your career change? Has IBM moved your cheese? DB2 engine technology is invading many of IBM's software and cloud offerings. Affectionately called the Common Analytics Engine (CAE), DB2 is spreading like a virus (a good one) into BigInsights, BigSQL, Netezza, dashDB, and more. Via the DB2 CAE, investments that have been made in analytics SQL queries will run seamlessly in many places. To understand how you can grow your career and deliver great business results with IBM DB2 CAE technologies, watch this show and take notes! Enjoy...



[ more.. ]


The DB2Night Show #183: DB2 LUW Security from the Data Center to the Cloud!

Roger Sanders, DB2 Security Guru, IBM

Special Guest: Roger Sanders, Author, Teacher, and Security Guru, IBM

DB2 LUW Security:
From the Data Center to the Cloud!

100% of our audience learned something! No surprises there! Famous for his DB2 Certification Books and Classes, everyone learns from Roger! In this presentation, Roger provides our audience with the nuts and bolts and best capabilities for DB2 LUW security. As with any great presentation, it is rich with explanations, examples, and sample commands. If you want to improve DB2 security for your organization, you MUST watch and learn from this replay and the PDF handout! Enjoy...



[ more.. ]


The DB2Night Show #182: DB2 LUW V11.1 Upgrade Best Practices and Tips!

Melanie Stopfer, IBM DB2 LUW Brain Surgeon

Special Guest: Melanie Stopfer, IBM DB2 LUW Brain Surgeon

DB2 LUW V11.1 UPGRADE Best Practices
plus TIPS and Hidden Gems!

100% of our audience learned something! No surprises there! Everyone learns from Melanie! For our season #7 grand finale, Melanie gave our audience the complete scoop on upgrading to DB2 LUW V11.1! You will not only learn best practices, but you will also learn some very wise and insightful tips, plus you will learn about some "Hidden Gems" - - the extra "smaller" stuff that isn't making the headlines! And, did you notice? We kicked off Season #7 with Melanie talking about auditing and security, and today Melanie provided our Season #7 Grand Finale! Watch and learn...



[ more.. ]


The DB2Night Show #181: DB2 LUW Advanced Performance Diagnostics for SQL

David Kalmuk, STSM, IBM Canada
@DavidKalmuk

Special Guest: David Kalmuk, STSM, IBM Canada

DB2 LUW Advanced Performance Diagnostics for SQL

100% of our audience learned something! David gave us another great IDUG presentation packed with tips and advice for monitoring and diagnosing performance issues in DB2 LUW. A PDF handout is available so you can copy/paste from his SQL examples! Watch and learn...



[ more.. ]


The DB2Night Show #180:DB2 LUW DPF/MPP for Single Partition DBAs in 10 Tips

Pavan Kristipati on LinkedIn
@pkristipati

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

DB2 LUW DPF/MPP for Single Partition DBAs in 10 Tips!

100% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he helps DBAs familiar with single partition databases understand how DPF works, how DPF is different, and he gives valuable administration advice! A PDF handout is available so you can copy/paste Pavan's SQL! Watch our replay and learn...



[ more.. ]


The DB2Night Show #179: DB2 LUW V11.1 Deep Dive on OLTP and pureScale

Learn more about DB2 LUW V11.1 at ibm.com   Steve Rees, STSM, IBM Canada
 Keri Romanufa on LinkedIn   Xun Xue, STSM, IBM Canada

What's New in DB2 LUW V11.1: DEEP DIVE on OLTP and pureScale

Guests:
Steve Rees, STSM
Keri Romanufa, STSM
Xun Xue, STSM
IBM Canada Lab

100% of our audience learned something! As a follow up to our 15 April 2016 show Episode #177 that provided a broad overview of "What's New" in DB2 LUW V11.1, our special guests @db2steve, @xun_ca, and @RomanufaKeri gave us a deep dive that focused on new features and capabilities related to OLTP and pureScale, plus DSMTOP, and more! The enhancements will fascinate and amaze you. Watch and learn!



[ more.. ]


The DB2Night Show #178: DB2 LUW V11.1 Deep Dive on BLU and Analytics

IDUG NA 2016 Austin TX May 23-26 Details
@IDUGDB2
John Hornibrook, STSM, IBM Canada
  David Kalmuk, STSM, IBM Canada

What's New in DB2 LUW V11.1: DEEP DIVE on BLU and Analytics

Guests:
John Hornibrook, STSM
David Kalmuk, STSM
IBM Canada Lab

100% of our audience learned something! As a follow up to our 15 April 2016 show Episode #177 that provided a broad overview of "What's New" in DB2 LUW V11.1, our special guests @JHornibrookIBM and @DavidKalmuk gave us a deep dive that focused on new features and capabilities related to BLU and Analytics. The speed is mind-boggling. The enhancements will fascinate and amaze you. Watch and learn!



[ more.. ]


Page :  1 2 3 4 5 6