My db2 environement is as follows:
Suse Linux on powerpc, with 64-bit DB2, 8.1 fixpack 8a. Db2 is
installed on local drives, and all tablespaces/containers are on some
some network attached storage (net appliance I think it is called).
The catalog is DMS, and exists on the network attached storage. This
configuration is supported by IBM. Net Applicance is one of the
supported network attached storage devices.
now to the problem....
I have loaded tables with data and everything seems fine, but when I do
a describe table, the output is all jumbled. Example:
Column Type Type
name schema name Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- ------
SUBID 11 0 NoCHAR
RECID 4 0 NoINTE
CHAINCODE 4 0 YesARC
NUMDAYS 4 0 YesNTE
NUMROOMS 4 0 YesNTE
NUMGUESTS 4 0 YesNTE
ROOMTYPE 4 0 YesARC
RATE 8 0 YesOUB
Proper output should look like:
Column Type Type
name schema name Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- ------
SUBID SYSIBM CHARACTER 11
0 No
RECID SYSIBM INTEGER 4
0 No
CHAINCODE SYSIBM VARCHAR 4
0 Yes
NUMDAYS SYSIBM INTEGER 4
0 Yes
NUMROOMS SYSIBM INTEGER 4
0 Yes
NUMGUESTS SYSIBM INTEGER 4
0 Yes
ROOMTYPE SYSIBM VARCHAR 4
0 Yes
RATE SYSIBM DOUBLE 8
0 Yes
has anyone seen this before? I am able to query tables fine. Even the
db2look command seems to work fine. The only other issue I have
seen....which seems related to this jumbled describe table output, is
when I do an export from the table in IXF format, before it exports
data, it tells me that it is truncating each field, even though no
field is even that large.