Solved

Moving DB from AIX to Windows Error

Posted on 2004-04-15
2
338 Views
Last Modified: 2012-06-21
Hi,
We met following message when moving data from AIX4_3 DB2_7_1 to Windows2000Server DB2_7_1.

I did everything as described in article
http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0403melnyk/

When loading data in Windows2000Server following message is given and operation fails.

db2move ERPDB load

SQL2032N  The "indexing_mode" parameter is not valid.

Thanks in advance.
0
Comment
Question by:ilevent
2 Comments
 
LVL 50

Assisted Solution

by:Lowfatspread
Lowfatspread earned 200 total points
ID: 10840241
this link suggested that is was a problem "fixed" in a later fixpack

http://www.dbforums.com/t343609.html

however the user still didn't appear to be successful...

which fix packs do you have installed...?

you may need to be at a certainly level  to create the move files as well as apply them ? my 2c...

hth
0
 
LVL 4

Accepted Solution

by:
bondtrader earned 300 total points
ID: 10845957
If the database is fairly small (a few million rows or smaller), I prefer to do the db2move with the import option instead of the load option as it also has the ability to create the tables for you.  I don't know if it it's worth a try in your case, but it might be:

db2move ERPDB import

Don't forget to do a "reorgchk update statistics on table all" after the data move...
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
db2 connect on mac 3 522
Need help on Db2 Stored procedures 6 141
querying from Excel and using multiple statements separated by semicolon 7 92
Monitor SQL Insert 8 62
November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now