SEO

#1 (**permalink**) 02-26-2008, 03:59 PM

Hi,

One of our customers has DB2 7.0 (no FixPack installed) on Linux, user
"db2inst1". They exported their data using db2move. We are now trying to
import the data on our Windows 2003 server with DB2 7.0 FixPack 3 installed,
user "db2admin". I opened the "db2move.lst" file and changed the references
of "db2inst1" to "db2admin" and then tried to import the data using db2move.
An error message was displayed: SQL3089N. The error message mentions a
problem with the "D-Satz" (sorry, it's in german) in the ixf file.

Could it be that there is a problem with the character sets used on Linux
and Windows which affects the import? Databases we create on Windows use the
swiss character set, while this option is not available on Linux, so here we
used the standard character set.

Regards

Rudolf Bargholz

#2 (**permalink**) 02-26-2008, 04:03 PM

"Rudolf Bargholz" <bargholz@spamcop.net> wrote in message news:<1068116833.368106@fuchs.cyberlink.ch>...
> Hi,
>
> One of our customers has DB2 7.0 (no FixPack installed) on Linux, user
> "db2inst1". They exported their data using db2move. We are now trying to
> import the data on our Windows 2003 server with DB2 7.0 FixPack 3 installed,
> user "db2admin". I opened the "db2move.lst" file and changed the references
> of "db2inst1" to "db2admin" and then tried to import the data using db2move.
> An error message was displayed: SQL3089N. The error message mentions a
> problem with the "D-Satz" (sorry, it's in german) in the ixf file.
>
> Could it be that there is a problem with the character sets used on Linux
> and Windows which affects the import? Databases we create on Windows use the
> swiss character set, while this option is not available on Linux, so here we
> used the standard character set.
>
> Regards
>
> Rudolf Bargholz

HI,

I suggest to apply latest fixpack.

My environment is V7.2+fixpack9.

I only met this problem when I loaded lob data. They ask me to
increase one parameter. appl_ctrl_heap size.

Hope some help for you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode