Hi there.
Using 8.2 on Windows.
I have a situation where I have a db backup, which I want to deploy to
a group of developer workstations.
The target directory for the database files will be consistent, but
the location that the backup file is on may vary.
I have gone through the entire backup and restore process, and it
works fine.
Where I'm running into an issue is using a relative path for the
location of the backup file.
I would like to use the following:
"db2 restore db NEWDB from %bkupdir% to c: into %dbname% redirect"
....I would then set tablespace containers, CONTINUE the restore, and
then rollforward.
Both 'bkupdir' and 'dbname' are variables which are set in a config
batch file.
I have ECHO set on, and I can see the correct path being displayed
when the restore command echos back after getting the variable names.
But I continually get the 'path for file or device... is not valid'
error message.
Are relative paths workable in this kind of situation?
....the reason I want to use relative paths is that I want to send out
the backup file in the version control software we are using. The path
that the various workstations may have checked out their source into
may vary.
There are other options, I guess - but I'd like to be able to make the
relative path work.
Thanks!!
BD.