This is not a “Once upon a time” story is a “One and a half year ago” story. It happened few months after I was hired by Openware (http://www.openware.biz
), the company I am working for. At this time, our principal security web-based service was powered by DB2 for Workgroups version 7.1. One day, Laura, a business associate, received an invitation to participate in a presentation on DB2 Express-C version 9.1 given by Raul Chong a database consultant at IBM who works closely with IBM's DB2 development team (http:// www.ibmpressbooks.com/authors/bio.asp?a=6ca8b21b-e3df-4691-a68a-3a9...
). We went to its presentation and we realised how much power and advantages holds the new community version of DB2, then my boss Dario decided to migrate our old DB2 database to that new version…
Actually my company hired me as I was a PHP programmer with highly skilled in MySQL database administration. I never administered a DB2 database before apart from write down some SQL sentences for my PHP code. So, one month after Raul Chong’s presentation my boss announced me that I will be on charge of the database server upgrade and data migration. What a tremendous chore for someone who never administrated a DB2 data server! It was an insane month of working starting from zero! I struggled with lots of troubles along my way, many database servers’ virtualisations were required and my loyal work mate Lisandro work out those virtualisations in a perfect and extremely coordinated teamwork. In this hard working month there were many problems that almost made us give up on the migration process, even one time we called IBM Argentina to price the whole migration service. But in the end, with a lot of studying and community help given by DB2 specialists from IBM and other companies we did it. Finally, since June 2007 our principal service is based on one of the newest versions of IBM DB2 data servers.
From that day, when our new database server got into production many things had changed and improved. I am going to make a list of them:
- Improved performance increases production on our internal users and new customer experience allow us to launch an international programme with more than 15 new customers around the world.
- No more midnight alerts and incident issue tickets by insertions problems.
- A new IBM DB2 Control Centre gives us more precise information about what is happening every moment.
- Incredible compression technology saves lot of disk space on our database server. It compressed our old DB2 database from 3.2 GB to 1.7 GB!
To sum up, I would like to mention why I am proud of being a DB2 administrator (now) and in a sort of way a DB2 hero. First of all, all improvements helped people, especially internal users to work more comfortably avoiding delays and head aches on rush hours. Plus, migration allows to my company to offer a highly reliable service for existing national customers and opened a wide horizon to gain abroad new ones.
Esteban Acosta Villafañe
Developer - R+D Department