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