Honored to be #1 in DB2Night Show’s top 20 DB2 LUW Shows

It’s been a while that I blogged on db2talk. We recently had an exciting addition to our family in the form of a baby girl. As a dutiful dad, I was busy changing diapers, feeding her and bonding with her. đŸ™‚

Scott Hayes’, the founder of DBI Software and the host of DB2Night Show recently tweeted top 20 DB2 LUW shows on DB2Night Show. After re-tweeting his tweet, I looked at who were in the top 20. It was a pleasant surprise!

I was #1. whooo.hooo.. I want to take a moment and thank Scott Hayes for hosting a platform to share my DB2 knowledge and for DB2 DBAs all around the world for tuning into this show and for downloading replays. I am honored and humbled to be among DB2 stars like Scott Hayes, Ember Crooks, Matt Huras, Iqbal Goralwalla, Melanie Stopfer, John Hornibrook and many others.

Here is the link to the actual article on DBI Software’s site.


Here is a screenshot from the above link. It  contains link to each episode for top 20 shows between Sept 2015 and Oct 2016. If you haven’t listened to these shows, check them out. They are definitely worth your time.

If you would like to check out the show that I presented, here is the link:





DB2 LUW Database Object’s owner and Instance Owner’s authority over it

Here is an interesting challenge I faced recently. I was going to replace (rebuild) a view with new DDL and I got error code SQL0551N which meant I didn’t have authorization to do so. How could this happen? I was using instance owner’s user id (db2inst1) which meant I should be able to drop and/or re-create database objects.. right?

Continue reading

How to bring tablespace state to offline

I learned something interesting recently and I wanted to share in this blog post.

Recently, I was working with our enterprise monitoring team to setup monitoring/alerting for distributed DB2 databases. One of the alerts we wanted to setup was when a tablespace state is OFFLINE.
In this blog post, I will share how to bring a tablespace’s state to offline. Please know that doing so will put all the tables in such tablespace in inaccessible state. This could result in an outage situation. I have only used this approach for testing monitoring setup. You are cautioned from using this. Continue reading

DB2 LUW Truncate, Restore and Rollforward

Starting in DB2 LUW version 9, TRUNCATE is supported. This gave ability to quickly get rid of massive amounts of data from tables without worrying about possibility of filling up logs. But, one question that seems to linger around in the minds of many DB2 LUW DBAs is “Is TRUNCATE operation recoverable?” I set out to find this out myself recently. This blog post details such findings.

Continue reading