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 "
<db2udbdba-ezmlmshield-x78652530.[Email address protected]
To:
"LazyDBA Discussion" <[Email address protected]
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.
For example, by default, only the first SQL_LONGMAX bytes of a LOB
column will be exported. If the entire LOB column is desired, the
LOBSINFILE keyword must be specified in the filetype modifier and each
LOB column will be stored into a separate file.
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