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

The 2016 IDUG DB2 North American Tech Conference – May 23 – 26, Austin, TX.

“It ‘s a very exciting time” — The Matrix (1999) 00:47:48

Indeed it is! The biggest conference on DB2 is right around the corner. Less than a week to be precise.

This years conference is special to me because this not only my 3rd consecutive IDUG but also my first time as an IDUG core member in Conference Planning Committee. As a core member of CPC, I participated in conference’s agenda being built, saw rooms being assigned to sessions, voted on abstracts, stayed in touch with all the speakers in my track (DB2 LUW Track – II) to get their draft and final copies uploaded and lots of other activities. I am eager to see the effort of so many people come to fruition. I now have lot of appreciation to what goes behind the scenes of a great conference with utmost quality to happen without minimum hiccups.

I am also eager to meet my DB2 friends and learn from the best DB2 minds in the industry. If you have not attended IDUG before or not sure if you want to attend this time, I would highly encourage you consider to attend this one.

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