doyouDB2.com

Manage your db2 diagnostic data

Sat, 09 May 2009 00:33:12 -0600

Most DB2 Linux/Unix DBAs write custom scripts to manage the volume of diagnostic files generated by db2 in the DIAGPATH. You may have scheduled cron jobs to regularly run those scripts and play cleanup with the db2 diagnostic log files.

But, if you are a lazy dba and have not written such a script. Below is a good script you can use use to manage that db2dump directory.

Put tabs on your Putty - Putty Connection Manager

Tue, 07 Apr 2009 02:26:24 -0600

If you use putty in your daily exploits, then you may find the Putty Connection Manager to be a useful addition. Putty Connection Manager is a wrapper around the regular putty terminal, but it provides the functionality of arranging several putty windows within tabs in a single Putty Connection Manager window. Further, you can dock several dock windows left and right, up and down with finesse.

There are more useful features, like storing your login configurations in one or more encrypted connection manager databases and automatic login feature using keyboard simulation

Go get Putty Connection Manager at http://puttycm.free.fr/

Cloning DB2 databases

Thu, 12 Mar 2009 00:15:02 -0600

I started to write a note on various options available to clone a db2 database (in full or in part) but found so much information already available out there, that I thought it would be nice to just list out the options and provide links to the detailed information.

Here are some ways of cloning db2 database:

db2 on Mac OS

Wed, 24 Dec 2008 06:08:06 -0700

If you have still not read about it on one of the db2-blogs, then here is the news:

DB2 Express-C for Mac OS X Leopard is officially released and available for download.

from Joomla to Drupal

Wed, 24 Dec 2008 01:12:00 -0700

I am thinking of moving doyoudb2.com from Joomla to Drupal. When I started exploring the world of Open Source Content Management Systems, the name Joomla attracted me. Joomla has a very nice adminin user interface, but when it comes to flexibility Drupal scores high.

I have also toyed with the idea of using db2 express-C as the backend database instead of MySql. But, I think that won't be possible now for two reasons:

db2-express C on Ubuntu

Sat, 20 Dec 2008 02:00:40 -0700

If you are new to Db2 for LUW and would like to try out db2-luw but don't have access to a Unix machine where you can install db2, here is one workaround. Install Linux (Ubuntu) on your laptop/desktop and then install db2-express C. While this setup will not exactly duplicate the experience of working on db2-luw on AIX/Solaris environments, it will take your experience much closer.

db2top on Windows environments

Wed, 10 Dec 2008 23:53:56 -0700

Our user dr_te_z has shared a cool way of monitoring db2 databases/instances running on Windows environments using db2top utility. Thanks dr_te_z for sharing this wonderful tip:

My current client runs db2 on ms windows (that's their problem) but I want to monitor the databases with "db2top". So this is what I did.

Largest non-partition db2 database?

Fri, 05 Dec 2008 04:38:59 -0700

Having completed my current project, I am looking for a new consulting project these days. The most interesting and consistent thing I see in the requirements for a DB2 DBA is experience working with multi-terabytes db2 databases on LUW. Which makes me wonder, what is the size of the largest non-partitioned db2 luw database in existence? Is it 15 TB, 20 TB or more. I have never heard of any non-partitioned db2 luw database greater than 20 TB.

Open Secret to achieve DB2 V9 advanced certification

Sat, 29 Nov 2008 04:02:11 -0700

Here are tips shared by DB2 expert Ajay Jain on how to succeed in the DB9 advanced DBA certification exam. Congratulations Ajay!

I was in Las Vegas in Oct, 2007 for IBM IOD/07 and passed the DB2 UDB V8.1 advanced DBA certification. When I returned back to work, now a certified DBA, colleagues teased me - "how can you be in Vegas and study for certification?"

Multiple DB2 9 installations for SAP on Linux and Unix

Sat, 22 Nov 2008 02:53:19 -0700

Out of the many enhancements of DB2 9 for LUW, an interesting one is the ability to install multiple copies of DB2 software of the same server. Till v8 the db2 installation path was hard coded and as a result only one copy of db2 software was allowed.