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


The DB2Night Show #136: Why Wait?!?! DB2 LUW Locking

Paul Turpin on LinkedIn
@pault99

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

Why Wait? DB2 LUW Locking

100% of our audience learned something! During today's show, Paul shared his excellent IDUG presentation in which he details terrific information about DB2 LUW locking! Learn about maxlocks, mon_lockwaits, mon_lw_thresh, mon_deadlock, mon_locktimeout, locktimeout, monreport, mon_get_pkg_cache_stmt, mon_db_summary, mon_lck_msg_lvl and the secret decoder ring, lock behavior, set current lock timeout, secret DB2 registry variables that impact locking, deadlocks, and much more, plus get MANY great SQL and command examples! Watch our replay for details...



[ more.. ]


The DB2Night Show #135: DB2 DPF Challenges, Solutions, and Successes

Pavan Kristipati on LinkedIn

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

DB2 DPF Challenges, Solutions, and Successes

100% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he details some of the DB2 DPF challenges he faced, his solutions to these challenges, and his measured successes. Learn how to reduce CPU utilization, make SAS queries run faster, speed up backups, achieve SLAs, smartly automate REORGs, and more. Watch our replay for details...



[ more.. ]


The DB2Night Show #134: DB2 LUW INGEST Utility with Mark Gillis, Triton

Mark Gillis, Triton

Special Guest: Mark Gillis, Triton

DB2 LUW INGEST Utility

18% of our audience was running DB2 LUW V10.5 in production and 45% of our audience was running V10.1 in production. The INGEST Utility became available in V10.1 as a client side utility, yet 0% of our audience today was using it. 86% of our audience indicated they learned something from Mark. In our post show survey, many attendees indicated they will now consider evaluating INGEST. Not only did Mark brilliantly introduce the INGEST utility overall, but he also showcased how INGEST can be cleverly and effectively used as an ETL tool. Watch our replay for details...



[ more.. ]


The DB2Night Show #133: Why Low Cardinality Indexes (STINK), Ember Crooks

Ember Crooks, Rosetta

Special Guest: Ember Crooks, Rosetta

Why Low Cardinality Indexes Negatively Impact Performance

100% of our studio audience learned something! Based on her popular IBM Developer Works article and blogs, IBM DB2 GOLD Consultant Ember Crooks brings her articles on Index Cardinality to life via her excellent IDUG presentation! Watch our replay for details...



[ more.. ]


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

DB2's GOT TALENT 2014

Top 6 Finalists Compete for YOUR votes!

Grand Finale of the DB2 Olympics!

Almost 100% of our audience learned something! The DB2's GOT TALENT March Finalist shows are amazing, awesome, incredible, phenomenal, terrific, educational, fun, informative, and entertaining! You can learn from and enjoy great presentations by rising stars in our DB2 community! Watch this replay, learn good advice from your peers, then VOTE for your chance to win a $25 Amazon.com gift card!



[ more.. ]


The DB2Night Show #130: DB2's GOT TALENT Top 7 Finalists Compete!

DB2's GOT TALENT 2014

Top 7 Finalists Compete for YOUR votes!

It's Day 7 of the DB2 Olympics!

100% of our audience learned something! The DB2's GOT TALENT March Finalist shows are amazing! You can learn from and enjoy great presentations by rising stars in our DB2 community! Watch this replay, learn good advice from your peers, then VOTE for your chance to win a $25 Amazon.com gift card!



[ more.. ]


The DB2Night Show #127: DB2's GOT TALENT Contestant Search #4

DB2's GOT TALENT 2014

Today's Finalist Winners: Ian and Swapna

It's Day 4 of the DB2 Olympics!

100% of our studio audience learned something! We had some good presentations today on DB2 LUW! Learn how to tune DB2 LUW memory including bufferpools and configuration parameters, a clever way to save yourself a lot of typing for DB2 commands, and a method of transferring DB2 database data from UNIX to Windows systems. Watch this replay, learn good advice from your DB2 community peers, then complete our survey for your chance to win a $25 Amazon.com gift card!



[ more.. ]


The DB2Night Show #125: DB2's GOT TALENT Contestant Search #2

DB2's GOT TALENT 2014

Today's Finalist Winners: Prasad, Michael, and Raja

It's Day 2 of the DB2 Olympics!

100% of our studio audience learned something! Today's presentations were fantastic! We had seven LUW themed contestants! You can learn about ADMIN_MOVE_TABLE, monitoring and tuning static SQL, reclaiming space with db2dart, solving a complex DB2 DPF performance issue, the change event history monitor, and Q-replication! This show contains a buffet of DB2 tips and advice! Watch this replay, learn good advice from your DB2 community peers, then complete our survey for your chance to win a $25 Amazon.com gift card!



[ more.. ]


The DB2Night Show #124: DB2's GOT TALENT Kickoff!

DB2's GOT TALENT 2014

Today's Finalist Winners: Robert, Saurabh, and Mariana

It's the DB2 Olympics!

95% of our studio audience learned something! Today's presentations were fantastic! Ember Crooks was a substitute judge for Klaas Brant. USA, Brazil, and India competed! You can learn about DB CFG CPUSPEED, a solution for purging 1.1TB of data, and get advice on automating DBA tasks. This show contains a buffet of DB2 tips and advice! Watch this replay, learn good advice from your DB2 community peers, then complete our survey for your chance to win a $25 Amazon.com gift card!



[ more.. ]


The DB2Night Show #123: 75 Ways to Save I/O and 25 Ways to Save CPU

Lee Goddard
HOT ideas for saving system resources!

Special Guest: Lee Goddard, Chief Performance Architect, DBI Software

75 Ways to Save I/O and 25 Ways to Save CPU

92% of our studio audience learned something! During this episode of The DB2Night Show™, Lee Goddard shared priceless thoughts and valuable tips on how to reduce system resource consumption! Odds are very high you are going to learn something helpful! Watch and learn...



[ more.. ]


The DB2Night Show #120: Tuning SAP on DB2 LUW with Martin Hubel

Martin Hubel on LinkedIn
Follow @mhubel on Twitter!

Special Guest: Martin Hubel, MHC, IBM DB2 GOLD Consultant and Information Management Champion

Tuning SAP on DB2 LUW

100% of our studio audience learned something! During this episode of The DB2Night Show™, Martin offered many valuable suggestions for tuning SAP in a DB2 LUW environment based on his experiences at several clients. This presentation has "meat on its bones"! Learn about dropping indexes, adding indexes, block based bufferpools, STMM, Vector I/Os and more! Watch and learn...



[ more.. ]


The DB2Night Show #119: DB2 LUW Potluck - IBM IOD 2013 Insights!

Ember Crooks on LinkedIn Fred Sobotka on LinkedIn
IBM IOD 2013 Review by Top Consultants
DB2 Experts Ember Crooks and Fred Sobotka share their insights and reviews of IBM IOD 2013!

Special Guests: Ember Crooks, Rosetta, and Fred Sobotka, FRS Consulting

DB2 LUW Potluck - DB2 Experts Review Insights from IBM IOD 2013

88% of our studio audience learned something! 12% attended for the humor! During this episode of The DB2Night Show™, Ember and Fred shared with us what they learned and observed at IBM IOD 2013. Find HADR tidbits and more, plus some great advice if you are thinking about attending IBM Insights in 2014! Watch and learn...



[ more.. ]


The DB2Night Show #118: 17 Laws of building very large databases!

Lee Goddard
Tabasco is hot! And so is this show!

Special Guest: Lee Goddard, Chief Performance Architect, DBI Software

17 Laws of building Petabyte Level DB and Big Data Systems

96% of our studio audience learned something! During this episode of The DB2Night Show™, Lee Goddard shared invaluable insights on the laws of very large databases! Odds are very high you are going to learn something helpful! Watch and learn...



[ more.. ]


The DB2Night Show #117: Feelin' BLU - The HOTTEST IBM DB2 BLU video ever!

Scott Hayes' Laptop in Refrigerator
IBM BLU is so HOT that the replay videos had to be rendered in Scott's refrigerator to prevent his laptop from overheating!

Special Guests: Scott Hayes, DBI, and Randall Ibbott, QBE

Feelin' BLU - Beyond the Marketing Hype
DB2 Users Test Drive BLU!

95% of our studio audience learned something! During this episode of The DB2Night Show™, we skipped the marketing BLAH BLAH BLAH and real IBM DB2 BLU users shared their performance science projects and experiences! Watch and learn...



[ more.. ]


The DB2Night Show #116: Intimate Details- DB2 BLU with IBM Master Inventors

Guy Lohman Shankar Raman

Special Guests: IBM Master Inventors Guy Lohman and Shankar Raman

IBM DB2 BLU Intimate Details!

97% of our studio audience learned something! During this episode of The DB2Night Show™, Guy and Shankar began by sharing the usual "marketing" slides on BLU (it must be an IBM requirement) but then treated us to a deep dive on technical details we've not seen in any other presentations. If you're the sort of person that likes to take things apart to see how they work, then watch and learn...



[ more.. ]


The DB2Night Show #115: DB2 BLU & pureScale Real Life Successes & Advice

Kent Collins

Special Guest: Kent Collins, Sr. Database Consultant

IBM DB2 10.5 BLU "Real Life" Experiences and Advice!

100% of our studio audience learned something! During this episode of The DB2Night Show™, Kent shared with us many Kent-isms such as "It isn't peanut butter and jelly" along with volumes of practical BLU advice based on his testing and implementation experiences. Kent affectionately called his presentation "A BLU print for BLU!" Watch and learn...



[ more.. ]


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


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


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


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


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


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


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


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


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


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


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


Page :  1 2 3 4