What version of DB2 are you running?





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT [mailto:db2udbdba-ezmlmshield-x92558521.[Email address protected]
Sent: Wednesday, November 14, 2007 6:04 AM
To: LazyDBA Discussion
Subject: RE: Problem with db2move and VARCHAR columns

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


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

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