Series 1 - The DB2 Cocktail Hour

This podcast series will focus on all things DB2. We'll be covering a number of different technical topics, and include all sorts of special guests. So, grab a cocktail and pick a topic, and let's get this DB2 Cocktail Hour Started!


Podcast 12 - The IDUG Content Committee
Podcast 11 - The Cross-Platform DBA
Podcast 10 - From IDUG NA 2013 in Orlando - Fun with DB2 LUW
Podcast 9 - From IDUG NA 2013 in Orlando - XML and DB2
Podcast 8 - From IDUG EMEA in Berlin - DB2 for LUW Performance
Podcast 7 - From IBM IOD in Las Vegas - DB2 for z/OS Data Sharing
Podcast 6 - From IBM IOD in Las Vegas - DB2 Application Performance Analysis
Podcast 5 - From IBM IOD in Las Vegas - DBA 2012
Podcast 4 - Advanced SQL
Podcast 3 - The New Data Studio 3.1.1
Podcast 2 - Taking Advantage of New SQL In DB2 9 and 10
Podcast 1 - DB2 indexing options

1/17/2014 - Series 1 Podcast 12 - The IDUG Content Committee (back to series 1), (back to top)
From Las Vegas, Nevada. This was recorded during the 2013 IBM IOD Conference at Mandalay Bay in Las Vegas. Several fellow consultants and IDUG Content Committee members were on hand, and so we thought we'd do a podcast explaining what we are all doing with IDUG and new content. I'm the chairman of the IDUG Content Committee, and I'm joined by Kurt Struyf of Lone Star consulting and Joe Geller of J Geller Software, who are also leaders in the Content Committee. Our charter is to cronical legacy content and provide new content to the IDUG website, as well as provide new content and interactions at IDUG technical conferences. So, in this podcast we detail some of our efforts so that you can learn about what we are doing as well as find the results of our efforts. We are drinking Coors Light and Rodenbach, the music includes Hold On by The Alabama Shakes, and Snake Farm by Ray Wylie Hubbard. The links to the various blogs on the IDUG web site can be found on the links page of db2expert.com.
Disclaimer and Copyright

In this podcast we talk about:

  • The IDUG ebulletin, content blog, DB2 news blog, and content file library
  • The IDUG DB2 tech talk channel
  • DB2 11 white paper
  • Beginners thread beginning January of 2014
  • Monthly topics, weekly content
  • Bringing more new content to conferences

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p12_idugcc.mp3


8/13/2013 - Series 1 Podcast 11 - The Cross-Platform DBA (back to series 1), (back to top)
From Lincoln, Nebraska. Joe Eller of the Nebraska Department of Labor and I discuss the life and times of a cross-platform DB2 DBA. We've both been working with DB2 on z/OS, AIX, and Windows. We compare the environments and talk about the various skills you need to work across platforms. Joe is drinking an Empyrean Third Stone Brown and I am drinking a Sierra Nevada Summerfest Lager. We're joined by Joe's wife and race car driver Teresa and we're listening to One of Those Days, Shakin' all Over and Nowhere in Time by Eilen Jewel.
Disclaimer and Copyright

In this podcast we talk about:

  • Environmental considerations
  • Being a jack of all trades
  • Writing scripts
  • Backup and recovery considerations
  • Monitoring
  • Calling DB2 LUW from SPUFI
  • DPF versus partitioning
  • Replication, codesets
  • Recommendations
    • Automatic storage
    • Storage groups
    • Space allocations
    • Cron and email connections
    • Portable sql

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p11_crossp.mp3


6/10/2013 - Series 1 Podcast 10 - Fun with DB2 LUW (back to series 1), (back to top)
From Orlando, Florida for the IDUG NA 2013 Technical Conference! I'm joined by Ember Crooks and Scott Hayes in my room, otherwise known as the Dan Bar! We are drinking water and some of my home made beer, along with some guest beers brought over by friends. We discuss some of the big performance tuning buttons as well as some specifics about logging and backup/recovery. We're listening to Sugarfoot by Black Joe Lewis, Lost by Coldplay, and Little bit of Everything by Dawes.
Disclaimer and Copyright

In this podcast we talk about:

  • Automatic storage and table spaces
  • Table space and buffer configuration
  • I/O configuration issues
  • Physical design issues
  • Self tuning issues
  • Archival logging
  • Backup and recovery
  • HADR
  • TSA

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p10_luw.mp3


5/9/2013 - Series 1 Podcast 9 - XML and DB2 (back to series 1), (back to top)
From Orlando, Florida for the IDUG NA 2013 Technical Conference! I'm joined by famed DB2 consultant, and my brother from another, Kurt Struyf. Kurt and I have been doing a lot of research on DB2 and XML, as well as working with our customers on XML implementations in DB2. We collaborated on a stellar SQL and XML technical session at IDUG NA 2013, and thought we should take some of our experience to a podcast. We talk about all things XML and cover storage, XPATH expressions, indexing, SQL/XML, and more! We're drinking Yuengling and listening to Robbin the Liquor Store by The Scabs, Are you Alright by Lucinda Williams, and Carry On by Fun. It's been too long since I had a podcast with Kurt!
Disclaimer and Copyright

In this podcast we talk about:

  • storing XML in DB2
  • XML data type and documents
  • Producing XML from DB2
  • XPATH and XQuery
  • XPATH expressions
  • Performance
  • Indexing
  • FLOWR and more
  • Some differences across platforms

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p9_xml.mp3


2/12/2013 - Series 1 Podcast 8 - DB2 for LUW Performance (back to series 1), (back to top)
From Berlin, Germany. From the IDUG EMEA Technical Conference 2012 I speak with Melanie Stopfer of IBM and independent consultant Joe Geller about DB2 for LUW Performance. This critical discussion is a rare meeting of some of the best minds in the world of DB2 for LUW. We discuss a number of important features in versions 9.7 and 10.1, and how to take advantage of these advanced features for performance. I don't remember what we were drinking, but there's a good chance there was some Rodenbach involved! The song beds include Black Horse and the Cheery Tree by KT Tunstall, a song by the Baltimore band Telesma that unfortunately I don't remember but is way cool, and Baby Did a Bad Bad Thing by Chris Isaak.
Disclaimer and Copyright

In this podcast we talk about:

  • Major sytem settings
  • Access paths, especially hash join
  • Distribution stats and selectivity
  • New things in db2 10 for performance
  • Adaptive compression, storage groups
  • Tips and tools for performance

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p8_luwp.mp3


1/5/2013 - Series 1 Podcast 7 - DB2 for z/OS Data Sharing (back to series 1), (back to top)
From Las Vegas, NV. In this third of three podcasts from the IBM Information on Demand Conference I speak with Mark Rader of IBM about DB2 for z/OS Data Sharing. This is a must-listen for anyone who suspects that they might not have a proper data sharing configuration as we discuss how to configure data sharing properly for what you want to use it for; performance, distribution of workload, high availability. We are drinking home made beer and Rodenbach. The song beds include The Midnight Rider by the Allman Brothers, Trouble Maker by Weezer, and Rebel Girl by Survivor!
Disclaimer and Copyright

In this podcast we talk about:

  • What is Data Sharing
  • Why do you do data sharing?
  • High Availability with data sharing
  • Work Load Manager and data sharing
  • Configuration to acheive your goals
  • Possible performance and availability problems with data sharing

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p7_sharing.mp3


11/14/2012 - Series 1 Podcast 6 - DB2 Application Performance Analysis (back to series 1), (back to top)
From Las Vegas, NV. In this second of three podcasts from the IBM Information on Demand Conference I speak with Florence Dubois and John Campbell of IBM about how we go about collecting performance metrics and analyzing the information we get from accounting traces. Flo is drinking my home made (Wayward Brewing Company) Altbier, and I'm having a Rodenbach (John's got a water, but provides the popping sound effect when we try to click our plastic cups of beer). The song beds include The Sound of Sunshine by Michael Franti and Spearheads, Time by The Alan Parsons Project, and January Wedding by the Avett Brothers. An increadible highpoint in the history of the Cocktail Hour!
Disclaimer and Copyright

In this podcast we talk about:

  • Going beyond EXPLAIN for performance analysis
  • DB2 accounting and statistics trace
  • Appropriate DB2 traces to run
  • Utilizing a performance database
  • Trend analysis
  • Tips for effective performance analysis
  • The truth about IFCID 316 and 318

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p6_perf.mp3


10/24/2012 - Series 1 Podcast 5 - DBA 2012 (back to series 1), (back to top)
From Las Vegas, NV. In the first of three podcasts from the IBM Information on Demand Conference I speak with Craig Mullins about the evolution of the role of database administrator in the year 2012. We discuss the challenges that DBAs face today and then offer suggestions as to how they can make their lives a little easier while preserving their jobs. We both drinking my home made (Wayward Brewing Company) Abbey Dubbel beer. The song beds include Wild Mountain Honey by Steve Miller, Dream Baby by Roy Orbison, and Repo Man by Ray LaMontagne. Listen as I miss the post on the opening song, but in the next two podcasts I get better!
Disclaimer and Copyright

In this podcast we talk about:

  • The lives of the DBA in 2012
  • Work hours
  • Multiple database platform responsibilities
  • Tools
  • Platforms, connections, and governance
  • Data Studio
  • DB2-L and social connections
  • Books
  • Automation
  • Scripting

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p5_dba2012.mp3


6/13/2012 - Series 1 Podcast 4 - Advanced SQL (back to series 1), (back to top)
From Philadelphia, PA. David Simpson of Themis and myself decided to pow wow on the concept of advanced SQL before hitting the town for some BBQ and beer. We discuss the how and why of advanced SQL as well as the coding and performance advantages. We are drinking Yard's Philly Pale Ale and I pick up the guitar to add the music beds of Bridle on a Bull by Chris Knight, Harvest Moon by Neil young, and Freebird by Lynard Skynard. Enjoy!
Disclaimer and Copyright

In this podcast we talk about:

  • Why advanced sql?
  • Cost of calling database
  • Data intesive processes
  • Building and unit testing queries
  • Joins
  • Subqueries
  • Table expressions
  • Common table expressions
  • Grouping
  • OLAP
  • XML/SQL

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p4_asql.mp3


5/17/2012 - Series 1 Podcast 3 - The New Data Studio 3.1.1 (back to series 1), (back to top)
From IDUG NA in Denver, Colorado. We've got the best of the best when it comes to Data Studio; Saghi Amirsoleymani of IBM and Tony Andrews of Themis. We discuss the history of the visual explain tools and the evolution that landed us at Data Studio 3.1.1. Then we discuss the improvements that have been made to the tool, including the easier navigation and more powerful features. Tuning queries with Data Studio is discussed in some detail along with the use of the Statistics Advisor, all of which is available at no charge from IBM. Go to the links page for a direct link to the Data Studio download. The song beds include I'd Love to Change the World by Ten Years After, Live Forever by Joe Ely, and Better Days by Bruce Springsteen. Saghi is drinking my own Wayward Brewing Company Wild Cider and Tony is having a Wayward Brewing Company Kolsch-Style, While I'm having some Brazilian beer courtesy of my good friend Steen Rasmussen.
Disclaimer and Copyright

In this podcast we talk about:

  • History of EXPLAIN
  • The evolution of EXPLAIN products
  • Introduction to Data Studio 3.1.1
  • Data Studio myths debunked
  • How to tune in Data Studio
  • Input choices and filters
  • Visual explain aspect
  • Query transformation
  • Statistics Advisor

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p3_ds.mp3


5/16/2012 - Series 1 Podcast 2 - Taking Advantage of New SQL In DB2 9 and 10 (back to series 1), (back to top)
From IDUG NA in Denver, Colorado. I meet up with one of my favorite special guests and good friend Chris Crone. I saw Chris' presentation at IDUG on the newer SQL features in DB2 9 and 10 and it really struck a chord. Many shops have installed this software but few are exploiting these new SQL features. So, we thought we would give a rundown of some of the features we thought were important and worth exploring, especially from a performance perspective. The song beds include Bridle on a Bull by Chris Knight, Jambalaya by Eddy Raven and Jo-El Sonnier, and Blue by The Jayhawks. Chris is drinking some of my Wayward Brewing Company Abbey Dubbel beer, and I'm having some Brazilian beer courtesy of my good friend Steen Rasmussen.
Disclaimer and Copyright

In this podcast we talk about:

  • SELECT FROM (final table)
  • MERGE
  • INCLUDE in a DML statement
  • INSTEAD OF triggers
  • SQL procedures
  • OLAP specification

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p2_sql.mp3


2/21/2012 - Series 1 Podcast 1 - DB2 indexing options (back to series 1), (back to top)
Lincoln, Nebraska. In this podcast my special guest, Joe Eller of the State of Nebraksa, and I drop back to basics and discuss the many indexing options available with DB2 for z/OS. A lot of time we see an abuse of indexing, with a lot of people creating too many indexes, the wrong indexes, or improperly applying an certain index type. So, we discuss the different indexing options available, what they do, when they should be used, and the performance implecations of various indexing options. We are drinking Michelobe Amber Bock and listening toRing of Fire by Johnny Cash, For the Summer by Ray LaMontagne, and All in My Head by Shawn Mullins. Cheers!
Disclaimer and Copyright

In this podcast we talk about:

  • What are indexes?
  • How are indexes useful?
  • The types of indexes (primary, secondary, unique, clustering)
  • performance issues with indexes
  • Can we have two many indexes?
  • DPSI partition elimination
  • Using index only as access path improvement

Listen to the entire podcast here. Right click on the file name, and do a save as. Then you can listen on your PC, or download into your portable device to listen to anywhere! db2_Cocktail_Hour_s1p1_index.mp3


The Technology (back to top)

We're using Dan's PC, a Toshiba Satellite notebook, and the following sweet stuff:

  • Proline PLDMS1 Desktop Tripod Microphone Stand
  • Behringer MIC200 tube ultragain preamp
  • Alesis MultiMix 8 USB Mixer
  • CAD Equitek E100**2 supercardiod large diaphragm side address condenser microphone
  • Studiorack Live podcasting software
  • Audacity audio editing software

  • CAD Equitek E100 supercardiod large diaphragm side address condenser microphone (presumed stolen by Hertz employees)
  • Behringer MIC100 tube ultragain preamp (presumed stolen by Hertz employees)
  • Pinnacle table top mic stand (confiscated by airport security after going through 6 times!)
  • QuikLok A188 Desktop Tripod Microphone Stand (presumed stolen by Hertz employees)
  • QuikLok A188 Desktop Tripod Microphone Stand (broken and discarded during series 4, podcast 5
  • Mixcast Live podcasting software (retired)
  • Castblaster Live podcasting software (retired)
  • Dell Inspiron 8100 (retired after series 1, podcast 8)
  • HP Pavilion dv1010us (retired after series 2, podcast 9)
  • Fujitsu Lifebook U801 (retired after series 4, podcast 5)


Disclaimer and Copyright: (back to top)
  • All podcast content is copyright ©2012 by DanL Database Consulting, and its intended for the sole use of the listener only. DanL Database Consulting strictly forbids the duplicating, transmission, or any form of copying of these podcasts without our express written consent. Any violators will be prosecuted.
  • The information, files, programs, scripts, and any other executables contained at this site is based on techniques, algorithms, and documentation published by the several authors and companies, and in addition is the result of research, and development. It is therefore subject to change at any time without notice or warning.
  • The information, files, programs, scripts, and any other executables contained at this site has not been submitted to any formal tests or review and is distributed on an “As is” basis without any warranty, either expressed or implied.
  • The use of this information, files, programs, scripts, and any other executables contained at this site or the implementation of any of these techniques is a client responsibility and depends on the client’s ability to evaluate and integrate them into the client’s operational environment. DanL Database Consulting assumes no responsibility for any situation arising from the use of these downloads.
  • While each item may have been reviewed for accuracy in a specific situation, there is no guarantee that the same or similar results will be obtained elsewhere.
  • Clients attempting to adapt these techniques, files, programs, scripts, and any other executables contained at this site to their own environments do so at their own risks. Any information, files, programs, scripts, and any other executables contained at this site should be reviewed in their entirety.



|Home|Downloads|Podcasts|News|Events|DB2 Links|Services|Contact|E-list|RUGs|

All content copyright ©2012-2014 DanL Database Consulting
IBM is a registered trademark of International Business Machines Incorporated
DB2 is a registered trademark of International Business Machines Incorporated