i am using db2 v9.7, i am trying to restore my db on a path.
my command is
RESTORE DATABASE TESTDB FROM 'C:\Program Files\Templates' TAKEN AT 20120203085913 DBPATH ON 'C:\Documents and Settings\All Users\' INTO TESTDB WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
i have created the database on the same path which i am trying to restore.
But, after executing restore command, i am able to see "DB2_01" folder in C:\ drive and also in my application path....
what could be problem with this restore command... ?
check also the syntax in doc
path : is for creating the ts containers if automatic storage is being used
dbpath : is for the config files used by db2 for this db
you can specify both
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be