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

The DB2Night Show #Z12: Data Warehousing Perf. & DB2 10 Temporal Tables

Special Guest: Dave Beulke, CEO of Pragmatic Solutions, Inc.,USA

In episode #Z12 our special guest Dave Beulke (CEO Pragmatic Solutions, Inc. / IBM GOLD Consultant / IBM Champion ) shared a lot of his DB2 Data Warehousing tips and Tricks. Dave works with large enterprises to optimize their Data Warehouse. In this session he will explain what he does to make sure Data Warehouses of many billion row can perform well in DB2.



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

The DB2Night Show #60: Using DB2DART with guest Iqbal Goralwalla, Triton

100% of our studio audience indicated they learned something! Our special guest was Iqbal Goralwalla, Principal Consultant, Triton Consulting, and IBM Information Management Champion. Iqbal shared with us his top tips for using DB2DART to achieve storage reclamation, address index corruption, extract data, and remove backup pending status. Watch and learn...

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #Z11: First Look at Changes to DSNZPARMs by DB2 10

Special Guest: Willie Favero, IBM, USA

Willie: "My presentations are like water, give me a space and I fill it..."

In episode #Z11 our special guest Willie Favero (IBM Senior Certified Consulting IT Software Specialist) teaches you what has changed in DSNZPARM's coming from DB2 V8 or DB2 9. A 90 minute high tech talk from one of the best known IBM Software Specialists.



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

The DB2Night Show #59: DB2 LUW Index Design, Myths, Realities, and Magic

96% of our studio audience indicated they learned something! Our special guest was Martin Hubel, Owner MHC, an IBM DB2 GOLD Consultant, and IBM Information Management Champion. Martin claims to have put THREE children through college by fixing index designs. In Episode #59, you can learn Martin's secrets and advice, and score some very helpful SQL commands to aid your own analysis! Watch and learn...

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #Z10: DB2 XML - It is all about SQL/XML and XPath

Host and presenter: Klaas Brant, KBCE, Netherlands

You can run but you cannot hide!

In episode #Z10, host and presenter Klaas Brant (IBM Gold Consultant and IBM Champion) gives an overview of the IBM PureXML technology. From the polls you can read that some people are into XML because they have to. Because XML is widely used as exchange mechanism it is just a matter of time before you have to use XML as well.



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

The DB2Night Show #58: Using and Tuning IBM OPM - What you NEED to know

100% of our studio audience indicated they learned something! Show host Scott Hayes wore two hats today - both host and guest speaker. Topics covered included DB2 access paths, index design, using IBM OPM, monitoring IBM OPM, and even tuning techniques to help OPM run more efficiently. For many, the show was a real eye opener. Watch the replay...

[ more .. ]
by scott in DB2 LUW

#Z09 Distributed access to DB2 for z/OS Successful administration

Special guest: Cristian Molaro, Belgium

This show did not go like I had planned. I knew that being in the hotel for the DB2 Symposium in Chicago I could expect trouble, but not the kind of trouble I did run into. But in the end everybody could enjoy Cristian's presentation so I guess all's well that ends well.



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

The DB2Night Show #Z08: DB2 for z/OS and Java- What's New?

Special guest: Julian Stuhler, Triton Consulting, UK

All roads lead to Rome, very true for using DB2 in Java!

In episode #Z08, our special guest Julian Stuhler (IBM Gold Consultant, IBM Champion and former IDUG president) gives an excellent overview of the many ways you can exploit DB2 using the Java programming language; varying from simple JDBC to PureQuery. But he also discusses the impedance mismatch between Java and Relational Databases and the new features in DB2 9 and DB2 10 which Java can benefit from. Are you into Java then this DB2Night Show is a must!



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

The DB2Night Show #57: DB2 LUW Vital Statistics - What you NEED to know

94% of our studio audience indicated they learned something! (6% of our audience was IBM people! ha! ) Our special guest, John Hornibrook, STSM, Manager Query Optimization Development, IBM Canada, shared with us a wealth of great information about DB2 LUW statistics including tips, how-to's, and his suggested best practices. Our audience asked several great questions at the end. Watch the replay and learn more...

[ more .. ]
by scott in DB2 LUW

40 Hours of #FREE #DB2 Education! Index of DB2Night Show Replays

Looking to improve your DB2 skills and expertise this summer? During Season #2 of The DB2Night Show™, we provided over 40 hours of free DB2 education to the DB2 communities. We gave away over $3,000 in prizes. This blog post contains an index of all Season #2 shows. Bookmark it, and start feeding your brain!

Thank you to all of our guests and sponsors. Your contributions to The DB2Night Show have helped grow the DB2 community!

[ more .. ]

by scott in General

The DB2Night Show #56: DB2 LUW Data Warehouse Tuning

94% of our studio audience indicated they learned something! (6% of our audience was IBM people! ha! ) Kate Kurtz, Gregor Meyer, and Haider Rizvi from the IBM Best Practices Teams shared with us their tips and insights on how to optimize the performance of Data Warehouse databases. What did you miss? Watch the replay...

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #Z07: Top DB2 e-Communities, Blogs and networking tools

Three special guests: Surekha Parekh, Susan Visser and Willie Favero, all IBM

Where to find the latest and greatest about DB2 for z/OS?

In episode #Z07, special guests Surekha Parekh (DB2 for z/OS Marketing Manager), Susan Visser (Program Manager IBM Publishing), and Willie Favero (Writer, Speaker, Teacher, Technician, DB2 Enthusiast, and DB2 SME) show us the wonderful world of e-communities and blogs. Want to know where to find all the blogs, conferences, tweets, and groups to join? Learn from the experts who create them! As Always, 99% of our studio audience learned something! What did you miss? Watch the replay and find out!



[ more .. ]
by klaas in Cross Platform

The DB2Night Show #55: DB2 LUW Multi-temperature Data Management

100% of our studio audience indicated they learned something! Kate Kurtz, Jim Seeger, and "Max" Petrenko from the IBM Best Practices Teams shared with us their tips and insights on how to smartly manage data of varying "temperatures". What did you miss? Watch the replay...

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #Z06: DB2 10 Tablespaces and Migration

Special guest Susan Lawson, IBM DB2 GOLD Consultant, YL&A

What new tablespaces and options are available for DB2 z/OS V10?

In episode #Z06, special guest Susan Lawson, an IBM DB2 Gold Consultant and Owner Yevich Lawson & Associates, shared with us information about new tablespaces in DB2 z/OS V10, options, considerations, and some best practices. Remarkably, Susan offered all this free education from her hotel room in Croatia that overlooked the beach! What a sacrifice! 99% of our studio audience learned something! What did you miss? Watch the replay and find out!



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

The DB2Night Show #Z05: DB2 10 with John Campbell, IBM

Special guest John Campbell, Distinguished Engineer, IBM DB2 SVL Lab

How much storage does DB2 10 need? How CPU gain should I expect in DB2 10 CM? What if I move to DB2 10 but don't rebind?

In episode #Z05, special guest John Campbell, a distinguished Engineer of the IBM SVL Lab, is telling us all about DB2 10 for z/OS Planning & Very Early Experiences. John has worked with many of the DB2 users who have moved moved to DB2 10 already. He is probably the most aware person about DB2 migration benefits and problems. Watch episode #Z05 and get some free education on DB2 10 migration and what to expect from the new release based on user experiences.



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

The DB2Night Show #54: DB2 LUW Data Movement Utilities & Oracle Comparisons

Our special guest, Burt Vialpando, IBM, never disappoints us! 100% of our studio audience indicated that they learned something from today's show! Burt covered several ways to move data in DB2 LUW (for example, db2move, db2relocatedb, export, import, load, and others) and then compared these to Oracle data movement. What did you miss?!?!?! Watch the replay and find out!

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #Z04: What's new from the optimizer

Special guest Terry Purcell, Senior Technical Staff Member SVL

Want to know all about the DB2 10 optimizer improvements? Is the DB2 community using Hints?

In episode #Z04, special guest Terry Purcell, a Senior Technical Staff Member of the IBM SVL Lab, is telling us all about the optimizer improvements in DB2 10. Terry is a great presenter and, as always, his sessions are packed with a lot if great technical information. Watch episode #Z04 and get some free education on DB2 10 optimizer improvements.



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

The DB2Night Show #53: Achieving DB2 LUW Access Plan Stability

96% of our studio audience indicated they learned something! How awesome is that?!!? Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab. John shared with us more advice on how to optimize SQL queries, important ways to collect statistics, and how to "use a bigger hammer" to influence the DB2 optimizer. Learn about DB2 Optimization Profiles (DB2 "hints") and much more. Watch the replay and take advantage of all John's wisdom!!!

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #Z03: DB2 10 Performance

Special guest Cristian Molaro, IBM DB2 GOLD Consultant

More or less CPU? More or less Storage? What does DB2 10 have for us in mind?

In episode #Z03, special guest Cristian Molaro, IBM DB2 GOLD Consultant and co-author of the new DB2 10 Performance Redbook, is sharing with us his vision on DB2 10 performance. If you want to prepare yourself for DB2 10 then this presentation is a must-see!

Watch episode #Z03 and get some free education on DB2 10 Performance.



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

The DB2Night Show #52: Writing Optimized DB2 LUW SQL Queries

Brilliant! Very Helpful! Outstanding! Participants in the studio audience of Episode #52 gave this show EXCEPTIONAL ratings! Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab. John offered a buffet of outstanding advice on how to get your SQL to run faster and more efficiently! And, John should know the secrets - he IS the mastermind behind the DB2 LUW Optimizer! Watch the replay and take advantage of all John's advice!!!

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #Z02: DB2 Now and into the future

Special guest Jeff Josten, IBM Distinguished Engineer

Que Sera Sera... the future is not ours to see... well read on!

In episode #Z02, special guest Jeff Josten, IBM Distinguished Engineer, is telling us about DB2 version 10 AND... version XI. While Roger Miller gave us a complete overview of the past, Jeff brings us back to here and now. After explaining all about DB2 10 in detail he also tells us what to expect in the next release of DB2 ("codename" XI).

Watch the replay of Episode #Z02 and learn why you should migrate to DB2 10 and what DB2 has in store for us!



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

The DB2Night Show #51: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 2

It's another KNOCK OUT! Special guests from Triton Consulting and IBM Canada presented findings from their DB2 LUW versus Oracle Usability study. While you might expect some bias, the methods deployed for the study are quite scientific and objective. Julian Stuhler, Triton, focused today's talk on comparing automatic memory tuning, security administration, and auditing. Which database is "easier"? Watch and learn...

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #Z01: The history of DB2 for z/OS

Special guest Roger Miller, IBM DB2 Evangelist

Do you know the history of DB2? Can you remember the people from the lab?

In episode #Z01, special guest Roger Miller, IBM DB2 Evangelist, guides us through the history of DB2 for z/OS. This episode is special not only because it is the first in a new series of DB2Night Shows for z/OS, but also because Roger Miller will retire in a few weeks and this show is his last performance on the internet before his retirement. This show is a tribute to all the great people who shaped DB2 and a complete overview of the releases up to version 10.

Watch the replay of Episode #Z01 and learn the complete history of DB2 for z/OS...



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

The DB2Night Show #50: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 1

It's a KNOCK OUT! Special guests from Triton Consulting and IBM Canada presented findings from their DB2 LUW versus Oracle Usability study. While you might expect some bias, the methods deployed for the study seem rather objective and mathematically quantified. Host Scott Hayes got a little crazy with the boxing sound effects and startled Julian Stuhler out of his chair, but Jules recovered. Which database is "easier"? Watch and learn...

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #49: DB2 LUW Workload Manager - What, Why, How, Tips ...

IBM Developer Keith McDonald, aka "The K Guy", shared with us a fantastic presentation covering the DB2 LUW Workload Manager (WLM). He explained how it works, when and why to use it, and offered several tips, best practices, and helpful references. Watch and learn...

[ more .. ]
by scott in DB2 LUW

The DB2Night Show #48: All About IDUG and DB2's GOT TALENT Winners

IDUG Volunteers Bryan Paulsen and Paul Turpin shared with us important information about the IDUG DB2 Tech Conference. IDUG announced a special discount code for fans of The DB2Night Show™. We were also joined by DB2's GOT TALENT judges Susan Visser, Martin Hubel, and Klaas Brant as we announced the contest winners. Our finalists Norberto, Thiru, Momi, and JB were also put "on the air". Every attendee in our Studio Audience won a $10 Amazon.com gift certificate!

[ more .. ]
by scott in Cross Platform

The DB2Night Show #47: "Best DB2 Advice" on DB2's GOT TALENT!

This was another great show for learning DB2 tips and techniques! Our Top 5 Finalists shared their "Best Advice: Things DB2 People Need to Know" 100% of today's studio audience indicated that they learned something that would be helpful to their jobs!!! Our remaining Top 4 DB2's GOT TALENT Finalists need your votes! Watch the replay, learn helpful DB2 tips, then PLEASE VOTE!

[ more .. ]
by scott in Cross Platform

The DB2Night Show #46: Personal DB2 Success Stories on DB2's GOT TALENT!

This was another great show for learning DB2 tips and techniques! Our Top 7 Finalists shared Personal DB2 Success Stories! 100% of today's studio audience indicated that they learned something that would be helpful to their jobs!!! Our remaining Top 5 DB2's GOT TALENT Finalists need your votes! Watch the replay, learn helpful DB2 tips, then PLEASE VOTE!

[ more .. ]
by scott in Cross Platform

The DB2Night Show #45: DB2'S GOT TALENT! Top 7 Seek YOUR Votes!

This was another great show for learning DB2 tips and techniques! Our contestants focused on DB2 commands: db2move, db2look, db2top, z/OS report utility, db2dart, and db2caem! 100% of today's studio audience indicated that they learned something that would be helpful to their jobs!!! Our Top 7 DB2's GOT TALENT Finalists need your votes! Watch the replay, learn helpful DB2 tips, then PLEASE VOTE!

[ more .. ]
by scott in Cross Platform

DB2's GOT TALENT: Focus on DB2 Commands 11 March 2011

Join our webinar studio audience 11 March 2010 as our Top Finalists will share tips, techniques, and lessons learned on DB2 commands. Finalists have been instructed to offer presentations on db2look, db2dart, db2top, db2move, db2advis, db2exfmt, or any other DB2 LUW command in the BIN directory. Our DB2 z/OS finalist will present "Beyond DSNJU003". Register at www.DB2NightShow.com.

[ more .. ]
by scott in General
Page :  1 2 3 4 5 6 7 8 9 10