Can you try an explicit export of one of the problem tables to see what happens? e.g. you could try:
db2 export to tab1.ixf of del lobs to /db2/backup/db2move_20071114/lobdata_move lobfile lobs1, lobs2 modified by lobsinfile select * from TXDSD2.PARTYCERTIFICATEIDS
----- Original Message -----
From: "Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT "
To: "LazyDBA Discussion"
Subject: RE: Problem with db2move and VARCHAR columns
Date: Wed, 14 Nov 2007 12:59:20 -0000
Alex:
I have deleted the whole directory and it simply repeats the same
messages for EACH table :-P
AT least this time specifying the lobpath it has given me all 365 tables
instead of 111.
The definition of these problem columns is LONG VARCHAR :-s
Thorsten:
No I am only trying the EXPORT for now, I have not even got near the
LOAD or IMPORT phase
Ed:
I am going to forward this to the vendor and let them see if the data
really is truncated - they insist it always is but I have a feeling they
stop at looking at the messages...
I'll obviously keep y'all posted.
Thanks all, fingers crossed.
-----Original Message-----
From: Alex Levy
[mailto:db2udbdba-ezmlmshield-x9300870.[Email address protected]
Sent: 14 November 2007 13:53
To: LazyDBA Discussion
Subject: RE: Problem with db2move and VARCHAR columns
I see these messages repeat (i.e. are appended at each run). Does the
timestamp on the message file correspond to your last run of db2move,
i.e.
are we quite sure these messages are not historic? Would you try
deleting the message files and retrying?
If this fails, what are the column definitions of ARITHOPVALUEX and
LOGICALOPTEXTX?
-----Original Message-----
From: Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT
[mailto:db2udbdba-ezmlmshield-x74659279.[Email address protected]
Sent: 14 November 2007 12:37
To: LazyDBA Discussion
Subject: RE: Problem with db2move and VARCHAR columns
Nope I'm afraid nothing quite so harmless.
The message from one of them reads:
$ more tab342.msg
SQL3104N The Export utility is beginning to export data to file
"tab342.ixf".
SQL3132W The character data in column "ARITHOPVALUEX" will be truncated
to size "255".
SQL3132W The character data in column "LOGICALOPTEXTX" will be
truncated to size "255".
SQL3105N The Export utility has finished exporting "15" rows.
SQL3104N The Export utility is beginning to export data to file
"tab342.ixf".
SQL3132W The character data in column "ARITHOPVALUEX" will be truncated
to size "255".
SQL3132W The character data in column "LOGICALOPTEXTX" will be
truncated to size "255".
SQL3105N The Export utility has finished exporting "15" rows.
tab342.msg: END
-----Original Message-----
From: Alex Levy
[mailto:db2udbdba-ezmlmshield-x63814532.[Email address protected]
Sent: 14 November 2007 13:32
To: LazyDBA Discussion
Subject: RE: Problem with db2move and VARCHAR columns
OK, and what are the warnings in the message files tab2.msg and
tab5.msg?
My guess is they're harmless sql3100w messages.
-----Original Message-----
From: Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT
[mailto:db2udbdba-ezmlmshield-x21818007.[Email address protected]
Sent: 14 November 2007 12:21
To: LazyDBA Discussion
Subject: RE: Problem with db2move and VARCHAR columns
Hi Alex,
I'll take your word for loving AIX, meantime, this does NOT seem to
change things - have a look at the output I get:
$ db2move EDIDCE07 export -l /db2/backup/db2move_20071114/lobdata_move
***** DB2MOVE *****
Action: EXPORT
Start time: Wed Nov 14 12:19:09 2007
Connecting to database EDIDCE07 ... successful! Server: DB2 Common
Server
V8.2.7
EXPORT: 28 rows from table "TXDSD2 "."PARSEEDIACTIONS"
*** Table "TXDSD2 "."PARTIES": ERROR 3107. Check message file
tab2.msg!
*** SQL Warning! SQLCODE is 3107
*** SQL3107W There is at least one warning message in the message
file.
EXPORT: 66 rows from table "TXDSD2 "."PARTYBUSINESSPROTOCOLS"
EXPORT: 0 rows from table "TXDSD2 "."PARTYCATEGORIES"
*** Table "TXDSD2 "."PARTYCERTIFICATEIDS": ERROR 3107. Check message
file tab5.msg!
*** SQL Warning! SQLCODE is 3107
*** SQL3107W There is at least one warning message in the message
file.
And so on and so forth.
Boo.
Any other ideas or suggestions please?
Thanks.
Aurora
-----Original Message-----
From: Alex Levy
[mailto:db2udbdba-ezmlmshield-x94895898.[Email address protected]
Sent: 14 November 2007 13:13
To: LazyDBA Discussion
Subject: RE: Problem with db2move and VARCHAR columns
Hello Aurora
Well we feel your pain! But you're just going to love UDB.
It looks like the issue here is that you have LONG VARCHARs that are
getting truncated. All long data, not just LOBs, needs to be exported to
a LOB file.
(And remember this makes your life easier too, as there is a display
length limit on a *NIX line).
Please try db2move dbname export -l lobpath and advise how you get on.
You can specify a comma separated list of lobpaths if you prefer.
I'm sorry, I never use db2move as it's a bit old fashioned, but hope the
above will work for you.
Regards
Alex Levy
-----Original Message-----
From: Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT
[mailto:db2udbdba-ezmlmshield-x21442060.[Email address protected]
Sent: 14 November 2007 11:17
To: LazyDBA Discussion
Subject: RE: Problem with db2move and VARCHAR columns
Hi Ed,
DB21085I Instance "db2insd8" uses "32" bits and DB2 code release
"SQL08027"
with level identifier "03080106".
Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and
FixPak "14".
Thanks.
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