DBMSguy.com

One of the things I find very powerful in my day to day work as a DBA, is the use of inline shell/awk scripts.  I use this technique when I need to do the same thing to many objects.  I often use it when I want something quick and dirty or create a base script [...]

I’ve always been a little frustrated with db2 when running scripts and command lines with fact that when a command would run like insert, update or delete, you never knew how many rows you affected.  Some GUI products will tell you, but with command line it would just come back as being successful (or not) and it [...]

Have you ever had a situation where you needed to select rows from a table for a specific month?   This example demonstrates how to retrieve all of the records belonging to the previous month by setting the first and last days in the WHERE clause of a SELECT statement.   But with some tweaking, you can [...]

This is the last post about HADR, I think I covered most of the basics of HADR finishing off with how it switches primary and standby.  What I have gone over is the basics of HADR.  There are many other topics within HADR.  One important thing to remember is to NEVER do unlogged operations (careful [...]

Okay, so here we go …. setting up an hadr environment….  HADR in it’s lowest form is very straight forward to set up.  Here are the steps to start HADR

HADR is a very easy and effective way to maintain a DR and/or standby for any given database.  You can implement it very quickly and simply and it works well.  In essence it is basically log shipping, but done in real time and elegantly.  It is not replication, so the standby database is not really [...]

Hi folks, I was cruising around the www and found a couple of interesting sites that I thought I would pass on …

Some time ago, we upgraded our DB2 from version 7 to 8.2. One of the first things we noticed was that connection times from our client were very long – in the area of about 15 to 20 seconds just to connect to an active database.