Blog

New DDL comparison tool on DB2 UDB LUW

Today’s Blog is about one of the ACE DBA’s products. The first one is ACECOMPDDL, which compares the DDL of two databases, schemas and objects on db2 udb LUW databases. I remember why I had to create this utility , at a client’s place I had Q replication set up
more
1 comment

These tennis shots make me win my match in just two sets (1.5 hours)

Good Bye DB2’s got Talent
So march 15 th was my last presentation as I was in bottom three and Judges chose Ember Crook. Good Luck Ember , I would like you to win DB2’ Got Talent contest. I am almost going to miss my DB2’s got talent’s presentations preparation. But I think I did make some good friends. Thanks Scott Hayes , Susan Visser, Martin Hubel and Klass Brant , they always liked my presentations.
The topic of my presentation was “ These tennis shots make me win my match in just two sets (1.5 hours)” . In this I compared my SQL’s which I always carry to my first day of every consulting job . I am attaching a pdf of the presentation here.
All these SQL’s are tested by me and they work pretty good on Linux and windows. Please test them and if they don’t work get back to me.
Tip of the Week : Always make sure that your user and system temporary tables are distributed over file system or disks for better performance.
Here is the link for my presentation