473,398 Members | 2,343 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

Suse Linux 64-bit ppc describe table issue

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.

Dec 6 '05 #1
0 1243

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Simon Eisenmann | last post by:
Hi, during building Plone2 rpms for SuSE linux i was forced to create python 2.3.3 rpms for this linux distribution. As this may be useful for ppl outside the zope community as well i post this...
5
by: michael | last post by:
Hi. I am reasonably experienced with Python (and love it!) on Windows. I am a programmer that toils in c++ on Win 32 mostly but just to learn more, I am playing with Suse 9. Linux. Of course...
2
by: dba_db2 at nospam gmx.net | last post by:
Looking at http://www-306.ibm.com/software/data/db2/linux/validate/ it told us that db2 v8.1 is not validated yet for suse90 professional ed. Do you have any experience regarding the stability...
3
by: Killer | last post by:
Hello. I am fairly new to linux so bare with me. I am trying to install Db2 for Workgroups 7.1 on a Suse Linux 9. I am logged as root (well, su root) and I am calling db2setup (residing on...
1
by: gassara | last post by:
salut ; Nous sommes un groupe d'etudiant de l'INSAT de la Tunisie.Notre filiere est Génie Logiciel, nous réalisons un Mini projet concernant la configuration et l'administration de DB2 (V...
7
by: Mauricio Tavares | last post by:
I just installed db2 8.1 workgroup server edition in a suse enterprise 9 linux box. The window in the end of the install tell me to run db2fs as a normal user. I do it: raubtest@db2:~>db2fs...
1
by: global | last post by:
We are going to have UDB-DB on Linux, with a 20 GB database, and have no experiences on this platform Which is the optimal - file system for the database - data, logs, indexes on different...
2
by: Gellert, Andre | last post by:
Hi everybody, currenty we use Suse Linux 9 and the rpms with 7.4.0 downloaded from ftp://ftp.gmd.de/mirrors2/suse/ftp.suse.com/people/max/postgresql-7.4/ . I don't know how to contact the person...
2
by: SmoothJazz | last post by:
Hi All! I am wanting to setup/run PostgreSQL on my server (a SuSE Linux 9.2 distro) but I'm not quite sure which way to go. I have a few books on PostgreSQL but they don't seem to match the...
2
by: Lev Elbert | last post by:
Hi, all! I have to make a custom email module, based on the standard one. The custom module has to be able to work with extremely large mails (1GB +), having memory "footprint" much smaller....
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.