DB2 on Ubuntu: “Database is damaged” error

If you installed DB2 Express-C 9.5 on Ubuntu and can’t create any databases because of the following error:

SQL1034C The database is damaged. All applications processing the database
have been stopped. SQLSTATE=58031

Try adding the following to the /home/db2inst1/.bashrc file:

export LC_ALL=C

This happened to me running Ubuntu in Spanish and the above environment variable fixed the problem. I can now create and use databases.

By the way, I found this solution here.

The Story of Stuff

A friend of mine sent me a link to a very interesting video clip on consumerism. The clip is only about 20 minutes long and I highly recommend it.

Here’s a teaser:

You can view the entire video online at The Story of Stuff website.

You can also download it here or order a DVD.

And if you want to know more about the topics discussed or want to learn about things you can do to contribute they have a resources page that can help you learn more.

Why’s Shoes

So I browsing the web and I stumbled upon the shoooes.net¬†website. At first sight I didn’t know what it was, but after reading around the page it got my attention.

Shoes, a tiny toolkit, lets you create apps that can run on Windows, Mac OS X and Linux/BSD using the Ruby language. You can download the toolkit, read a tutorial and download a book by its author, all from the website.

It looks promising. And since I’m learning Ruby I think I’ll check it out. And for those of you who have played with it, I’d like to know what you think of it.

So if you’re into Ruby check it out.

Linux Open Files Limit

If you’ve ever gotten the “too many open files” error and tried to increase the open file limit for a certain user, you’ve probably seen the following solution on forums:

Edit the /etc/security/limits.conf file and add a new line to the end of the file like this:
myuser hard nofile 2048

Then you open up a new terminal session with myuser only to see that the limit hasn’t changed.

What gives?

I decided to add both hard and soft limits to the file, like this:

myuser hard nofile 2048
myuser soft nofile 2048

And that did the trick. Now every time I open a new terminal session I have a 2048 open file limit instead of the usual 1024.

I’m not sure if this is the best way to do it, though. If anybody knows a better way let me know.

So where’s the Intalio source code?

At work we are currently evaluating the Intalio Open Source BPMS. We are playing a bit with it, trying to install it on several different environments.

I had a little problem when using it with the IBM JDK, so I decided to look for the Intalio source code and apparently I’m not the only one who can’t find it:

http://www.vosibilities.com/bpel-bpm-bpmn-software/intalio-the-open-source-bpm-leader/2008/04/03/

http://www.albeesonline.com/blog/2008/05/15/intalio-open-source-bpm-suite/

So where’s the source code?