Topic
  • 3 replies
  • Latest Post - ‏2014-04-29T07:28:10Z by manojrobi
SystemAdmin
SystemAdmin
5837 Posts

Pinned topic db2move COPY from local OS X 9.5 beta to remote Linux 9.7

‏2009-08-06T22:24:09Z |
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?)
Thanks,
Mike
Updated on 2009-08-12T16:44:32Z at 2009-08-12T16:44:32Z by SystemAdmin
  • Z-Company
    Z-Company
    310 Posts

    Re: db2move COPY from local OS X 9.5 beta to remote Linux 9.7

    ‏2009-08-12T16:18:19Z  
    You need to run db2move at target server. Also check if you have databases catalogued correctly: db2 list database directory
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: db2move COPY from local OS X 9.5 beta to remote Linux 9.7

    ‏2009-08-12T16:44:32Z  
    • Z-Company
    • ‏2009-08-12T16:18:19Z
    You need to run db2move at target server. Also check if you have databases catalogued correctly: db2 list database directory
    You are saying that db2move only works when run from the command line of the target? That is... disappointing. The issue for me is that I am NAT'ed behind a firewall separate from the remote server. I was able to fairly easily open a tunnel to the remote. Opening one in the opposite direction will be more interesting.

    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.
    ~Mike
  • manojrobi
    manojrobi
    1 Post

    Re: db2move COPY from local OS X 9.5 beta to remote Linux 9.7

    ‏2014-04-29T07:28:10Z  
    You are saying that db2move only works when run from the command line of the target? That is... disappointing. The issue for me is that I am NAT'ed behind a firewall separate from the remote server. I was able to fairly easily open a tunnel to the remote. Opening one in the opposite direction will be more interesting.

    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.
    ~Mike

    Hello,

     

    did you get the solution to this problem ? I am hitting this issue while moving my data to a remote server ?

     

    Thanks

    Manoj