We have to create a local copy of a DB2 database. The live DB2 database is running on a AIX server and we need a copy on a laptop running Windows XP. Using backup/restore is not possible since we are moving to a different OS.
We tried to use the db2move tool to copy the table data, but it’s giving lots of errors. One of the most common errors is this: “The specified table cannot be replaced because another table is depending on it”.
We’ve run the db2move allready 3 times now in order to get the parent tables in place, so the ones depending on it can be copied too, but it’s still giving all the errors.
Does someone has experience with this? Is there maybe another easy way to make a copy to a