The Whole Package Cache

Recorded April 7, 2017 • 48 minutes

Fred and Ian talk about the first Fixpack / Modpack for DB2 11.1; New functions and improvements available in DB2 11.1; and look forward to the IDUG North American Conference coming up in Anaheim in May.

Please subscribe to our newsletter to receive an email when new episodes are released.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | RSS

Show Notes & Links

• OS/2 Warp
• 1.44Mb Floppy Disks
• Zip Drive
• The CURR_EFF_ARCH_LEVEL and CURR_EFF_CODE_LEVEL DBM configuration values
• Chris Crone’s DB2 12 Continuous Delivery Article
• Fred’s DB2 Regular Expressions Article
• New HASH function
• There won’t be any more interim dsmtop updates
• ELK stack
• IDUG EMEA 2017 Call for Presentations is open until April 24
• IDUG 2017 North America Conference
• IDUG Data Tech Summit
• Fred’s IDUG NA Picks
  • Dale McInnis: Uncommon HADR (C06)
  • Melanie Stopfer: DB2 11.1 Upgrade (C09)
  • Sudip Kundu: pureScale Deployment on Power 822 and 824 (D11)
• Ian’s IDUG NA Picks
  • Phil Nelson: Integrating DB2 with node.js (G09)
  • Paul Murray: Being a DBA in an Agile / DevOps Environment (F12)
• Mike Krafick has been resurrecting /r/DB2
• Ian’s StackOverflow Rant on Clustered Indexes
• Paul Turpin’s db2batch Presentation

Recorded May 18, 2016 • 37 minutes

Fred and Ian talk about the recent DB2 11.1 for Linux, UNIX and Windows announcement and look forward to the IDUG North American conference taking place in Austin, TX from May 23-26.

Make sure you check our newsletter if you’d like to receive an email when new episodes are released.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | RSS

Show Notes & Links

• DB2 11.1 Announcement Letter
• For details on DB2 11.1:
  • DB2Night Show #177
  • DB2Night Show #178
  • DB2Night Show #179
• DB2 End of Service Dates have been announced for DB2 9.7 and DB2 10.1
• dsmtop developerWorks Community

IDUG North America 2016

• Conference Agenda
• Session Picks:
  • Ian’s Session: “DB2 Data Security: Controlling Access and Catching Bad Guys”, Session D02, Monday May 23 @ 1:30pm
  • Fred’s Session: “Guilt-Free JSON, Smarter Searches and Other Useful App Dev Patterns”, Session G08 on Tuesday May 24 @ 2:15pm
  • Melanie Stopfer: “Upgrading to DB2 LUW with the Latest Version”, Session C01, Monday May 23 @ 12:15pm
  • Phil Nelson: “DB2 Routine Development: Beyond the Basics”, Session E01 on Monday May 23 @ 12:15pm
  • Ember Crooks: “SQL Infusion: Tuning and Using the Package Cache”, Session C03 on Monday May 23 @ 3:45pm
  • Martin Hubel: “Block Party! Techniques for Tuning DB2 LUW Buffer Pools”, Session C08 on Tuesday May 24 @2:15pm

Recorded December 8, 2015 • 57 minutes

Fred and Ian review IBM Insight in Las Vegas and IDUG EMEA in Dublin then Fred shares a clever use for ISO8859-8.

Make sure you check our newsletter if you’d like to receive an email when new episodes are released.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | RSS

Show Notes & Links

• Henrik Loeser’s Data Henrik Blog
• Ian’s session on encryption was the first video from Dublin to be released on idug.org
• The Lion, the Witch and the Wardrobe
• Writer’s Tears Whiskey
• SSSS
• IDUG EMEA 2016 Call for Presentations

Recorded October 22, 2015 • 47 minutes

Fred and Ian review IDUG North America, discuss plans for IBM Insight and IDUG EMEA and then discuss Fixpacks, BLU MPP and come down with a mild case of zEnvy™.

Make sure you check our newsletter if you’d like to receive an email when new episodes are released.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | RSS

Show Notes & Links

• IDUG North America 2015 Wrap-up Article

• Insight 2015 was great, but something was missing

• IDUG North America 2016 will be in Austin. The Call for Presentations closes October 30, 2015 November 7, 2015!

• IDUG Europe 2015 is in Dublin in 2 weeks!

  

  Conference Grid

  Fred’s Picks:

  • D04: The 5 Ws of Database Encryption
  • E05: Analyze youR Data (with R)
  • F13: What a DBA Needs to Know about Distributed Shells and SSH

   

  Ian’s Picks:

  • D02: Facilitate WLM functions and tools to improve your monitoring
  • D07: Best Practices for Minimizing and Eliminating Planned outages with DB2 LUW



 

• Fixpacks have been released for all current versions of DB2

• BLU MPP available in dashDB Offering

• “DB2 on Cloud” pre-built configurations for OLTP databases in the cloud.

• Dan Luksetich’s article on JSON and REST in DB2 for z/OS

• IBM has already announced an early beta for DB2 12 on z/OS!

Recorded April 3, 2015 • 53 minutes

Fred and Ian discuss April Fools’ pranks, the general availability of the SQL Database premium plan on Bluemix, follow up on the discussion about Data Server Manager, the upcoming IDUG North American conference in Philadelphia and other DB2 news.

Make sure you check our newsletter if you’d like to receive an email when new episodes are released.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | RSS

Show Notes & Links

• April Fools’ Day Pranks
  • Fred’s Fresh Meat
  • pureScale Express-C failed to draw any attention
• BlueMix SQL Database service is GA, including pricing for the Premium Plan service
• IBM’s Data Server Manager Tech Talk
• Forget $1 Billion investments, IBM invests $3 Billion in IoT
• The future of the Internet of Things
• DBA first world problem: “Mah bufferpool’s too damn big”
• Nice post from @data_henrik on writing db2audit logs to syslog
• The Which Distributed Edition of DB2 10.5 … developerWorks article was updated for new 10.5 features

IDUG NA

• IDUG’s first casinorific conference in over a decade: http://www.vfcasino.com/
• In actual Philadelphia, use http://www.vinylhub.com/ to find record stores
• Fred will host IDUG’s Whiskey SIG at http://www.philadelphia.villagewhiskey.com
• Fred is drinking https://www.masterofmalt.com/whiskies/clynelish/clynelish-1997-bottled-2012-oloroso-sherry-cask-finish-distillers-edition-whisky/
• Ian’s Session Recommendations:
  • C14: DB2 Security Tips and Best Practices – Walid Rjaibi @WalidRjaibi
  • D05: Performance “Worst Practices” for DB2 – Steve Rees @db2steve
  • E15: Configuration (Mis) Management – Deploying DDL changes – Ken Shaffer @aerodata
  • E16: BLU Insert, Update and Delete – An Insider’s Perspective – Adam Storm @stormadamj
• Fred’s Likes:
  • E06: Hidden Gems: The Top 10 Most Under-utilized Functions in DB2 – Matthias Nicola
  • D07: Top Ten DB2 LUW Explain Tips – John Hornibrook @JHornibrookIBM
  • F16: Migrating from IMS to DB2 with DL/2 – Bernie O’Connor
  • C17: Using The Multi-Temperature Data Feature with Fully Automated Storage Tiering – Roger Sanders @Roger_E_Sanders

Recorded March 12, 2015 • 38 minutes

Fred and Ian discuss the latest DB2 news, IBM allowing ads in Redbooks, the just-announced Data Server Manager product and some quirks about the MON_GET functions and lock monitoring.

Make sure you check our newsletter if you’d like to receive an email when new episodes are released.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | RSS

Show Notes & Links

• Followup on RedHat Bug discussed in Episode 21:
  • RHSA-2015:0087 contains three semaphorish fixes
  • IBM’s secret bug number 1165277 isn’t mentioned specifically by Red Hat, but it appears in a more detailed rundown of the new kernel
• IBM’s Support Policy for running DB2 on Microsoft Azure
• Ads in Redbooks WTF?
• Willie Nelson shilling for Taco Bell
• Cards Against Humanity
• Fred’s awesome “laptop”
• IBM Data Server Manager v1.1 Announcement Letter
• There will be a Data Server Manager Tech Talk on March 26
• The handy bug – APAR IT04669 – that allows you to rename a table, including the schema