Hi All,
Here are the facts. If I telnet to my DB server, connect to database1 and export any table, I receive warning msg for each varchar column. For example,
SQL3132W The character data in column "SUBJECT" will be truncated to size
"128".
The column is defined as varchar(128).

Also, DESCRIBE TABLE does display values under "Type name". Instead, values from "Length", "Scale" and "Nulls" (they are right to "Type nmae") are shifted to the position under "Type name".

If I connect to datanase2 in the same instance, everything is normal.

If I connect to database1 remotely, everything is normal.

I can not figure out what the problem is.
Any advice is highly appreciated. Thanks.

never seen this before : db2level ? platform ?
try to bind again : db2ubind.lst and db2cli.lst and db2schema.bnd
if v8 try also db2updv8 -d xxxx
Hope this will help

Thank you for advice. It still does the same.

DB2 level:
"DB2 v8.1.0.58", "s040914", "MI00093", and FixPak "6"

OS level:
Red Hat Enterprise Linux AS release 3 (Taroon Update 6)
Kernel 2.4.21-32.ELsmp on an i686

The only difference between database1 and database2 is the code set. database1 (with error) is using ISO8859-1, while database2 (without error) is using UTF-8. I tried to set profile variable DB2CODEPAGE=819 (corresponding to ISO8859-1), it still didn't work.