off to bad start, DB2_CREATE_DB_ON_PATH error in db2diag.log file

[Database Administrator]

After reading about the new XML support in DB2, I decided to give it a try as it really looks like it could solve some problems.

I downloaded the DB2 Express-C for windows, tried to create a database thru Control Center, and it kept complaining that the directory I specify for the DB is invalid.

Hunting thru the db2diag.log file, I find this error saying:

An attempt is made to create a database on path without first enabling this feature using DB2_CREATE_DB_ON_PATH registry variable. Please enable it first, then retry again.

Amazingly, the string is not on google anywhere ! and is not in the DB2 docs anywhere, and is not in my registry anywhere.

Anyone have any ideas ????

-- Thanks, Andrew




============ whole error from log file
2006-08-01-16.11.15.421000-300 I13299H684 LEVEL: Warning
PID : 3992 TID : 3380 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-13 APPID: *LOCAL.DB2.060801211115
FUNCTION: DB2 UDB, base sys utilities, sqlecrea_agent, probe:150
MESSAGE : ZRC=0x870F0011=-2029060079=SQLO_PATH "an invalid path"
DIA8514C An invalid file path, "", was specified.
DATA #1 : String, 14 bytes
C:\db2\xmltest
DATA #2 : String, 173 bytes
An attempt is made to create a database on path without first enabling this feature using DB2_CREATE_DB_ON_PATH registry variable. Please enable it first, then retry again.

2006-08-01-16.11.15.531000-300 I13985H213 LEVEL: Error
PID : 1944 TID : 3428
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : Sint32, 4 bytes
-1052

[Database Administrator]

The parameter appears to allow you to create a databases under a path (on Windows) rather than at the root on a drive

Prior to V9 your create database statement on windows would be:
CREATE databases fred on c

by setting the environment variable in V9 you can create a database under a path:
CREATE databases fred on c:\mydb

You can set the variable (from a db2 command window) and you will need to restart your db2 instance
db2set DB2_CREATE_DB_ON_PATH=ON

To view your environment variable from the db2 command window issue the following command:
db2set -all

Good Luck,
Peter Schwarcz

[calipermn]

I too had this problem and did google and ibm searches and didn't find the answer... until I found this post. Thanks for the precise answer.

FYI: I am coming from a Microsoft SQL Server background where this wasn't an issue.