[DB2 UDB LUW 8.2.4] I've got bookings per day in a table:
bkgdate   bookings   company
1/1/06      50            A
2/1/06      45            A

Well known, during "CREATE TABLE" we could optionally specify "COMPRESS SYSTEM DEFAULT" and "VALUE COMPRESSION" options. The main idea about these statements is : NOT to keep on disk the values that can be deduced from some means, isn't it ?
The small investigation ( on DB2/LINUX ...

Recently I became interested, - Are the data, bulk loaded in the table with
LOAD utility, consume the same disk space as loaded with IMPORT utility? The
answer turned out to be NOT !
Here is a nutshell description of the test. The testing was done at

I'm wondering if anyone has had this issue in a  Windows 2000 Server
enviroment.
"The DB2 - DB2 service terminated unexpectedly. It has done this one
time(s)."

I'm trying to call the snapshot table function SNAP_GET_TBSP via a jdbc
connection using the following query:
SELECT * FROM TABLE(SNAP_GET_TBSP(CAST(NULL AS VARCHAR(1), -1)) AS T
In CLP this works properly, but when I execute it from java, I get the

On ESE **DPF** Aix 5L ML06, it seems that since I have applied FP12 +
special build, I get this specific command not work and generate errors in
db2diag.log (the command output is generated very very slowly, so that
db2diag.log fills up quickly, and takes more than 1 hour - I ...

In the table XYZ.ORD_DTL the column PDT_DESC is CHAR(35). I want to
increase it to CHAR(100). However, I am getting the following error.
Please help!
db2 => alter table XYZ.ORD_DTL alter column PDT_DESC SET DATA TYPE

Recently I was engaged in the database optimization for one big commercial application. During this business I was greatly astound by the fact that it's impossible in DB2 to get the accurate size of a table. Indeed, the disk space occupied by a table is composed from three parts:

I created a refresh deferred MQT, and during full refresh there were 4
or 5 lock waits, all waiting on a 'S' lock on Internal Catalog Cache ?
Can some one explain how to prevent this from happening?

Is it possible to store Java objects in DB2 V8.2 for Windows/Unix/Linux via
JDBC?
Specifically, if I have a 4-dimensional boolean array, i.e. boolean[][][][],
can I store it directly in a column of a DB2 table? If so, how do I do it?

I am trying to set an env. variable by exporting in unix environment on
DB2.
I am  using export var_name=ON, but it is not taking the value of the
var_name.

Must admit, I am new to DB2:
Seems I can not issue command REORG TABLESPACE:
Commands Entered:
REORG TABLESPACE SBO_DB.TS_SBO_SAFE;

   I have a remote DB2 database on AIX and I am accessing ti using a
windows client .i was using control center on windows to add the remote
system under it and I gave all the node names and pressed discover and
it gives me the following error:

Is it possible do to something like this:
DROP TABLE MY_TABLE ONLY IF EXISTS
and the same for views, indexes, procedures, .... ?
Best regards,

I am using DMS raw.  I have a tablespace which is defined with 5
containers each allocated at 1.5 GB for a total of about 7.5 GB.  I did
a major deletion followed by a reorg and a runstats.  I am not
regaining as much space as anticipated.  Additionally, the