Prev: ASUTIME?
Next: DB2 v9 Q Capture failure
From: Sue on 25 Apr 2007 16:04
I just installed the free DB2 Express. I am going through the wizard
and I am unable to create a database. I keep getting the error "create
database path does not exist". The log file says "An attempt is made
to create a database on a path without first enabling this feature
using db2_create_db_on_path registry variable. Please enable this
first and try again. When I tried to set this to yes, I get another
error message "no database connection exists".

Help please, I've tried everything and nothing works. I have used DB2
UDB Workgroup edition before and did not have any such problems.

Thank you very much.

From: Serge Rielau on 25 Apr 2007 23:49
Sue wrote:
> I just installed the free DB2 Express. I am going through the wizard
> and I am unable to create a database. I keep getting the error "create
> database path does not exist". The log file says "An attempt is made
> to create a database on a path without first enabling this feature
> using db2_create_db_on_path registry variable. Please enable this
> first and try again. When I tried to set this to yes, I get another
> error message "no database connection exists".
>
> Help please, I've tried everything and nothing works. I have used DB2
> UDB Workgroup edition before and did not have any such problems.
>
> Thank you very much.
>
Does any of this help?

---------------
DB2_CREATE_DB_ON_PATH

* Operating system: Windows
* Default=null, Values: YES, or NO
* Set this registry variable to YES to enable support for the
use of a path (as well as a drive) as a database path. The setting of
DB2_CREATE_DB_ON_PATH is checked when a database is created, when the
database manager configuration parameter DFTDBPATH is set, and when a
database is restored. The fully qualified database path can be up to 215
characters in length.

If DB2_CREATE_DB_ON_PATH is not set (or is set to NO) and you
specify a path for the database path when creating or restoring a
database, error SQL1052N is returned.

If DB2_CREATE_DB_ON_PATH is not set (or is set to NO) and you
update the DFTDBPATH database manager configuration parameter, error
SQL5136N is returned.
CAUTION:
If path support is used to create new databases, applications
written prior to Version 9.1 using the db2DbDirGetNextEntry() API or an
older version of it, might not work correctly. Please refer to
http://www.ibm.com/software/data/db2/udb/support/ for details on various
scenarios and the proper course of action.



--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
 | 
Pages: 1
Prev: ASUTIME?
Next: DB2 v9 Q Capture failure