The DB2Night Show #32: SAP on DB2 LUW - Lessons Learned with Martin Hubel

Tuning DB2 LUW for SAP and Lessons Learned

IBM DB2 GOLD Consultant Martin Hubel shares Lessons Learned and Tips...

In episode #32, special guest Martin Hubel, IBM DB2 GOLD Consultant and Owner MHC Inc., talked about a successful SAP implementation on DB2 LUW at The Wasserstrom Company. Martin shared valuable tips and lessons learned, and some of the tips apply to any OLTP application database. Watch and learn...

[ more.. ]


The DB2Night Show #31: Valuable SQL Lessons Learned with Sheryl Larsen

DB2 SQL Valuable Lessons Learned - Cross Platform

IBM DB2 GOLD Consultant Sheryl Larsen shares DIRTY LAUNDRY ...

In episode #31, special guest Sheryl Larsen, IBM DB2 GOLD Consultant and Owner www.SMLSQL.com, aired her dirty laundry! Well, her client's dirty laundry that is! In this informative episode, Sheryl examined SQL performance lessons learned from recent consulting engagements with clients. The SQL information provided applies to DB2 z/OS and LUW! Learn about indexes, stages, sargability, and so much more! Watch the replay to learn from her wisdom...

We'd also like to bring to your attention some upcoming shows:

  • OCT 15 - DB2 LUW Performance Tuning Lessons Learned with special guest Martin Hubel, IBM DB2 GOLD Consultant. Really - you don't want to miss this - even if you don't have SAP!
  • NOV 5 - The SQL Snapshot Potluck Party is BACK! Share your favorite SQL Snapshot command and receive the source code for the entire collection!
  • NOV 19 - What's new and COOL with DB2 LUW with guest George Baklarz, IBM
For show details, free registrations, and replays, kindly visit www.DB2NightShow.com

Finally, also on 21 January 2011 at 2pm Central, DBI is offering a free Webinar "TEN SQL Snapshot commands you MUST run TODAY!" - this is a derivative work of Scott Hayes' IDUG Regional technical session. Attendees will receive the SOURCE CODE for these invaluable commands. DETAILS and REGISTRATION.

[ more.. ]


The DB2Night Show Special Edition: DB2 LUW Challenges, Solutions, and Tips

DB2 LUW Challenges, Solutions, and Tips

DB2 Reality TV - Interviews with DB2 LUW Experts...

In this Special Edition of The DB2Night Show, DBI "interviewed" three top candidates for an open Software Consultant Engineer position and asked each professional to describe a DB2 challenge they faced, how they conquered it, and to offer a quick DB2 LUW tip to our audience. Some of the lessons learned covered SQL performance analysis, speeding up data warehouse loads to meet SLAs, and monitoring HADR. Tips covered DB2 optimization levels, DB2 security, and more.

Our studio audience "voted" on the candidates, and there was a clear front runner. However, in this recorded replay, we edited the video to remove the voting results. We suggest you watch this replay yourself, learn from the experiences of your peers, and draw your own conclusions. Watch the replay and learn from real DB2 LUW users...

In consideration of their participation, each of our expert candidates will be receiving $100 Amazon.com gift certificates. And, to thank everyone in our studio audience for their time and their valuable opinions (via the poll voting and exit survey), everyone in our studio audience that voted will receive a $10 Amazon.com gift certificate. Yes, we know, we had promised $5 certificates, but at DBI we try real hard to exceed expectations.

We'd also like to bring to your attention our upcoming shows:

  • OCT 8 - The DB2Night Show goes "Cross Platform" with special guest Sheryl Larsen. Sheryl will share SQL performance lessons learned from recent consulting engagements and offer tips for both DB2 z/OS and LUW!
  • OCT 15 - DB2 LUW Performance Tuning Lessons Learned with special guest Martin Hubel, IBM DB2 GOLD Consultant. Really - you don't want to miss this - even if you don't have SAP!
  • NOV 5 - The SQL Snapshot Potluck Party is BACK! Share your favorite SQL Snapshot command and receive the source code for the entire collection!
  • NOV 19 - What's new and COOL with DB2 LUW with guest George Baklarz, IBM
For show details, free registrations, and replays, kindly visit www.DB2NightShow.com

Finally, also on October 8th at 2pm Central, DBI is offering a free Webinar "TEN SQL Snapshot commands you MUST run TODAY!" - this is a derivative work of Scott Hayes' IDUG Regional technical session. Attendees will receive the SOURCE CODE for these invaluable commands. DETAILS and REGISTRATION.

[ more.. ]


The DB2Night Show #30: The Las Vegas Approach to DB2 LUW Security

DB2 LUW Security Tips and Best Practices

Beat the odds with these simple steps...

In episode #30, special guest Rebecca Bond, CISSP, published author, and independent DB2 Security consultant shared with us some simple steps, sample SQL commands, tips, and best practices for securing your organization's DB2 LUW data assets. Watch the replay to learn from her wisdom...

We'd also like to bring to your attention our upcoming shows:

  • OCT 8 - The DB2Night Show goes "Cross Platform" with special guest Sheryl Larsen. Sheryl will share SQL performance lessons learned from recent consulting engagements and offer tips for both DB2 z/OS and LUW!
  • OCT 15 - DB2 LUW Performance Tuning Lessons Learned with special guest Martin Hubel, IBM DB2 GOLD Consultant. Really - you don't want to miss this - even if you don't have SAP!
  • NOV 5 - The SQL Snapshot Potluck Party is BACK! Share your favorite SQL Snapshot command and receive the source code for the entire collection!
  • NOV 19 - What's new and COOL with DB2 LUW with guest George Baklarz, IBM
For show details, free registrations, and replays, kindly visit www.DB2NightShow.com

Finally, also on October 8th at 2pm Central, DBI is offering a free Webinar "TEN SQL Snapshot commands you MUST run TODAY!" - this is a derivative work of Scott Hayes' IDUG Regional technical session. Attendees will receive the SOURCE CODE for these invaluable commands. DETAILS and REGISTRATION.

[ more.. ]


Move over American Idols - This is DB2 REALITY TV!

SPECIAL EDITION - 1 October 2010, 12PM CENTRAL

During this special edition of The DB2Night Show™, DBI will be interviewing our top candidates for our open Software Consultant Engineer position (see http://www.dbisoftware.com/careers.php for details). Each candidate will be given 8 minutes to describe a DB2 LUW challenge they faced and how they conquered it, 1 minute to offer a quick DB2 tip, and 1 minute to "make their case" for why they are our best candidate!

Studio Audience members will get to vote on our candidates! Your votes will influence DBI's selection committee (but the final decision rests with DBI), determine the prize that each of our candidates will win, AND... AND... AND... everyone in our studio audience that participates in candidate voting will earn a $5 Amazon.com gift certificate (limited to the first 100 attendees that arrive) in appreciation of your involvement!

THIS IS REALITY TV.

HEAR HOW YOUR PEERS HAVE SOLVED DB2 CHALLENGES AND LEARN VALUABLE TIPS! AND HELP DBI CHOOSE ITS NEXT TEAM MEMBER! Please join us if you can!

Details and registration:
www.DB2NightShow.com

[ more.. ]


The DB2Night Show #29: DB2 LUW High Availability and Recovery Planning

DB2 LUW High Availability and Recovery Planning

Failure to plan is planning to fail...

In episode #29, special IBM guests Kate Kurtz and Dale McInnis shared with us information on high availability and recovery planning; their focus was on data warehouse databases, InfoSphere, DPF, and the like. They offered several valuable tips and best practices. Watch the replay to learn from their wisdom...

We'd also like to bring to your attention our upcoming shows:

  • OCT 1 - The Las Vegas Approach to DB2 LUW Security with guest Rebecca Bond, CISSP, and author of Understanding DB2 9 Security!
  • OCT 8 - The DB2Night Show goes "Cross Platform" with special guest Sheryl Larsen. Sheryl will share SQL performance lessons learned from recent consulting engagements and offer tips for both DB2 z/OS and LUW!
  • OCT 15 - DB2 LUW Performance Tuning Lessons Learned with special guest Martin Hubel, IBM DB2 GOLD Consultant. Really - you don't want to miss this - even if you don't have SAP!
  • NOV 5 - The SQL Snapshot Potluck Party is BACK! Share your favorite SQL Snapshot command and receive the source code for the entire collection!
  • NOV 19 - What's new and COOL with DB2 LUW with guest George Baklarz, IBM
For show details, free registrations, and replays, kindly visit www.DB2NightShow.com

Finally, also on October 8th at 2pm Central, DBI is offering a free Webinar "TEN SQL Snapshot commands you MUST run TODAY!" - this is a derivative work of Scott Hayes' IDUG Regional technical session. Attendees will receive the SOURCE CODE for these invaluable commands. DETAILS and REGISTRATION.

[ more.. ]


The DB2Night Show #28: DB2 LUW Range Partition Tables, Mike Winer, IBM STSM

DB2 LUW Range Partitioning Tables - The Important Stuff

Emphasis on DB2 9.7 Updates

In episode #28, special guest Mike Winer, IBM STSM & DB2 Kernel Architect, shared with us the latest news and enhancements for Range Partitioned Tables in DB2 9.7. Mike specifically discussed Partitioned Indexes and their many benefits, impacts on DB2 logging, high availability during DETACH, and REORG implications and improvements. Watch this replay and see what you missed, or watch it again for review...

[ more.. ]


The DB2Night Show #27: DB2 in the Cloud - Tech Details - Part 2

DB2 LUW in the Cloud - Technical Details - Part 2

Your DB2 is in the Cloud, but where?

In episode #27, special IBM guest Mark Wilding, STSM & DB2 Cloud Architect, covered many technical details and considerations for running DB2 in the Cloud. This show was Part 2 of a 2 part series. In part 2, Mark shared with us performance and security considerations, storage configurations and models, and other tips to optimize success with DB2 in your Cloud. As with Part 1, studio audience members rated this episode very highly. Watch this replay and see what you missed, or watch it again for review...

[ more.. ]


The DB2Night Show #26: DB2 in the Cloud - Tech Details - Part 1

DB2 LUW in the Cloud - Technical Details - Part 1

Your DB2 is in the Cloud, but where?

In episode #26, special IBM guest Mark Wilding, STSM & DB2 Cloud Architect, gave an an outstanding technical overview of DB2 in the Cloud. This show was Part 1 of a 2 part series. In part 1, Mark shared with us different "tiers" or "levels" of participating in an IT cloud and many of the motivating factors driving advancement through levels in clouds. Studio Audience participants rated this episode extremely high, and a few people commented "this was the best show ever!". Watch this replay and see what you missed, or watch it again for review...

[ more.. ]


The DB2Night Show #25: Comparing DB2 LUW & Oracle Autonomics

Comparing DB2 LUW and Oracle Autonomics

Seems like comparing a Porche and a bicycle to me

In episode #25, special IBM guest Burt Vialpando gave an an outstanding technical overview comparing DB2 LUW and Oracle autonomics. He covered automatic memory tuning, automatic configration, automatic storage management, automated utilities, and much more. When you look at the autonomic capabilities of these databases side by side, I think you will vividly see DB2 LUW's leadership position. And, in addition to the database comparison, you will also find some good tips and best practices in this show...

[ more.. ]


The DB2Night Show #24: DB2 LUW Oracle and Sybase Enablements

Season #2 Kickoff!

DB2 LUW aims for WORLD DATABASE DOMINATION!

In episode #24, special IBM guests Serge Rielau and Dwaine Snow brought us up to speed on the latest news regarding Oracle and Sybase enablements for DB2 LUW. Find out what is new in DB2 9.7 fixpack 2, fixpack 3, and even get some hints into the future! Watch this episode and learn about FREE tools, hear success stories, and get some great tips...

[ more.. ]


The DB2Night Show #23: DB2 LUW Storage I/O Optimization

In our 23rd show, we were joined by special guests Berni Schiefer and Robin Grosman from the IBM Toronto Lab. Berni and Robin shared several tips, techniques, and best I/O practices during this show including the use of Solid State Disk (SSD), registry variables, and much more.

This show was also our Season 1 Finale and we offered an extra large Home Depot Gift Certificate prize to some lucky winner who completed the survey afterward - who won? Keep reading...

[ more.. ]


The DB2Night Show #22: Comparing Oracle and DB2 LUW, Burt Vialpando

In our 22nd show, we were joined by special guest Burt Vialpando, IBM, from the Software Migration Project Office. You might think that a DB2 LUW and Oracle comparison by an IBM presenter would be a "hard sell" by IBM, but, to the contrary, Burt did an outstanding and "fair" job of looking at architecture and administration of these industry leading databases. True, Burt highlighted some "DB2 advantages", but 95% of his talk was a simple and straight forward side-by-side comparison. Studio Audience members rated this show very highly - watch the replay and find out why!

Also, today was a lucky day for EVERYONE in our Studio Audience. For participants that arrived on time, early in our show we provided special instructions to type "AMAZON.COM" in one of the survey response boxes. Everyone who followed the instructions correctly is winning a $10 Amazon.com gift certificate! DB2 LUW and The DB2Night Show are both rewarding! Punctuality is also a virtue!

[ more.. ]


The DB2Night Show #21: DB2 LUW Locking with Mike Winer, IBM STSM

In our 21st show, we were joined by special guest Mike Winer, IBM STSM, from the Toronto Lab. We ran a special 90 minute show so that Mike could cover his entire IDUG presentation on Locking. This guy is the LOCK MASTER! Mike covered types of DB2 LUW locks, lock memory, lock isolation levels, locking related registry variables (and you need to pay attention to these! ), DB2 9.7 Currently Committed, SQL options for locking, lock avoidance (the new standard! ), lock escalation, timeouts, and deadlocks, and how to monitor locking!

I'd also like to apologize to Mike and our audience. I have multiple computers, microphones, speakers, and headsets going when we produce these shows and I made a goof. The volume was turned down all the way on my headset in the beginning so I couldn't hear Mike speaking and I thought he'd gone for coffee, but, of course, he was there and freaking out because he thought the audience couldn't hear them. You all could hear him, but I couldn't. I chock this up to my most embarrassing show moment in 21 shows and I'm sorry for this goof. I'll try to do better in the future.

With all this said, pop yourself some popcorn and WATCH THIS SHOW...

[ more.. ]


The DB2Night Show #20: DB2 LUW REDISTRIBUTE with Ergin Babani, IBM

In our 20th show, we were joined by special guest Ergin Babani, IBM Developer, Continuing Engineering Team. Ergin shared with us tips and best practices for using DB2 REDISTRIBUTE. During our lively Q&A session, we were joined by Katherine Kurtz, IBM, on the IBM Smart Analytics Systems Best Practices team. Learn more about DB2 REDISTRIBUTE best practices...

[ more.. ]


The DB2Night Show #19: Making it BIG in Software, Sam Lightstone, Author

In our 19th show, we were joined by special guest Sam Lightstone, IBM STSM. Sam is the author of a new book "Making it BIG in Software". During this show, Sam shared some excellent advice with us on how to advance our careers. Frankly, I think it was some of the best advice I've heard in years. Check out the 5 great ideas that Sam shared and start earning bigger paychecks... icon_biggrin

[ more.. ]


The DB2Night Show #18: The Top 10 DB2 LUW Mistakes People Make, Klaas Brant

In our 18th show, Klaas Brant, IBM DB2 GOLD Consultant and Owner KBCE, Netherlands, shared with us his Top 10 DB2 LUW Mistakes that People Make. I think it was one of our best shows ever! The discussion was lively, and many tips were shared during the conversation! Are you making any of the Top 10 Mistakes? Watch this episode and find out... icon_biggrin

[ more.. ]


The DB2Night Show #17: DB2 LUW Performance Updates, Berni Schiefer, IBM

In our 17th show, Berni Schiefer, IBM DE, Toronto Lab, shared with us the latest news on DB2 LUW Performance achievements and some best practices. DB2 is still winning TPC benchmarks! Berni's talk is peppered with assorted hints, tips, and best practices. What are his favorite DB2 9.7 features? Watch and learn...

[ more.. ]


The DB2Night Show #16: Autonomic Memory & STMM Updates, Adam Storm, IBM

In our 16th show, we talked about DB2 LUW Autonomic Memory and the Self Tuning Memory Manager (STMM). Our special guest was Adam Storm, Software Developer, DB2 Kernel Development, from the IBM Toronto Lab. Adam did a great job on updating us about Autonomic Memory and STMM, and he fielded some excellent questions too. Watch and listen...

[ more.. ]


The DB2Night Show #15: DB2 9.7 Online Table Moves with Ergin Babani, IBM

In our 15th show, we talked about the new Online Table Move capability in DB2 9.7. Our special guest was Ergin Babani, DB2 LUW Continuing Engineering, from the IBM Toronto Lab. Despite recovering from a cold and having a sore throat, Ergin did a fantastic job for us on covering the options and features of this new capability, along with some insights, tips, and best practices. Of particular note, we hit a new record for studio audience questions - there were a lot of really good questions that you'll want to hear the answers to...

[ more.. ]


The DB2Night Show #14: Crunching the Numbers and DB2 STMM

In our 14th show, show host Scott Hayes, IBM DB2 GOLD Consultant and Information Management Champion, performed a deep dive into analyzing DB2 Snapshot numbers for a production DB2/Linux 9.7 database located in the UK. This database had STMM turned on, so we did a tangential LIVE demonstration on DB2's Self Tuning Memory Manager. Discover the real truths. Our findings might surprise or shock you...

[ more.. ]


The DB2Night Show #13: DB2 LUW Compression Updates

In our 13th show, special guest Paul Zikopoulos, Program Director - DB2 Evangelism, IBM Software Group, provided us with fantastic information on "DB2 LUW Compression Updates". He covered compression in DB2 9.1, 9.5, and 9.7, index compression, temp compression, and even shared competitive information that compares DB2 LUW compression to Oracle and SQL Server. This Episode is a MUST SEE...

[ more.. ]


The DB2Night Show #12: DB2 Information Resources

In our 12th show, special guest Susan Visser, Publishing Program Manager, IBM, introduced us to "The Wild Wonderful World of DB2 Information Resources". I had no idea that there were so many free and inexpensive resources available for quality DB2 information. Watch the replay of this episode to learn about the best blogs, best selling DB2 books, and the best websites for DB2 Information...

[ more.. ]


The DB2Night Show Episode #11: DB2 9.7 Optimizer Updates

In our eleventh show, special guest John Hornibrook, Manager, Query Optimization Development DB2 for Linux, UNIX, & Windows, IBM Canada shared with us details of enhancements to the DB2 Optimizer in DB2 9.7 GA and Fixpack 1. The list of enhancements is very impressive! Watch this show to learn more...

[ more.. ]


The DB2Night Show Episode #10: "DEAR IBM..."

In our tenth episode, we kicked of the year 2010 by inviting senior IBM executives Sal Vella and Tim Vincent to our show. DB2 LUW users from around the globe submitted letters of praise for DB2 and several enhancement requests. Watch this show and learn about enhancement requests that could become future DB2 LUW product features...

[ more.. ]


The DB2Night Show Episode #9: Crunching the Numbers

In our ninth episode, Scott Hayes, IBM GOLD Consultant and Data Management Champion, published author, frequent blogger, IDUG supporter and worldwide speaker, took a deep dive into DB2 Snapshot Data from a REAL LIVE DB2 LUW database that had been up and running for over a year! With the studio audience watching, we worked through analysis of an OLTP database. In studio audience surveys, many viewers asked for more shows like this one and some even volunteered their data for analysis!

Do you want to learn how to analyze the performance of a DB2 LUW database? Watch this show...

[ more.. ]


The DB2Night Show Episode #8: Managing the DB2 WLM

In our eighth episode, special guest Paul Bird from the IBM Canada Lab gave us updates on DB2 WLM and provided some best practices tips. However, the real excitement began when Mark Mulligan - a real live DB2 Customer using DB2 Workload Manager - shared with us his experiences and tips for implementing and using WLM. Mark's slides were impressive - he provided a cookbook recipe that others can follow!

Get the download - watch the replay...

[ more.. ]


The DB2Night Show Episode #7: SQL Server versus DB2 LUW

In our seventh show, special guest Leon Katsnelson, Program Director, IBM Data Servers, IBM Canada, gave us a great comparison of SQL Server versus DB2 LUW. He also talked about FREE DB2 and DB2 LUW in the cloud, and, as a bonus, he even compared DB2 Express-C to Oracle Express. So, if you are interested in learning more about free databases or would like to know how these offerings are different, then this is the show to watch!

Get the download - watch the replay...

[ more.. ]


The DB2Night Show Episode #6: Data Studio versus Quest Toad

Oh! The audacity! In our sixth show, we talked about free application development tools for IBM DB2 LUW. We pitted IBM Data Studio against Quest Toad. Our special guests included Deb Jensen, IBM, and Jim Wankowski, Quest Software. Watch this show and listen to these two professionals duke it out for "best free tool"!

Get the download - watch the replay...

[ more.. ]


The DB2Night Show Episode #5: SQL Snapshot Potluck Party

In our fifth episode, we invited the DB2 LUW community to share their favorite SQL Snapshot commands. Chris Eaton from IBM shared his Top 10 favorite SQL Snapshots, Rebecca Bond shared some DB2 Security SQL, and Scott Hayes also shared some of his favorite SQL Snapshots. If you'd like to learn about SQL Snapshots and see some very useful SQL commands, make sure you watch this show!

Get the download - watch the replay...

[ more.. ]


Page :  1 2 3 4 5 6 7 8 9 10