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.


January 23, 2017

DB2 Guys

IBM Informix Roadshow – Is your city on the list?

by Becky Hanenkrat, NA Database and BigData Software Sales Your job is to know more about Informix than your boss. So it’s time to hit the road and heighten your abilities at the 2017 Informix Roadshow! We’re featuring a half-day with deep dive sessions presented by experts in the field. You’ll also have the chance […]

DB2 Guys

Make fun of your work at Informix Users Group Conference 2017

by Rajesh Govindan- Portfolio Marketing Manager, IBM Informix                 We’re delighted to announce that John Cohn, esteemed IBM engineer, inventor and author will be the keynote speaker at the International Informix Users Group conference. John is not only an innovator immersed in initiatives for IBM’s Watson Internet of […]

January 21, 2017

DB2Night Replays

The DB2Night Show #Z75: SQL Tuning in the Digital World

Presented by: Sheryl Larsen Sr. DB2 Product – Specialist, BMC Software "The DB2Night Show Z75: SQL Tuning in the Digital World" Replays available in WMV and M4V formats! 94% of our studio audience learned something!Sheryl looked at the data and transaction flood can be further affected by bad SQL and access paths. Watch the replay...

(Read more)

January 20, 2017

DB2 Guys

Tech Talks – DB2 for Linux, UNIX and Windows

by Sajan Kuttappa, Content Marketing Manager IBM DB2 for Linux, UNIX and Windows database software is the foundation that powers many IBM Analytics offerings. In conjunction with the International DB2 Users Group (IDUG®), the DB2 product team hosts a series of monthly webinars highlighting key capabilities, use scenarios, and various aspects of data management needs. […]

January 19, 2017

Jack Vamvas

Restore a DB2 LUW database without a DB2 backup copy from filesystem backup

Question: A developer corrupted some data and requested a restore to a previous recovery point. A standard request. When checking the backup system , there were no backup copies available. The backups had been failing for the last couple of nights and the monitoring alerts were not working.

I checked around the backup history file , in case any ad-hoc backups had completed, and there none available. As a last resort I checked if there had been a flat file backup , and amazingly there was a flat file backup of all the files on the server. This is unusual as normally DB2 files are excluded on flatfile backups.

Is it possible to recover the database just with the flat files?

Answer: Yes it is possible, but careful planning is required. Before you proceed with this procedure , you must confirm the flat  files are recoverable and include all the files you need.These are the steps I would take

  1. Stop any application connections to the database
  2. Take a full OFFLINE backup of the db
  3. Take a copy of the get db cfg output , for reference
  4. Identify the folders required to be replaced. This is an important step.This will heavily depend on how the database was set up. I normally create a separate folder for the data files and log files.
  5. If you are unsure of step 4 – do some research or speak to another DBA , who can cross-check what folder you’re proposing to overwrite
  6. Stop the DB2 instance – making sure there are no auto starts or processes which will auto start the DB2 instance. It may also be necessary to notify any Operations teams to avoid alerts for this DB2 instance, just in case they attempt to restart
  7. Restore the files, it will be an overwrite of existing files.
  8. Before you restart the DB2 instance – you may be in luck and know the last active log file of the db you’re restoring. This will allow you to clean up any transaction log files which are from after this restore i.e related to the database you’re overwriting
  9. If you don’t have the last active log file number of the db you’re recovering, you could start the DB2 instance , quickly do a db2 get db cfg and obtain the information 
  10. You could check for the first active log and calculate the last active log
  11. Do a connection test

January 18, 2017

Henrik Loeser

Bluemix: Simplified Deployment of Complex Cloud Foundry Apps

Two apps from single manifest Recently, I was looking over a microservice-based app to be deployed to IBM Bluemix. There app consisted of several pieces, the app itself and multiple services....

(Read more)

Henrik Loeser

Context Path Routing of Apps and Services in Bluemix

Context Paths for Bluemix Apps As I mentioned in my post yesterday about simplified deployment of complex apps, I have been working on a sample for Context Path Routing to be used with IBM Bluemix....

(Read more)

January 17, 2017

Data and Technology

Data Technology Today’s 2016 Year in Review

Well, another year has come and gone and I thought it might be interesting to share a bit about this blog’s activity in 2016. It was an active year that saw 17 new posts, down a bit from 2015,...

(Read more)
Big Data University

This Week in Data Science (January 17, 2017)

Here are some stories from this week in Data Science and Big Data. Don’t forget to subscribe if you find this useful!IBM Watson Health

Interesting Data Science Articles and News

Cool Data Science Videos


DB2 12 for z/OS Technical Overview

I don't need to tell you that a career working with DB2 for z/OS is never boring. DB2 for z/OS continues to evolve at an ever-increasing pace. To help you keep up with all these changes, IBM has delivered a new Redbook, "DB2 12 for z/OS Technical Overview."

January 13, 2017

Frank Fillmore

It was 30 years ago today… The Fillmore Group “Founder’s Day” @ffillmorejr @KimMayTFG #IBMAnalytics #IBMz

On Tuesday, January 13, 1987 I sat in the kitchen of my 11 foot wide rowhouse in the Highlandtown section of Baltimore and typed out on a manual typewriter the Articles of Incorporation for The...

(Read more)

DB2Night Replays

The DB2Night Show #188: DB2 LUW Predictive Index Impact Analysis

@srhayes :: @db2performance Special Guest: Scott Hayes, DBI Software Sage DB2 LUW Performance Advice Predictive Index Impact Analysis - Know Before you Create! 100% of our audience learned something! Sage Advice Part 3 - Predictive Index Impact Analysis - Know Before you Create - extends the performance tuning journey that began with Parts 1 and 2. Don't worry if you missed Parts 1 and 2 because they are briefly reviewed during this...

(Read more)

January 11, 2017


January 10, 2017

Henrik Loeser

DB2 Quiz for the Resource-Minded & IDUG EMEA 2017

Did you know...? I hope you had a good start into 2017. I am already up and running and accomplished some important tasks. I submitted my presentation proposals for the IDUG DB2 Tech Conference 2017...

(Read more)
Big Data University

This Week in Data Science (January 10, 2017)

Hello all! My name is Janice Darling and I will be taking over this column from Cora.
Here is a roundup of the news this week in Data Science and Big Data. IBM Watson Power7

Don’t forget to subscribe to keep up-to-date with developments in Big Data and Data Science!

Interesting Data Science Articles and News

Cool Data Science Videos

The post This Week in Data Science (January 10, 2017) appeared first on Big Data University.


DB2 for z/OS Native RESTful Services in DB2 11 & 12

I’ve previously written about RESTful services, noting how these services will enable data and applications running on DB2 for z/OS to become a strategic component of your enterprise API strategy.

January 09, 2017

Craig Mullins

The Tao of DB2 - Part 15: Putting it all together!

We rejoin our soon-to-be-retiring DBA and the intern who is tasked with replacing him as the old DBA continues to teach the young intern about Tao and DB2. "Soon, I will be retiring, and all of this will be yours," said the expert DBA. "Are you ready?" "I am trying my best," said the intern. "Do you have any more advice for me before you go?" "Ahhh... you are wise to ask. Let me again reach...

(Read more)

January 06, 2017

DB2 Guys

Network with peers at the Informix Users Group Conference 2017

by Rajesh Govindan, Portfolio Marketing Manager – Informix When we asked David Link from Nebraska what he liked most about the Informix Users Group Conference in 2016, he told us that networking was high on his list. “I had an excellent time,” he said, “The content was great, the people were great, the […]
Jack Vamvas

Methods to find TSAMP error details and return codes

Question: How can I find details about TSAMP (Tivoli System Automation for Multiplatforms) failover details? I discovered that a failover occurred and need, what sources will give me details?

I have a TSA single storage solution in place

Answer: There are multiple methods to extract details about a failover details. If you troubleshooting , it may be necessary to correlate details from different sources.

These sources of information are a good starting point for diagnostics.


Linux error logs on /var/logs/messages

          tail -f /var/log/messages

Db2diag log files

Instance_name.nfy file


Read More on TSAMP

TSAMP Cheat Sheet for DBA managing DB2 clustering (DBA DB2)

How to customise TSAMP start and stop scripts to make monitoring ...

How to put TSAMP into maintenance mode (DBA DB2)




January 03, 2017

Kim May

IBM DB2 Analytics Accelerator (IDAA) *Free* Hands-On Training Class

DB2 Gold Consultant and IBM Champion Frank C. Fillmore, Jr. will deliver a *free*, hands-on IDAA training class in Baltimore on Monday and Tuesday, February 27th and 28th.  IBM System z customers...

(Read more)


Comparing DB2 12 Function Levels M100 and M500

I was recently reading the DB2 12 for z/OS What’s New guide. It's interesting comparing the features available in the initial Function Level M100 with what you can get when you activate Function Level M500.

January 02, 2017

Jack Vamvas

Database Self-Tuning

To get my head back into gear and focused for the New Year , I want to outline some notes on the topic of Database Self Tuning. Database Tuning is all about ensuring service level agreements being met . Database tuning is essential as data sets get bigger with increasing a larger set of access paths to the data.

Following on from my blog post – The future of the SQL Server Performance Tuning Expert , I’ve compiled some notes on Database Self Tuning

Focus is on two aspects

1) What is the current state of Database Self Tuning?

2) How to achieve full automation in the future.

Database Tuning Definition – The sum of all activites completed to make the Database respond within satisfactory levels

Database Tuning focuses on:

1) Throughput

2) Response Time

3) Resource Usage

Example, set some constraint e.g memory (Resource Usage) and improve response time (throughput)

What Database Server components can be tuned?

An example Performance Stack.

CPU Cores

Windows\Linux OS

Database Server



Fibre Channel Switch

Storage Controller

Storage Controller Cache



Database Tuning requires in depth expertise on:

1) Application

2) OS

3) Hardware



Basic principles of Database Tuning  (Shasha)

1) Think globally, fix locally – Track down bottlecnck and resolve

2) Partitioning breaks bottlecnecks – if step 1 doesn’t fix problem , divide the load over more resources or spread the load over time

3) Try to keep things up and running , avoid restarts

4) Render onto server , what is due onto server. Keep the balance between application and DBMS

Read more on the five basic principles Five Basic Principles according to Shasha

Database Tuning – continuous

1) Identify existing Problem

2) Monitor and define cause (root) of problem

3) Apply changes to problem

4) Problem Solved

5) Repeat


Database Tuner needs to manage trade-offs – between benefits and cost.

Hardware Tuning – Kill it with Iron – ROI


Read More

Performance Tuning series – Performance Stack

RAID levels overview

SQL Server – tempdb and solid state drives

Database Tuning for complex sql queries (DBA DB2)



Data and Technology

A Good Start for Your SQL Library

Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But you can’t buy them all...

(Read more)

December 30, 2016


December 27, 2016

Big Data University

This Week in Data Science (December 27, 2016)

Here’s this week’s news in Data Science and Big Data.

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

The post This Week in Data Science (December 27, 2016) appeared first on Big Data University.


December 22, 2016

Craig Mullins

Happy Holidays 2016

It is that time of year again. When we all take some time to pause and spend time with our family, friends and loved ones. We take time off of work to celebrate and reflect on the past year... and to welcome the new year. No matter what holiday tradition you celebrate, I wish you an enjoyable holiday season. Happy holidays, that is! And we'll meet back here again in January 2017 to talk more...

(Read more)

December 21, 2016

Dave Beulke

Black Friday Lessons

In the last blog (found here), I talked about the first five of the top 10 ways that can help make your systems bulletproof for holiday processing for reliability, availability, and scalability demands. This week I continue with reliability, availability, and scalability topics from my technology...

(Read more)
Big Data University

This Week in Data Science (December 20, 2016)

Here’s this week’s news in Data Science and Big Data.

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

The post This Week in Data Science (December 20, 2016) appeared first on Big Data University.


December 20, 2016


Deprecated Functions: A Primer

When IBM decides to remove a function from DB2 for z/OS (or any DB2 offering), it's generally publicized in in the DB2 for z/OS announcement letter. See the DB2 12 for z/OS announcement letter, for instance.

December 16, 2016

Henrik Loeser

New Mod Pack and Fix Pack for DB2 V11 available now

New DB2 Fix Pack and Mod Pack available Over the past years I blogged about new fixpacks and features in DB2. This is the first time I have to mention "Mod Packs" because for DB2 V11 a new Mod Pack...

(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.