Welcome to the Planet DB2 Blog

Sharing best practices and innovative approaches to the continually evolving world of IBM mainframe database and Db2 technology.

The DB2Night Show #234: Db2 Query Optimization 101

by The DB2Night Show | Apr 10, 2021

Presented by: John Hornibrook STSM, IBM Toronto Lab

“The DB2Night Show #234: Db2 Query Optimization 101” Replays available in WMV and M4V formats!

100% of our studio audience learned something!John presented how Db2 query optimizati…

Happy Birthday to the IBM Mainframe

by Craig S. Mullins | Apr 7, 2021

I am older than the mainframe… I turned 58 on April 3rd, and the IBM mainframe officially celebrates its 57th birthday today, April 7th.The IBM 360 was launched on April 7, 1964 and the world of enterprise computing has never been the same.Here …

Upcoming Db2 IDUG conferences

by Henrik Loeser (data_henrik) | Apr 6, 2021

A quick post on the upcoming Db2 conferences, organized by the International Db2 User Group (IDUG). The IDUG North America “2021 NA Db2 Tech Conference” is going to be a virtual event again. It is scheduled from June 7-16, 2021. The conference agenda i…

Db2 for z/OS: Clearing Up Some Matters Pertaining to PGSTEAL(NONE) Buffer Pools

by Robert | Mar 31, 2021

I have written a few entries for this blog in which I provided information about Db2 for z/OS buffer pools defined with PGSTEAL(NONE), including one from a few years ago in which I differentiated the PGSTEAL and PGFIX buffer pool specifications, a…

cron-like scheduling on IBM Cloud

by Henrik Loeser (data_henrik) | Mar 30, 2021

cron-like schedulingSome days ago I stumbled over my 2015 post “Bluemix: Simple cron-like service for my Python code”. It is not just the name Bluemix which is dated. Since then, it has transformed into IBM Cloud Platform and has added serverless compu…

Db2Night Show #Z115: Db2 Java Performance Best Practices

by The DB2Night Show | Mar 27, 2021

Presented by: Dave Beulke, IBM Gold Consultant and Champion for IM

“The Db2Night Show Z115: Db2 Java Performance Best Practices” Replays available in WMV and MP4 formats!

100% of our studio audience learned something!Dave provided Hi…

Driving data lake success with automated governance, storage options and enterprise readiness

by Holly Vatter | Mar 15, 2021

The importance of the data lake has continued to grow as organizations contend with the growth of unstructured data and its sources. By one estimate “80% of worldwide data will be unstructured by 2025” [1] meaning that companies must take a look at their data lake now...

Db2 12 for z/OS Function Level 509

by Craig S. Mullins | Mar 14, 2021

Late last month, February 2021, IBM introduced a new function level, FL509, for Db2 12 for z/OS. You can find in-depth details here.But if you are looking for a high-level synopsis, read on! There are several interesting new capabilities int…