You could try the DOS SUBST command instead of the network share
approach.

Detail at http://www.computerhope.com/substhlp.htm if you need them.

I am not sure if it is persistent across a reboot so you may need it in
the autoexec.bat.

Cheers
Mike

-----Original Message-----
From: mmcnary
[mailto:db2udbdba-ezmlmshield-x73474298.[Email address protected]
Sent: 27 September 2005 18:04
To: LazyDBA Discussion
Subject: Create database in subdirectory on Windows

I have a need to create a database using UDB 7.2 FP 4 on Windows 2000.
Rather than allowing the database to be created under the 'normal'
directory
structure, (c:\db2) I want to hang it under another subdirectory
(c:\special\db2). The create database syntax only allows for a drive
letter
for the 'ON' clause and I was wondering if there was some other way to
get
this database where I want it, short of creating a network share to the
path
I want and specifying that as my ON drive.

Thanx,

Mark McNary
NPPC MES Database support
(w) 314-982-1389
(m) 314-497-5850





---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page