Solved

Moving DB from AIX to Windows Error

Posted on 2004-04-15
2
335 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

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 (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This video discusses moving either the default database or any database to a new volume.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

762 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