Articles & Content

db2talk

db2talk is a blog by Pavan Kristipati which he started to share ideas/concepts/challenges in the DB2 LUW world that he has either worked on or is currently work on.

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG and should not be construed as reflecting official positions of the IBM Corporation. .

 

 
Honored to be #1 in DB2Night Show’s top 20 DB2 LUW ShowsIt'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 Database Object’s owner and Instance Owner’s authority over itHere 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 r…
Using awk to format output from select statement in DB2 on AIX/LinuxIn this blog post, I will share with you a simple way but effective way to format the output from a select statement at the command prompt. Consider a table that that has 3 columns, all of varchar data type. $ db2 "describe table db2inst1.test" Data type ColumnColumn name schema Data type name Len…
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 C…
How to bring tablespace state to offlineI 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 …
Calculating size of table in a DPF databaseStarting from DB2 versions 9.5 and up, a rich and detailed DB2 administrative view called SYSIBMADM.ADMINTABINFO comes bundled with DB2 engine. Among many things, it provides a handy way to calculate table size. In this blog post, we will look at how to calculate table size in a DPF database. Table…
DB2 LUW Import from /dev/null, Restore and RollforwardIn an earlier blog post, we looked at recovering data after 'TRUNCATE' operation. In this blog post, we will look at recovering data after using 'import' command to quickly get rid of data. Import command could be used to empty a table. The trick is to use an empty file and then use 'replace' optio…
DB2 LUW Truncate, Restore and RollforwardStarting 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 recoverab…
2015’s Highlights and Happy New Year 2016!I hope everyone has had a great start to the 2016 year!  I wanted to take a moment to express my gratitude for being a db2talk visitor and reader. Just a couple of 2015's db2talk highlights that I would like to share: In 2015, the number of views and unique visitors on db2talk almost quadrupled com…
DB2 Sample Database – Modifying storage pathIn an earlier blog post, we looked at how to create a sample database in DB2 LUW. We also looked at changing the defaults to suit our needs...changed the default database name from SAMPLE to whatever we wanted and also changed the database path (DBPATH). Here is the link to that blog post: https://…