Monthly Archives: August 2009
Fixing Yum dependency problems on RedHat Linux and CentOS
Yum update fails I see the question of failed dependencies come up on forums quite a bit. Users post errors like: Missing Dependency: bind-utils = 9.3.4-10.P1.el5_3.1 is needed bind-sdb-9.3.4-10.P1.el5_3.1 or ImageMagick-perl-6.2.8.0-4.el5_1.1.x86_64 from installed has depsolving problems –> Missing Dependency: /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi … Continue reading
Creating a User Defined Function (UDF) in Java for IBM DB2 9.7
Intro One of the great features of DB2 is that it can be extended with custom code using SQL, C/C++, Java and COBOL. One of the great new features added to DB2 in 9.7 is the ability to run native … Continue reading
Fiber Channel (FC / SAN) Performance Tuning on AIX 6.1
Introduction In large data-warehousing applications, the efficiency of storage systems is critical. With the same hardware and software release, we have seen queries that never terminate (i.e. still runs after a week) under one configuration to be able to finish … Continue reading
Have a Family Owned Business?
“Defining a dynasty as three successive generations of family control and success, he focuses on banking, automobiles, and raw-materials industries, with fascinating stories of families, including the Barings, Morgans, Fords, Toyodas, Rockefellers, Guggenheims, and Schlumbergers.” — Mary Whaley Continue reading
Posted in Business Leave a comment
The Mythical Man Month
Managing Software Development Projects In today’s world, more and more managers find themselves having to manage an impromptu software project. It usually starts by a need identified by a “hobbyist” colleague, who realizes that they can solve a problem by … Continue reading
Friendly Advice from my Favorite IT Shop
Ewan Reid from Utilis sent me this. Not sure where it originated. If you find the source, let me know. Definitely great advice on handling IT support: When you call us to have your computer moved, be sure to leave … Continue reading
Posted in Technology Leave a comment
Tunring Filthy Water into Strile Drinking Water
From TED’s web site: :Too much of the world lacks access to clean drinking water. Engineer Michael Pritchard did something about it — inventing the portable Lifesaver filter, which can make the most revolting water drinkable in seconds. An amazing … Continue reading
IBM Expands in Analytics Market
Infoworld’s Pete Babb has an article about IBM to acquire analytics firm SPSS. Pete sees this acquisition by IBM in line with the earlier acquisition of Cognos also by IBM. He underlines that the key aspect of this acquisition is … Continue reading
Installing Product License for DB2
In a previous blog post I described how to upgrade to DB2 9.7. However, once the upgrade is complete, the old 9.5 license becomes invalid and a new license needs to be loaded. Preferable before you fire up the new … Continue reading
Posted in DB2 Leave a comment
Creating Delete Triggers in PostgreSQL
One of the common data integrity issues that can happen in a database is the unintended deletion of a row. Here is how to create a DELETE trigger in PostgreSQL. The example code below assumes you have a “customer_cus” table … Continue reading
 |