W dream

Posted on Sunday, 30th August 2009 by Balazs

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 is needed by package ImageMagick-perl-6.2.8.0-4.el5_1.1.x86_64

or
httpd-2.2.3-22.el5.centos.2.x86_64 from updates has depsolving problems
–> Missing Dependency: /usr/share/magic.mime is needed by package [...]

Tags: CentOS, yum
Posted in Linux | Comments (Comments)

Posted on Monday, 24th August 2009 by Balazs

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 Oracle PL/SQL code, that capability opens up a world of possibilities, and at the same [...]

Tags: DB2, DB2 9.7, IBM, Java, UDF
Posted in DB2 | Comments (Comments)

Posted on Monday, 24th August 2009 by Balazs

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 within hours after optimizations.
Of course in the case of a database like DB2, there are [...]

Tags: AIX 6.1, FC, Fiber Channel, IBM, SAN
Posted in AIX, DB2 | Comments (Comments)

Posted on Sunday, 23rd August 2009 by Balazs

“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

Posted in Business | Comments (Comments)

Posted on Saturday, 22nd August 2009 by Balazs

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 writing a simple software. Before he knows it, the manager is sucked into the [...]

Tags: software development
Posted in Technology | Comments (Comments)

Posted on Friday, 7th August 2009 by Balazs

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 it buried under half a ton of postcards, baby pictures, stuffed animals, [...]

Posted in Technology | Comments (Comments)

Posted on Wednesday, 5th August 2009 by Balazs

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 demo from TEDGlobal 2009.” Listen to the talk: http://www.ted.com/talks/michael_pritchard_invents_a_water_filter.html

Tags: TED, Water
Posted in Business, Technology | Comments (Comments)

Posted on Wednesday, 5th August 2009 by Balazs

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 the focus on predictive analysis. IBM clearly shows a preference for solutions [...]

Tags: Analytics, DB2, IBM, SAS, SPSS
Posted in DB2, Technology | Comments (Comments)

Posted on Wednesday, 5th August 2009 by Balazs

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 version. Loading the new license is quite simple:

Download the license file from [...]

Posted in DB2 | Comments (Comments)

Posted on Monday, 3rd August 2009 by Balazs

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 and a “customer_archive_cua” table with at least two fields. It is a good idea [...]

Tags: PL/PGSQL, PostgreSQL, SQL, Trigger
Posted in DB2, Technology | Comments (Comments)