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.