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...)

Ah! Thanks, that did the trick.

Any ideas how I can get the ControlCenter in English?

Regards
Thomas

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

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

Sincerely,
Mark B.
Hmm, changing my Windows configuration just to get a different language for a single program is not an option.