planetDB2 logo

Planet DB2 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.


February 16, 2018

DB2Night Replays

The DB2Night Show #Z84: Revival of the SQL Tuner

Presented by: Sheryl Larsen Sr. DB2 Product – Specialist, BMC Software "The DB2Night Show #Z84: Revival of the SQL Tuner" Replays available in WMV and M4V formats! 98% of our studio audience learned something!Sheryl presented about increasing the attendee’s ability to identify and fix access path problems. Watch the replay...

(Read more)

February 15, 2018

Henrik Loeser

Easy Database Setup the Serverless Way

Serverless Slackbot with Db2 A tutorial I wrote, featuring a database-backed Slack chatbot, is now live. It uses Db2 as database system to store event data. The client accessing the database is...

(Read more)

February 13, 2018


The Latest on Data Server Manager

I'm just back a week at the Db2 for z/OS Silicon Valley Lab (SVL), where we discussed z Analytics products. One of the sessions I really enjoyed was the hands-on lab for Data Server Manager (DSM). This recently updated solution has lots of new features to help administer, monitor, manage and optimize not just Db2 for z/OS, but the entire Db2 family (Db2 for z/OS, Db2 for LUW, Db2 on Cloud, Db2 Warehouse on Cloud, Db2 Warehouse Private).

February 12, 2018

Kim May

Congratulation to the 2018 IBM Champions!

My post is a bit late – and a bit self-referential. But sincere! Congratulations to all the 2018 IBM Champions!!! According to the IBM “Champion of Champions” Libby Ingrassia, IBM reviewed more than...

(Read more)

February 07, 2018

Triton Consulting

The Mainframe is growing and here’s the proof!

We don’t like to say “we told you so” but…….the Mainframe is growing and here’s the proof! It’s not unusual for us to be countering arguments that the Mainframe is dead so we were delighted to read the recent BMC … Continue reading →

(Read more)

February 06, 2018

Henrik Loeser

Chatbots: Some tricks with slots in IBM Watson Conversation

As you might remember, I have been using the IBM Watson Conversation service and DB2. My goal was to write a database-driven Slackbot, a Slack app that serves as chat interface to data stored in Db2....

(Read more)


Big Changes for Db2 Analytics Accelerator

Following up on last week's post on data virtualization and the ongoing effort to keep data on the mainframe, I thought it would be appropriate to provide an update on the latest release of IBM Db2 Analytics Accelerator (IDAA) V7.1.

February 04, 2018

DB2Night Replays

The DB2Night Show #202: Using Jupyter Notebook for Db2 Administration

@ember_crooks Special Guest: Ember Crooks Director, Xtivia IBM DB2 GOLD Consultant Using Jupyter Notebook for Db2 Administration 100% of our audience learned something! If you like tools that help make your Db2 Administration tasks easier, then watch this replay and learn about Jupyter Notebook from IBM GOLD Consultant Ember Crooks! Ember teaches how to organize your favorite administrative SQLs, plus create graphs and reports, and more! ...

(Read more)

February 01, 2018

Craig Mullins

Db2 Application Development for Performance: Be Early and Be Informed

The title of this blog post is also the title of one of my two IDUG Db2 Tech Conference presentations in Philadelphia this year. I chose this topic because I am in the process of writing a book on Db2 performance from a developer perspective. There are a lot of performance-focused presentations but most of them are from the perspective of monitoring and tuning. In other words, they are about...

(Read more)

DB2Night Show News

Men are from Mars, Women are from Venus, and Ember Crooks presents Jupyter

Don't miss Ember Crooks presenting "Using Jupyter Notebook for Db2 Administration" on Friday 2 February at 10am CST! REGISTER! IBM Champion and IBM GOLD Consultant Ember Crooks had standing room...


January 30, 2018


Data Virtualization on z/OS

For almost 30 years I've worked with and supported business applications running in Db2 for z/OS environments. During that time, there's been a near constant effort to replicate data from the mainframe to Linux, UNIX and Windows (LUW) platforms.

January 25, 2018

Jack Vamvas

DB2 LUW 11.1 product documentation available in PDF format

For a period of time the DB2 LUW 11.1 documentation was only available online. The good news is it's now available in PDF format and can be downloaded to read through .

To download the documentation visit the Db2 Version 11.1 for Linux, UNIX, and Windows English Manuals

Henrik Loeser

Access Db2 from IBM Cloud Functions the Easy Way (Node.js)

Db2 access via IBM Cloud Functions Recently, I have been experimenting with the IBM Watson Conversation service and Db2. With a new feature in the conversation service it is possible to perform...

(Read more)

January 23, 2018

Data and Technology

A High-Level Guide to SQL Tuning

SQL tuning is a complicated task and to cover it adequately requires a full-length book of its own – actually, perhaps several if you use multiple DBMS products. That said, there are some good...

(Read more)


A Look at Upcoming Db2 Conferences

I was recently asked about Db2 conferences and which provide the most technical content. Short answer: the long-standing SHARE and IDUG conferences.

January 22, 2018

Kim May

2018 Events – So Much To Do!

With IBM’s consolidation of conferences resulting in the cancellation of last Fall’s World of Watson/Insight/IOD Conference, and the merge into March’s upcoming Think conference,...

(Read more)

Robert Catterall

Db2 12 for z/OS and Insert Algorithm 2: Faster, More-Efficient INSERTs than Ever Before

Near the end of the blog entry I most recently posted prior to this one, I mentioned that a specification of MEMBER CLUSTER for a Db2 for z/OS universal table space could help maximize INSERT throughput and efficiency, in situations where the importance of that objective outweighs that of keeping data rows physically ordered by the target table's clustering key. I also noted that MEMBER CLUSTER sets you up to take advantage of a Db2 12 for z/OS enhancement called (rather cryptically)...

(Read more)

January 20, 2018

ChannelDB2 Videos

HADR Tutorial Part 14 - GOOD Alternative for LOGINDEXBUILD


GOOD Alternative for LOGINDEXBUILD Use Table Space Level Restore on Stand By Happy Learning & Sharing

January 19, 2018

DB2Night Replays

The DB2Night Show #201: Favorite Tuning Tips and Tricks for Db2 LUW

Special Guest: Joe Geller, JP Morgan Chase Favorite Tuning Tips and Tricks for Db2 LUW 100% of our audience learned something! SELECTIVITY, OPTGUIDELINES, Runstats, Indexes, Bufferpool Design, REORGs, monitoring advice, and more!! No wonder Joe won Best User Speaker at IDUG Lisbon 2017! Joe's presentation is full of terrific advice and tips! Watch and learn...

(Read more)

January 17, 2018

Triton Consulting

DB2 LUW Consultancy Taster Day

Here at Triton Consulting we are celebrating our 21st birthday. Although it doesn’t feel like much has changed since we set up shop, looking back it’s hard to believe that in the same year the internet had only just taken … Continue reading →

(Read more)

January 16, 2018

Triton Consulting

BLU Hits and Misses – the replay

Replay! If you missed the last DB2Night Show of 2017 then fear not, our partners over at DBI Software HQ have made the replay of Mark Gillis’ DB2 11 Performance: BLU Hits and Misses available as a replay. Take a … Continue reading →

(Read more)


Enhancements for Db2 Native REST Web Services

IBM recently released some fixes and new functionality for Db2 for z/OS. If you're currently using and or planning to use Db2 native RESTful web services, you should apply this maintenance. For Db2 11, apply APAR PI86867; for Db2 12, apply APAR PI86868.

January 12, 2018

Big Data University

Deploy Watson Conversation Chatbots to WordPress

If you’re reading this then you’ve most likely heard all the buzz around chatbots. In fact, you may have come up with a few scenarios where it would be really helpful for you to use one.

Most people consider chatbots to be in the realm of what only programmers can create, out of reach of business users who would otherwise have a need for them.

Thankfully, IBM provides the Watson Conversation service on their IBM Cloud platform which, combined with our WordPress plugin, solves that.

The plugin provides you with an easy way to deploy chatbots you create with IBM Watson Conversation to WordPress sites. In fact, you may have noticed a floating chatbot icon at the bottom of this page. Click on it to see the plugin in action.

What is Watson Conversation?

Watson Conversation is IBM’s chatbot service. Its intuitive interface allows chatbot creators to build their chatbot and have it ready to deploy in short time. You can sign up for a free IBM Cloud Lite account to get started.

Building your chatbot won’t be covered in this article but we have a great Chatbot course that guides you through this process and doesn’t require any coding expertise.



How do I add a chatbot to my website?

This is where the Watson Conversation WordPress plugin saves you time and money. If you have a website built using WordPress, deploying your chatbot to your website takes about 5 minutes and no code at all (as opposed to having to build your own application just to deploy a chatbot on the web.)

You can install it like any other WordPress plugin from your Admin page, that is, the first page you see after signing in.



Just search for Watson Conversation in the “Add New” section of the Plugins page and click “Install Now”.

Now you can find a page for “Watson” in your Settings. This is where you’ll find all the settings and customization to do with the plugin. When you first open it, you’ll see several tabs along the top.

For now, the only one you have to worry about is “Main Setup”.



You can find the credentials for the three required fields on the Deploy page of your Watson Conversation workspace.



Now just click save changes and you’re done. Browse your website and see your chatbot in action!

If you’re not quite satisfied with the appearance, you can customize this in the “Appearance” tab of the settings page.

You can also choose which pages to display the chat box on from the “Behaviour” tab. However, that’s not all you can do.

If you want to make the options clear to the user, you can create predefined responses to the chatbot messages for the users to select. The VOIP feature can connect users to your phone line over the internet from directly within the plugin.

In this brief article, we focused on how to deploy Watson Conversation chatbots to WordPress. Stay tuned for future articles on how to customize and use these exciting advanced features!

The post Deploy Watson Conversation Chatbots to WordPress appeared first on Cognitive Class.

DB2Night Replays

The DB2Night Show #Z83: Copy Smarter - Unload/Load, DSN1COPY and beyond

Presented by: Kai Stroh UBS Hainer "The DB2Night Show #Z83: Copy Smarter - Unload/Load, DSN1COPY and beyond" Replays available in WMV and M4V formats! 96% of our studio audience learned something!Kai described the requirements and issues of copying Db2 data between environments. Watch the replay...

(Read more)

Adam Gartenberg

Upcoming Change in Connections Metrics

For those of you who use the metrics function in Connections, we published a tech note today regarding an upcoming change that you should be aware of. (The formal announcement on this change should...

(Read more)

January 10, 2018

Dave Beulke

Five Data Management Predictions for 2018

Happy New Year! I hope everyone has their 2018 filled with good health, happiness and prosperity. Once again I am offering you my data management predictions for 2018. Thank you all for great support in 2017 and countless emails regarding my conference, user group presentations and blogs last...

(Read more)

January 09, 2018


Converting from 6- to 10-byte RBA/LRSN

Db2 11 introduced an option to convert the log relative byte address (RBA) and data sharing log record sequence number (LRSN) from the basic 6-byte format to the extended 10-byte format. Timm Zimmermann of the IBM Db2 for z/OS development "swat team" has a great presentation that goes into the details on the different formats. More importantly, Timm lays out the dwindling time that customers have left to convert their old 6-byte addresses and numbers to the soon-to-be standard 10-byte format.

January 08, 2018

Henrik Loeser

DeDUG-Treffen in Karlsruhe bei Fiducia GAD (Db2 User Group Meeting)

Db2 User Group Happy New Year! I hope you had a great start into 2018. How about meeting in person soon? I am going to speak next week at the German Db2 User Group (DeDUG) meeting in Karlsruhe. It...

(Read more)

January 04, 2018

Kim May

2018 New Year’s Resolutions – Let’s Get Started!

As always the holidays are over too soon.  Here at The Fillmore Group we are back to work, starting the year with the usual goal setting and head scratching.  Three initiatives we worked on in 2017...

(Read more)

January 03, 2018


IBM Z Trial Program

Mainframe customers running z/OS know all too well the amount of the work that comes with a proof-of-concept. The process requires months of planning among system programmers, security and storage administrators and end users.

January 02, 2018

Data and Technology

Data Technology Today in 2017

Here we are in the first week of 2018 so it is time, once again, to look at what happened this past year in the blog. First of all, there were 16 new blog posts this year so I averaged …...

(Read more)

Subscribe by email



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.