I have been able to do a remote db2move COPY of a DB from a remote Linux server to a local instance on OS X Leopard. I am trying to do the reverse. It successfully creates the schema (the tables and views are there), but fails to move the data over. I get the following for every table:
171 Schema : <schemaname>.<tablename>
Type : TABLE
Error Msg : LOAD operation problem
DDL : SQLCODE = -1013 SQLSTATE = 42705 TOKENS = <local_dbname>
Clearly it's finding the DB in order to create the schema, but that set of SQLCODE/SQLSTATE is apparently it telling me that, "The database alias name or database name <local_dbname> could not be found."
Any ideas? Is this just not supported on the Mac version?
(As an aside... I've searched but not found any answers to the oft-asked question of if/when a 9.7 version for the Mac might be released. Any thoughts there?)
Pinned topic db2move COPY from local OS X 9.5 beta to remote Linux 9.7
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-08-12T16:44:32Z at 2009-08-12T16:44:32Z by SystemAdmin
Z-Company 270000T7WA310 Posts
Re: db2move COPY from local OS X 9.5 beta to remote Linux 9.72009-08-12T16:18:19ZThis is the accepted answer. This is the accepted answer.You need to run db2move at target server. Also check if you have databases catalogued correctly: db2 list database directory
SystemAdmin 110000D4XK5837 Posts
Re: db2move COPY from local OS X 9.5 beta to remote Linux 9.72009-08-12T16:44:32ZThis is the accepted answer. This is the accepted answer.
- Z-Company 270000T7WA
Does someone here know the reasoning behind this behavior or is it considered bug or missing feature? I ask in part to understand whether we should expect this to ever work in the other direction.
manojrobi 270004W2921 Post
Re: db2move COPY from local OS X 9.5 beta to remote Linux 9.72014-04-29T07:28:10ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
did you get the solution to this problem ? I am hitting this issue while moving my data to a remote server ?