db2inst1@Ladybug$ db2 create db something
SQL1034C The database is damaged. All applications processing the database
have been stopped. SQLSTATE=58031
In my last message I tried to create the sample database, using the command db2sampl. None of the solutions posted there works to me. This is even worst, because I can not create any database it all. :S
I installed DB2 Express 9.5 from the canonical repository for Ubuntu 7.10 Gutsy. During the installation process there were no problems but the problem are db2sampl does not work and db2 create database neither.
The error explanation is:
"If you are installing the sample database, drop it and install
the sample database again."
If this doesn't help uninstall DB2 product and try to install it again. I haven't installed it from repository, so I don't know deb package is corrupted.
I downloaded DB2 from web page and installed it. If you need help how to do this try my how-to for Ubuntu 7.10 Server: http://www-128.ibm.com/developerworks/forums/thread.jspa?messageID=14028783�
If you are using Ubuntu 7.10 Desktop there is link at the end of first post of another how-to I have written for desktop.
Before uninstall/install can you please look into db2diag.log file default at /home/db2inst1/sqllib/db2dump/db2diag.log path. Please delete this file and recreate the problem (create database...) and then look into this file again. There should be only messages associating your problem. Please post this file to forum.
I apreciate so much your post. I started all over again yesterday. Even I change my Kubuntu to Ubuntu 7.10 Desktop. I downloaded the DB2 Express software from this IBM site. I am doing all the steps appearing in the how to entries. It's all ok until now. I am making the post installation process. The users and instance are created. My problem appears when I try to create a database, as the db2inst1 user:
db2 CREATE DATABASE ariela AUTOMATIC STORAGE YES ON '/home/db2inst1/' DBPATH ON '/home/db2inst1'
SQL1034C The database is damaged. All applications processing the database
have been stopped. SQLSTATE=58031
This same error have been happened since the first time I installed DB2 to this last time. I don't know what to do.
A Linux expert found the problem with the create database deal. After just one hour he found the error, which was on the /home/db2inst/sqllib/db2dump/db2diag.log file:
When I tried to create the sample or any database, an error like this appears in the log file. My Ubuntu is in Spanish language, installed for Chile (the country where I live) and it seems DB2 expects the default language, english. The solution he tried (and worked) was editing the .bashrc of the db2inst1 user (in your case, the user that owns the DB2 instance) the following line:
export LC_ALL=C
After this file was modified, all the databases were created and connected without problems. I hope this kind of trouble could be easy to resolve for the DB2 users as me, that use sistems in other languages, different from the english. Thank you so much gpoo (the Linux Expert who helped me).
There are a couple of related APARs though not 100% match to your problem (IZ16595, IZ16974 --> full description can be found if you go to www.ibm.com and input any of those numbers from the "Search" field. You may have to register/sign in first).
The problem seems to occur because the database to be created is using a locale not supported by DB2. This information in the case of Windows would be taken from your Regional Settings. This link in the manuals describes how DB2 derives the locale for Linux, UNIX and Windows:
If you want to change the locale on Windows you can follow these instructinos:
===
From the Start menu, select Control Panel, then select Regional and Language Options.
Change the regional options on the Windows computer:
On the Regional Options tab, select a language and territory from the list box, such as German (Germany).
On the Languages tab, click Details and select the default input language.
Optional: Select one or both check boxes to install additional languages.
On the Advanced tab, select the language that you want to use.
Click OK. You might need to restart the system for your changes to take effect.
===
For spanish version of Windows XP you can fix the problem with the Regional Settings (as Raul posted before).
Inicio->Panel de control->Configuración regional y de idioma
then, in the 'Opciones avanzadas' section, modify the setting in the 'Idioma para programas no Unicode' combo. Use a codepage that DB2 supports (I tried 'Español (España)' and works fine).
Now, the CREATE DATABASE command should work.
Tags
Use the search field to
find all types of content in My developerWorks with that tag.
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular type of content or application that you're viewing.
My tags shows your tags for this particular type of content or application that
you're viewing.
