Problem installing DB2 Express-C (create database)

Thomas Kellerer

unread,

Nov 2, 2009, 8:57:31 AM11/2/09

to

Hi,

I have problems creating a database in DB2 Express-C after an initial installation on my Windows XP SP3 box.

When I try to create the database from the control center I get the error message:

SQL1052N Der Datenbankpfad "C:\Daten\db\db2" ist nicht
vorhanden.

(Database path does not exist)

Needless to say that the path *does* exist (I selected it using the File open dialog)

Changing DB2_CREATE_DB_ON_PATH=YES did not make any difference.

I verified that the DB2admin (OS) user has full control over that directory.

What I did:

In DB2CC I right clicked on the "All databases" node, then chose "New Database" -> "Standard", supplied a name, selected the data folder using the file open dialog (by clicking on the "..." button).

I left "Restrict access to system catalogs" unchecked
I left "Storage management by DB2" (radio button) checked (I did not select "manual storage management")

I left the default page size at 4K

In the second page of the wizard I left the checkbox checked ("Use database path as storage path") but did not add any further directories.

Then I selected UTF-8 as the encoding and clicked on "Finish" --> Error

What am I missing here?

Regards
Thomas

P.S.: I hope that I'm getting the translation correct, because the DB2 (and thus CC) installed itself in German even though I'm using an English Windows. Is there a way to convince the CC to use english as the interface language (during installation I selected English and German, should have left out the German...)

MarkB

unread,

Nov 2, 2009, 9:44:18 AM11/2/09

to

Hi Thomas,

Did you do db2stop / db2start after setting DB2_CREATE_DB_ON_PATH?

Sincerely,
Mark B.

Thomas Kellerer

unread,

Nov 2, 2009, 10:56:41 AM11/2/09

to

MarkB, 02.11.2009 15:44:

>> SQL1052N Der Datenbankpfad "C:\Daten\db\db2" ist nicht
>> vorhanden.
>>

>> Needless to say that the path *does* exist (I selected it using the File open dialog)
>>

>> P.S.: I hope that I'm getting the translation correct, because the DB2 (and thus CC) installed itself in German even though I'm using an English Windows. Is there a way to convince the CC to use english as the interface language (during installation I selected English and German, should have left out the German...)
>
> Hi Thomas,
>
> Did you do db2stop / db2start after setting DB2_CREATE_DB_ON_PATH?

Ah! Thanks, that did the trick.

Any ideas how I can get the ControlCenter in English?

Regards
Thomas

MarkB

unread,

Nov 2, 2009, 12:22:44 PM11/2/09

to

>
> Ah! Thanks, that did the trick.
>
> Any ideas how I can get the ControlCenter in English?
>
> Regards
> Thomas

Try this:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5//topic/com.ibm.db2.luw.qb.server.doc/doc/t0007278.html

Sincerely,
Mark B.

Thomas Kellerer

unread,

Nov 3, 2009, 2:57:46 AM11/3/09

to

MarkB, 02.11.2009 18:22:

Hmm, changing my Windows configuration just to get a different language for a single program is not an option.
(Because I need my regional settings the way they are)

I deleted IBM\SQLLIB\msg\de_DE and that seems to work.

Regards
Thomas