When I try and restore the database I get the following result:
D:\dbData\backup>db2 restore database MSTRLOCL from D:\dbData\backup taken at 20030902230000
SQL2542N No match for a database image file was found based on the source
database alias "MSTRLOCL" and timestamp "20030902230000" provided.
Here are the contents of the directory
Volume in drive D is D_DRIVE
Volume Serial Number is BD48-19C5
Originally posted by mcdb2
Is it because of the code page differences?
I think the problem is the byte order for the numbers in memory(low byte to high vs high byte to low). Intel is different from the hardware used by most *nix. The thing I do not understand is why Linux(Intel) backup is not compatible with the Windows. Our development would be much easier if they were compatible.
The DB2MOVE DBNAME EXPORT works fine, but the
DB2MOVE DBNAME IMPORT was a bit tricky. I needed
to create an empty DB first, and fix the authories by hand,
and then fix the privleges by hand afterword. Not sure
how to reload the data into an existing DB. Using
DB2MOVE DBNAME LOAD may be the answer, but I am
not convinced it will delete extra rows to make the DB's match.
Kinda painful compared with BACKUP/RESTORE I had been using
between two AIX machines.