Hi Amr,

That is exactly what does NOT work for me.

I used the db2move <dbname> export and the VARCHAR columns give me problems (not LOBs).

Thanks.

Aurora

-----Original Message-----
From: Amr Mohamed Roushdi [mailto:[Email address protected]
Sent: 14 November 2007 12:05
To: Dell'Anno,Aurora Emanuela,BUSSIGNY,Contractor for NBS IS/IT
Subject: Re: Problem with db2move and VARCHAR columns


Why dont you try and use db2move dbname export . it will do the lob stuff for you to relaoad db2move dbname load or insert .

it works for me at least

please post if this resolve your problem

Bonne reception , Best regards, Mit freundlichen Grüssen , ????? ,

Udv?zlettel , ÃáÓ?ã Úáíßã

Amr Roushdi

--------------------------------------

From: "Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT "
To: "LazyDBA Discussion"
Date: 14-11-07 11:45
Subject: Problem with db2move and VARCHAR columns

Hi list,

please be gently explicative to me since I am rather new to this LUW stuff (I have worked on DB2 for over 10 years, but on mainframes).

Guess what, I'm lost in AIX-land.

I am trying to execute the db2move utility with the EXPORT option of a DB with 300 tables, and the problem is that the does not come out "right", a lot of tables are missing - it exported 111 tables only out of the lot, and the problem seems to be the type of the column (VARCHAR in my case).

The export.out file contains a lot of warning messages with SQL3132W , such as:

SQL3132W
The character data in column column will be truncated to size size.

Explanation:
The character data column has a defined size that is longer than the longest default character column which can be exported; each value will be truncated to the specified size.

I searched the APARs database, and found exactly sweet FA.

Anyone have any ideas or suggestions on how to overcome this? As mentioend right at the top, any suggestions would need to be almost step-by-step because this platform's intricacies are still a bit of a mystery to me.

Thanks in advance for any pain relief.

Aurora

DB2 & UDB email list listserv db2-l LazyDBA home page