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.

Advertisements

One thought on “DB2 on Ubuntu: “Database is damaged” error

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s