doyoudb2

DB2 UDB for LUW (Linux, Unix and Windows)

 
  • Increase font size
  • Default font size
  • Decrease font size
DB2 LUW - Tips and Tricks

Manage your db2 diagnostic data

PDF
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.
Read more...
 

Put tabs on your Putty - Putty Connection Manager

PDF
User Rating: / 2
PoorBest 

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

PDF
User Rating: / 4
PoorBest 

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:

Read more...
 

db2 on Mac OS

PDF
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

PDF
User Rating: / 1
PoorBest 
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:

Read more...
 

db2-express C on Ubuntu

PDF

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.

Read more...
 

db2top on Windows environments

PDF

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.

Read more...
 

Largest non-partition db2 database?

PDF

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.  
Read more...
 

Open Secret to achieve DB2 V9 advanced certification

PDF
User Rating: / 1
PoorBest 

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?"
 
Read more...
 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  5 
  •  6 
  •  Next 
  •  End 
  • »


Page 1 of 6

Search Site

Subscribe

Enter your email address to receive new posts directly in your Inbox:

Relax! We hate SPAM as much as you do.

Sign In/Register

Syndicate Feeds - Subscribe


Add to Google

Add to Google

Advertisements

Got a DB2 Tip/Trick?

Have a useful tip/trick on DB2 for LUW to share with the db2 community? Write to us at CONTENT at DOYOUDB2.com

DB2 Forum - Latest Posts

Re:DB2 9.5 for Linux (Ubuntu - Hardy Heron) 2008/12/29 22:20 by db2admin
What just happened to me 2008/12/19 03:42 by dr_te_z
Any phpmyadmin like interface for db2-express-C 2008/12/15 10:43 by zero
Re:Am I being too inflexible? 2008/12/15 10:39 by zero
Re:Am I being too inflexible? 2008/12/11 23:53 by dr_te_z

DB2 Poll

What is the largest non-partitioned DB2 database you have worked on?