DB2 V7.x 32-bit on AIX.
The DB2 Version 7 SQL-Reference states
that the PCTFREE attribute on a table
is only respected by REORG and LOAD.

DB2 7.2.  I do an export each night of important tables.
Nothing else should be touching the DB at this time.
About every 2 days I get the error below on the same tables
most of the time.

Sorry to bug you with what is a simple question but if you could point me in
the right direction I can follow up.
I have a sql table field we can call  XXX it is the least significant of a
four field primary key (aaa bbb ccc).

Stack trace below.
Only happens in WebSphere 6.0.
DB2 v 8.2. FP12.
Only against 1 database. I have other databases in this database

I'm not sure if anyone can help with this issue I have, but I would
appreciate any thoughts.
We are running DB2 8.2, fp11 on windows 2003. The goal is to backup to
an external EMC SAN which uses CIFS. Is this possible?

I have an IT manager that thinks he knows everything when it comes to
database design.  Unfortunately, he's not familiar with relational
databases but thinks he knows it all.  He's come up with a really crazy
design, and I've got to come up with all the reasons it's not right.  I

It's a dream of human beings to build machines that can think and
behave like human beings.  The most important part of of such a machine
is an artificial mind that can emulate the cognitive processing of
human mind.

While accessing unicode data, I get a bug check thrown:
com.ibm.db2.jcc.a.SqlException
       at com.ibm.db2.jcc.a.s.a(s.java:1521)
       at com.ibm.db2.jcc.a.s.n(s.java:532)

Hiya.
I'm running DB28.2 on a X86_64 SuSE machine, and when I try to login on
the database as the instance user, I get the next entry in db2diag:
2006-10-02-10.17.15.746251+120 I1246607E262       LEVEL: Severe

I am trying to install DB2 connect V 8.2 on my new Windows XP PC, a
Dell Optiplex GX620 with 4GB of RAM.  I have installed this version of
DB2 connect on other Windows XP PC's without any problem.
I get to the Set user information for the DB2 Administration Servedr

Hello NG,
I'm quite new to using DB-2 and I wonder, if there's a tool to display/print the table structure graphically.
I seach the printed docs but I couldn't find anything.
Background: I have to take over a DB-2 project in quite a short time and I would like to have a quick ...

I was trying to benchmark a slow performing query and realized that
almost 83 seconds is being spent on prepare and only 0.001 sec is being
spent on execute. Dynamic package cache was flushed between each run
and I tried it for all optimization levels. for this i used a stmtheap

I'm trying to sort an alphanumerical column as EBCDIC.
Reading on Internet I've found two things:
a) Use CAST(column as CHAR(nn) CCSID EBCDIC).
This gives me the following error:

Why wouldn't the "WITH UR" SQL construct work in a UDF?
Is the expectation to set it from the calling SQL?

We have to load and store datas in format XML in a Database DB2 V8.1
FP13, instance 64 bits with DataPartitionned Feature,  around  3 Tb of
datas stored in the DB ( 6 Generations of 500 Gb ).  Platform is an AIX
5.3.0 64 bits.