I am testing disaster recovery of DB2.
I have made a database backup file called "TEST.0.DB2.NODE0000.CATN0000.20061203233311.001".
This file has been transfered to another server. There I have started the DB2 control center > Create Database from File...
At 2. Available Images I selected File System. Then I would like to select my backup file but it is not shown in the select dialog (???). When I manually enter "c:\TEST.0.DB2.NODE0000.CATN0000.20061203233311.001" I can continue and the source is added to the source window. Now I can select time and date. These values are not read from the backup file (???). When I manually enter values I can continue. But after pressing finish I get the error:
SQL2036N The path for the file or device
"C:\TEST.0.DB2.NODE0000.CATN0000.20061204164738.001" is not
Is it really that these tools are disfunctional and inconvenient - or I am doing something terribly wrong here?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
5 replies Latest Post - 2013-01-22T14:27:43Z by SystemAdmin
Pinned topic restore quirks
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-22T14:27:43Z at 2013-01-22T14:27:43Z by SystemAdmin
Harz 060000MHXH37 PostsACCEPTED ANSWER
Re: restore quirks2006-12-04T18:13:37Z in response to HarzThis one I found out for myself:
PATH means just the directory not the FILEPATH. So the file has to be placed into an directory like DB2BACKUP. With the given db name, directory and date the restore is completed successfully.
Things like that confuse me. I remember another place in the installation where I was asked for the database path where actually the drive was meant...
ocgstyles 060000N6VY472 PostsACCEPTED ANSWER
Re: restore quirks2006-12-04T19:38:14Z in response to HarzThat is correct. You only need to refer to the path to the backup file.
The TAKEN AT modifier of the restore command tells which to use (if you had more than one backup file in the directory).
The database path is different for different platforms. For AIX/Linux, it is a path (/home/db2admin), and for Windows, its a drive (C:)
Re: restore quirks2007-05-01T21:52:36Z in response to HarzAfter days of pulling my hair out with the same problem I ran into a statement in the IBM restore command definition which says for Windows do not specified the IBM generated data in the path. Just the drive and high level directories are accepted. For me it was E:\DB2Backups