I thought that the subst command was past its prime. But it still works:
even SUBSTing subdirectories on network drives works.
And: I am sure (without even trying) that a SUBSTed drive/dir does NOT
exist anymore after a reboot.
I would, however, not include it in the autoexec.bat, but use it only
when doing a backup or restore. It is then that you need it: no more, no
less.


Rob den Heijer
AMO, Nieuwegein.


-----Original Message-----
From: Michael Studholme
[mailto:db2udbdba-ezmlmshield-x91045633.[Email address protected]
Sent: woensdag 28 september 2005 10:21
To: LazyDBA Discussion
Subject: RE: Create database in subdirectory on Windows

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