If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > HELP! I urgently need to get db2move to work on AIX

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-27-03, 18:53
wayneb64 wayneb64 is offline
Registered User
 
Join Date: Aug 2003
Posts: 58
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
Reply With Quote
  #2 (permalink)  
Old 03-04-06, 12:38
yazid yazid is offline
Registered User
 
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 !
Reply With Quote
  #3 (permalink)  
Old 03-05-06, 03:08
przytula przytula is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 03-06-06, 09:19
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
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.1.0.2 os 5.3.0.0
Reply With Quote
  #5 (permalink)  
Old 03-06-06, 10:01
wayneb64 wayneb64 is offline
Registered User
 
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.
Reply With Quote
  #6 (permalink)  
Old 03-06-06, 11:03
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
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.1.0.2 os 5.3.0.0
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On