This topic has been locked.
2 replies Latest Post - 2012-03-15T21:27:56Z by nivanov1
Pinned topic IDMT to move data from DB2 LUW on windows server to AIX
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I'm trying to use IBM Data Movement Tool to move tables from a 9.7 instance on a windows server to a 9.7 instance on an AIX server. I get an error in the unload saying that the table is missing but the table does exist. I've tried a couple different tables but get the error each time. I verified the server, port, ID and password are all correct. I also cataloged the windows database on the unix server and I'm able to connect to the windows database from the unix instance.
Updated on 2012-03-15T21:27:56Z at 2012-03-15T21:27:56Z by nivanov1
SystemAdmin 110000D4XK708 PostsACCEPTED ANSWER
Re: IDMT to move data from DB2 LUW on windows server to AIX2012-03-14T16:02:12Z in response to JoanieCan you please post the detailed message from the log?
This is most probably the permission issue.
db2 connect to <db> on aix as instance user
db2 grant dbadm on database to user <username who is using the tool>