planetDB2 logo

  planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.

August 29, 2014

Data and Technology

An Introduction to Database Design: From Logical to Physical

Originally posted on Data and Technology Today: A proper database design cannot be thrown together quickly by novices. What is required is a practiced and formal approach to gathering data...

(Read more)

Susan Visser

What is DB2 “Cancun Release”?

If you’ve been watching social media sites today, you may have noticed a few things mentioned about a new DB2 10.5 release.  There is one that went out today and it has a few names:

  • DB2 “Cancun Release”
  • DB2 10.5 “Cancun Release”
  • DB2 10.5 Fixpack 4

Yes they’re all the same.  The message here is that the fixpack did more than fix bugs, it provided a few new features.  The features are so important that rather than just keep the name as FP4, we added a cool name to bring some attention to it.

The main message for DB2 "Cancun release” is that on top of the powerful features already in DB2 10.5, you now get more:

You can get real-time answers to ALL your questions with instant insight into historical and “as it happens” data with Shadow Tables.  Learn more from this blog from Amit Patel:  Find out what’s new for BLU Acceleration.

Do you run SAP applications with DB2?  Running them in the DB2 "Cancun Release" will bring you superior performance and less disruption to your SAP Environments.  If reporting is key for you, report generation workloads on DB2 on POWER8 will blow you away: tests showed average performance improvement of 82x compared to a competitive database: Learn more:

If you work extensively with DB2 and pureScale you’ll love this release! One new thing: You can now perform online table reorgs and incremental backups in pureScale environment.  And the latest release improves ease of use and serviceability of installation, configuration and updates.  Where did all these ideas came from?  From our large DB2 pureScale community.  Yes, we listened!  Learn more from this blog entry from Kelly Schlamb: pureScale at the beach: What's new in DB2 "Cancun Release"?

If you’re coming from an Oracle background, you’ll be happy that it is even easier than before to use your acquired SSQL mastery with DB2.  You’ll find no skills issues if you move to DB2 from Oracle.  The SQL skills you already have are transferable: Learn more:

That’s it for today, but I can give you a hint for the coming weeks:  There are papers, tweetchats, webinars, blogs, graphics, presentations, conference sessions, videos, developerWorks articles, articles, and much more currently in development.  I suggest you follow for details on all this as we release it.

In fact, let me ask you to do something.  As you go through this information, write down your questions and send them to me or tweet to #ASKDB2.  We’ll gather all of your questions and make sure they are publicly answered.



Willie Favero

That good old DB2 catalog poster

(Posted Friday, August 29, 2014) One of the very cool parts of working with DB2 for z/OS back in the 80s was hanging all of the DB2 posters on the walls of ones office.  Actually, having an office with walls to hang stuff on was also pretty cool.. but I digress. You would atte...

(Read more)

DB2 Guys

pureScale at the Beach. – What’s New in the DB2 “Cancun Release”

Kelly Schlamb DB2 pureScale and PureData Systems Specialist, IBM   Today, I’m thinking about the beach. We’re heading into the last long weekend of the summer, the weather is supposed to be nice, and later today I’ll be going up to the lake with my family. But that’s not really why the beach is on […]

Ciaran de Buitlear

pureScale enhancements included in the new DB2 Cancun Release

Today is the day when DB2 10.5 FP4, known as Cancun Release has been published officially!

This DB2 Cancun Release includes many different new features and improvements in differents areas like:

  • Column-organized tables
  • SQL compatibility
  • Monitor elements
  • HADR
  • pureScale

The summary of the enhancements can be found here:


There are some exciting improvements and new features included on the pureScale side, which will make even easier to implement pureScale!

  • Support to pureScale over TCP/IP sockets
  • Geographically dispersed DB2 pureScale cluster (GDPC) is extended to support RDMA over Converged Ethernet (RoCE)
  • pureScale can now be deployed on virtual machines using sockets (on VMware ESXi and KVM)
  • Incremental backup support
  • DB2 Spatial Extender support
  • Online (inplace) REORG now supported
  • Federated two-phase commit

Some of these features are really useful to get started with pureScale like having the possibility to run pureScale using just a basic TCP/IP network or using virtual machines under KVM or VMware ESXi. This is great for who wants to explore pureScale technology just using a basic network or a virtualized environment!

But also, for actual pureScale users, two great enhancements like incremental backups and online REORG will be a huge improvement in terms of system and database maintenance and administration.

If you like me are really looking forward to try all these new features, just go and download the just released DB2 Cancun Release 10.5 FP4 at this link:


Feel free to ask any question or comment you may have on all these new and exciting features for pureScale!


Robert Catterall

DB2 10 for z/OS, 1 MB Page Frames, and the Number 6656

I recently received an interesting message from a mainframe DB2 person I've known for a long time. At his DB2 10 for z/OS site, 1 MB page frames had recently been made available on the System z servers, and my friend moved to leverage this resource via page-fixed DB2 buffer pools. Nothing unusual there. What's interesting is the information he saw in the output of -DISPLAY BUFFERPOOL commands subsequently entered for the page-fixed pools. I'll get to that strange-looking data in a moment, but...

(Read more)

August 28, 2014

Dave Beulke

Four Facts Millennials Need to Know about the Mainframe

When I talk to millennials coming into management and programming it appears that their knowledge of the mainframe is very limited or non-existent. Since many universities have stopped teaching mainframe classes, the recent college graduates don’t even have a basic understanding of the mainframe...

(Read more)

DB2 Guys

Is Your Database a Hero or a Hindrance?

Kelly Schlamb DB2 pureScale and PureData Systems Specialist, IBM Here’s a big question for you – Is your database a hero or a hindrance? In other words, is your database environment one that’s helping your organization meet your performance, scalability, and availability needs or is it holding you back from meeting your SLAs and keeping […]

August 27, 2014

Susan Visser

Have Oracle expertise? Turn it into DB2 skills, easily

Yesterday I published the blog entry NOW is a good time to upgrade to DB2 10.5! and I had a comment asking me how people can quickly upgrade their skills.  The person asking was focused on those who have Oracle skills and now want to work on DB2, but new skills need to be taught to those who are skilled in DB2 9.7 and now need to move to DB2 10.5.  Here is what I suggest:

Three Easy Steps to Learn BLU Acceleration

  1. Step1: BLU Acceleration Technical Deep Dive
    IBM Distinguished Engineer, Sam Lightstone , (1.5 hours)
  2. Step 2: DB2 10.5 with BLU Acceleration free flash book
    New analytics for the era of big data
  3. Step 3:Try it using one of these options 
    BLU Acceleration for Cloud  - OR – 90-day free trial software

My biggest tip:  Be active in social to get the very latest in what is published.  Social channels like blogs, twitter and facebook are used to promote the ever growing list of learning materials.  You’ll find links to white papers, articles, best practices, videos, books, and even formal education.    If you’re on twitter, there is really only one place to follow:  This is the official DB2 account and posts will tell you everything you need to know, including activities generated outside of IBM.  Although IBM produces a ton of great content, we rely our partners, IBM Champions, and IBM Gold Consultants to also publish content about our products.  I’ll do a separate blog post on the incredible learning opportunities provided by our user groups and partners.

We have a dedicated website called that is the go-to place for all things BLU.  My intern Tori McClellan just published her first blog entry about what you can find on the “BLU Hub”: Steps toward the Future: How IBM DB2 is changing the Game.    

DB2 is something like 99% compatible with Oracle.  Danny Arnold does a great job summarizing the areas of compatibility: Simplifying Oracle Database Migrations.  As you are aware, mastery comes through practice.  It may take a bit of habit changing and practice to master the skills you need to be efficient at using DB2, even if the skills are similar.   If time is not your friend, you may benefit by joining a bootcamp session:   You may also find this education roadmap useful, especially if you can arrange to have Melanie Stopfer teach a class for you.


I hope this helps!  I look forward to more comments and perhaps suggestions on future blog posts.





DB2 Guys

Steps toward the Future: How IBM DB2 is changing the Game

Tori McClellan Super Awesome Social Media Intern   Welcome to the New Age of database technology! IBM DB2 with BLU Acceleration changes the game for in-memory computing.  Due the importance of in-memory computing, we created a dedicated website to take you through all the details, references, and more: !  This website is in […]

August 26, 2014

Susan Visser

NOW is a good time to upgrade to DB2 10.5!

Sometimes it can be scary to upgrade software.  Face it, when things are going well, why introduce a change that may put your life into chaos?  We have enough change and stress in our daily lives, is it worth introducing more?  Of course, the answer is, it depends.  What benefits will you achieve? 

Let’s step back a second and think about when you first got your smart phone.  That was a huge change to your routine, most of it fun, but a huge change, nonetheless.  What did you gain?  Access to more, and more, and more.  You can get the latest news on twitter, post a photo on FB, post a review of the restaurant you just ate at, find a parking spot in a normally crowded part of the city, buy movie tickets for the movie you want to see tonight, check out the traffic volume on your normal routes home, find out about a sale at the Costco that you are about to drive past.  And more.  My Dad is still using an old cell phone and asked for help adding contacts.  I can no longer remember how to do that.  It is one of the things that is much easier on a smart phone.

The same goes with a software upgrade.  DB2 9.7 seems to be a very popular release.  At the beginning of Scott Hayes’ DB2 Night Show webinars, he has a polling question about the current release of DB2 that people are using. I almost cry when I see the number of people still at 9.7.  Working for IBM, I’m privy to the latest features of the latest products and in my biased view, buy into the claims that the latest level is so much better.  I’m not the only one that thinks so. 



Yes, upgrading your software introduces massive changes to your environment, but the benefits of using DB2 10.5 versus older versions is worth the effort, especially when you are able to learn from the experts and minimize your risks.

For added incentive, watch these videos that feature various clients talking about what they discovered after upgrading to DB2 10.5:



Ember Crooks

DB2 Basics: db2top

There are a lot of things I can cover on db2top, and probably more tips and tricks using db2top than many other tools out there. Searching the web on db2top gets more good results than on many other...



IBM Redbook Mobile App

Over the years, I've written often about IBM Redbooks. I enjoy learning from the experts who author these publications. I also enjoy sharing this information...

August 25, 2014

DB2 Guys

How to Revolutionize Analytics with Next-Generation In-Memory Computing

by Les King Director, Big Data, Analytics and Database Solutions – Information Management, Software Group   We are now in the era of cognitive analytics. These are analytic processes that provide useful information with a timeliness which qualifies as “speed of thought”. More and more clients are leveraging the next generation of analytic computing […]

Susan Visser

Learn the Basics!

Regardless of where you are on your journey towards mastering DB2, you can never neglect to learn the basics to the fullest.  To help you learn the basics, we suggest that you use Ember Crooks as your mentor.  She is experienced and is writing a blog series about what she knows.  Here are the first 10 in the series:

  1. DB2 Basics: Users, Authentication, and Authorization
  2. DB2 Basics: Aliases
  3. DB2 Basics: Storage Groups
  4. DB2 Basics: What is an Instance?
  5. DB2 Basics: What is an Index?
  6. DB2 Basics: What is a Reorg?
  7. DB2 Basics: Capitalization
  8. DB2 Basics: Quotation Marks
  9. DB2 Basics: Triggers
  10. The Basics of Code Pages in DB2


You can count on Ember to add to this series:  Keep up with the latest by following Ember on twitter: @ember_crooks.

If you like watching videos with tips, be sure to check out the replays on the DB2Night Show.  Not only did Ember take part in two seasons of the “DB2’s Got Talent” competition, she acted as a guest judge in the latest season and has been a guest star several times, including this one: The DB2Night Show #133: Why Low Cardinality Indexes (STINK), Ember Crooks.



More about Ember:

Over the last 13 years, Ember Crooks has become an IBM Gold Consultant and IBM Champion, specializing in DB2. Although she deals primarily with high volume transactions, she has taken an alternative route to write a series of blogs focused on the basics. In order to achieve greater level of success with anything, a fundamental foundation needs to be secured in place before building up to more advanced skills.




Robert Catterall

DB2 for z/OS: Can a Pooled DBAT Hold Locks?

The answer to the question in the title of this post is, "No, it can't -- unless it can." How's that for a hook? OK, a little background. A DBAT is a database access thread. It's the kind of thread that a network-attached application process uses to interact with a DB2 for z/OS system (such a process, also referred to as a DRDA requester, issues SQL statements that get to DB2 by way of the distributed data facility, aka DDF). When a transaction using a "regular" DBAT completes, the DBAT goes...

(Read more)

Henrik Loeser

Setting up and using a DB2 in-memory database on IBM Bluemix

Last Friday I was on the way back from some customer visits. While traveling in a German highspeed train I used the Wifi service, connected to IBM Bluemix and created a DB2 in-memory database. Let me...

(Read more)

August 23, 2014

Craig Mullins

DB2 Health Checks - Part 3

In parts one and two of this series on DB2 health checks, we discussed the importance of regularly checking the health of your DB2 subsystems and applications. We also looked at some of the issues involved in a health check including figuring out the scope of what is to be involved and some of the considerations to ponder as you approach assessing the health of your DB2 environment. Of course,...

(Read more)

August 22, 2014

Vincent McBurney

IBM Information Server Just Got Cheaper with Unlimited User Entitlements

IBM has removed the requirement for authorized user licenses for Information Server product bundles making significant savings for customers, especially those with enterprise governance and quality programmes.

August 21, 2014

Dave Beulke

Three DB2 Performance Areas to Verify When Experiencing DB2 Performance Degradation

When you experience DB2 performance degradation, you’ll discover no one has changed anything (of course), or admits to changing anything. Luckily there are a wide variety of DB2 performance dependencies to check. When DB2 processes are running consistently well, then suddenly the DB2 performance...

(Read more)

ChannelDB2 Videos

DB2 Tips n Tricks Part 42 - How to Identify DB2 Client Release Version from Server


How to Identify or Monitor DB2 Client Release Version from DB2 Server Solution: CLIENT_PRDID - Client Product ID Monitor Element in * Monitor Routine - MON_G...

August 19, 2014

Willie Favero

August 2014 (RSU1407) service package has been tested and is now available

(Posted Tuesday, August 19, 2014) Testing for RSU service package RSU1407 is now complete.  This RSU completes the first quarter of 2014.  This August 2014 2nd Quarter 2014 1st Addendum "Quarterly Report" (67 KB PDF file) contains ALL service through the end of M...

(Read more)

Henrik Loeser

Accessing DB2 from node.js on IBM Bluemix and locally

Some days ago I started experimenting with node.js. Other than JSON and some click functions on webpages I don't have much experience with JavaScript. The reason for this "adventure" is that node.js...

(Read more)

Henrik Loeser

Sample IBM Bluemix Application: Extended IP logging with node.js and DB2

As I wrote in my last blog article I have been playing around with node.js and DB2 on IBM Bluemix. Now I am done with my first server-side JavaScript application which I named...

(Read more)

Ember Crooks


Today we are going to talk about some random DB2 features that can’t stand in a blog of their own, but are worth discussing nonetheless. These are tidbits I had discovered during “DB2’s Got...



An In-Depth Look at Buffer Pool Monitoring and Tuning

IBM recently released a Redpaper, "IBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning." While this document is intended for DB2 systems administrators, it...

August 18, 2014

Triton Consulting

DB2 10 for z/OS withdrawn from marketing – Date Announcement

IBM have announced that DB2 for z/OS will be withdrawn from marketing from 6th July 2015.  This means that DB2 10 along with DB2 10 VUE and the DB2 10 Utility Suite will no longer be available to order.  This … Continue reading →

(Read more)


planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.