We use DB2UDB Express FP6 on SuSE Linux Enterprise Server and we are
suffering from "Out of memory errors" since we have upgraded from FP5.
Connection is made through jdbc Type 4.
There are no errors in db2diag.log so it seems to be a jdbc issue.

Is there anyway to display the partition number while taking snapshot
on all the partitions (-2) using the snapshot function?
ex,
select TABLESPACE_NAME, TOTAL_PAGES from table(SNAPSHOT_TBS_CFG ( ' ',

Hiya,
I've been getting some deadlocking that I've never seen before. I
rewrote just over 10,000 lines of code, so I can't really go back and
comment out what I've done. In a nutshell, could my deadlock be

Anyone had any problems w/v8.1 FP7 w/a change in date format in timestamps
w/in snapshots?
Pre FP7 had a format of:    09-30-2004 10:53:18.642349
FP7 has a format of:            09/30/2004 10:53:53.149448

If I want to create a table with a triggter to retrive data fast in DB2
database, how can I do that?
I know in informix we have serial as a data type. what is the equivalent in
DB2? what is the sql syntax of defining a column as the serial equivalent in

I wanted to drop a table with a lot of data in it (about 1.9 GB). I
thought it would be a good idea to delete the data first. So I issued a
"delete from <table>" command - which took, not very surprisingly, a
long time. After a while, when I thought the table should be empty (I

I'm trying to set up replication between DB2 and SQL Server and hvae
discovered something odd: the driver (library) required by DB2 to
replicate between DB2 and SQL Server (db2mssql3.dll) is missing!!! It
doesn't exist anywhere on my Windows box.

The documentation is unclear (at least to me) on the permissibility of
accessing DB2 (8.1.5) concurrently on and from Windows 2000 / XP / 2003,
with separate transactions scope, from separate threads of a multithreaded
program using embedded SQL. Since the threads do not need to ...

I have several user defined functions which get called from triggers.
Is it possible to install a new version of the functions without
having to drop and recreate the triggers?  When I try to recreate the
function (by DROPping and CREATEing), I get the error

Query:
update table1 t1
set end_time = (
   select end_time

Hello, all.
Does anyone know if IBMJava2-SDK-1.4.2-0.0 work with DB2 8.2?
I tried it with DB2 8.2 and got some error. This server is a RH3ES
with kernel 2.4.21.4

Can you use a the load or import command in a stored procedure???  I
tried to LOAD FROM blah blah...within a stored procedure but i get a
error that was not expecting the worD LOAD! Any ideas???  TIA!
i.e

I am using the DB2 GUI to delete all entries of a table (delete from
table). The table has app. 900 enties and the removeal takes "forever".
The table gets lock (so no select is possible) and I can not cancel the
command.

How to resolve and log a database problem?
For instance I have the following "Lock" situation:
- if I connect to a db2 instance (e.g. database1)
"db2 connect to database1 user dbadmin using xxxx"

is there in a QMF forms the ability to show in a report columnn
the value of different data columns depending on the value of a
certain data column?
tia