Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Posts
    58

    Unanswered: HELP! I urgently need to get db2move to work on AIX

    I have been routinely copying a database from AIX to WIN2000
    using db2look and db2move (after much pain, but it works ok now.)

    I now urgently need to move the data from the WIN2000 to AIX
    and db2move is not working as below:

    Connecting to database MSTRDATK ... successful! Server: DB2 Common Server V7.2.5


    *** Table "MSTRDATA"."COUNTERS": ERROR -3025. Check message file tab1.msg!
    *** SQLCODE: -3025 - SQLSTATE: PEy
    *** SQL3025N A parameter specifying a filename or path is not valid.

    Disconnecting from database ... successful!

    The same data loads back into the PC no problems. With db2look,
    it would ONLY work from a WIN2000 CLP window, but this workaround
    did not work for db2move.

    Here are the contents of db2move.lst:

    !"MSTRDATA"."COUNTERS"!tab1.ixf!tab1.msg!

    Since I am in the correct directory, I am specifing no filenames or paths
    so I don't understand the error message.


    Thanks in advance,
    Wayne

  2. #2
    Join Date
    Mar 2006
    Posts
    1
    Hi All,

    I am getting the same error on AIX but can't find any solution for this problem excpet restoring the full backup of the system !

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    db2move

    anyhow something to syntax related error
    try to imort an individual ixf file with db2 import from xxx of ixf create into ..
    and see.. check the db2move control file and each imort file.. the error is related to filepath...
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Wayne,

    Please post the command you are running and what is in the msg file.

    I just did quick export/import and no problems.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Aug 2003
    Posts
    58
    Everything is working ok for me now. Not sure how I solved the problem as it was over 2 years ago.

  6. #6
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by wayneb64
    Everything is working ok for me now. Not sure how I solved the problem as it was over 2 years ago.
    Just now I looked at the date of your post.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •