Solved

Moving DB from AIX to Windows Error

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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

791 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