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 > db2move - Copying a table: SQL2032N The "indexing_mode" parameter is not valid

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-08-04, 11:55
globetrotcom globetrotcom is offline
Registered User
 
Join Date: Jan 2004
Posts: 23
db2move - Copying a table: SQL2032N The "indexing_mode" parameter is not valid

DB2 v7.2 on Windows 2000:

I am getting:

SQL2032N The "indexing_mode" parameter is not valid

when I invoke "db2move dbname load"

Here is what I did.
________
1. I used db2move to export a bunch of tables from two schemas in the same database.

To check the process of loading ( and also because I need to load only a subset of tables that I exported):

2. Edited the db2move.lst file to contain only one table I wanted to load.

3. I copied the edited db2move.lst and the corresponding .ixf and .msg files(tab9.ixf and tab9.msg) to a new directory

4. I deleted the contents of table I wanted to load

5. Invoked "db2move dbname load"
__________

Is it legal to do the hack process I did?

What can I do to rectify this error?

My ultimate goal is to Export and import a subset of tables with referential integrity from one database to another and different machines.

Thanks for your help
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