Solved

Moving DB from AIX to Windows Error

Posted on 2004-04-15
2
348 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

690 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