In our application we create and drop a number of tables on a JDBC
connection which is autocommit=true.  There are multiple threads
(session EJBs) doing this for different tables at the same time on
different connections.  We are having many problems with deadlocks on

Does DB2 support Windows Server 2008?
In the Information Center for 9.5 I only find mentioned Windows Server 2003
and Windows Vista.

My table defined as this:
Date                Value
--------              ----------
Jan 01, 2008   0

Forgive my newbieness. I am created 2 tables EMP_DAN table and
EMP_DAN_AUDIT. I am trying to create a trigger that anytime something
is inserted or updated on the EMP_DAN table it will record a the
change and timestamp on the AUDIT table. Here is the code i'm using

Is there way of telling the load utility that if it finds spaces in the
input file, where it expects an integer, to insert a zero?
Currently I am getting an error.
SQL3116W  The field value in row "F0-1" and column "46" is missing, but the

              Appreciate very much  if  someone  let us know which
fixpack for Unix version  8  of UDB EEE will  make it  to  version  9
and  for 9.1  &  9.5  .
Does  fixpack 14 of  version 8   equal's  version 9  ?

Is there a way to remove / clear / drop statistics for a single table?

We are conducting various tests on performance for a couple queries
and noticed some unusual results.
You will notice a sort and scan for query1 that is not in query2
related to the css_defn table.

I feel like an idiot for asking this, but neither I nor my DBA can figure
this out.
How do you create a database object that does not implicitly allow access by
any defined user?

On a server with DB2 v. 8.2, db2diag.log ran full, it seems (i.e. reached
a size of 2GB). And it seems that in this case, DB2 started using syslog
instead.
I would actually like DB2 to use syslog instead of / in addition to the

I have tables in the default table space userspace1, but userspace1
has only
a 4kb page size. So I created a second table space, userspace2 with
32kb page size

While performing a redirected restore, I found that the creation of
tablespace containers took a looong time. I DB2 expert told me to consider
the DB2_USE_FAST_PREALLOCATION registry setting. I tried turning it on,
but then my "set tablespace containers for XX using (file ...

I've a table like this:
date, value
01/01/2008, 3
01/02/2008, 4

I have a problem with following join:
First query is generating RANK
SELECT EMPNO,BONUS,(SELECT COUNT(*) + 1
             FROM EMPLOYEE

We are using DB2 server V9.5 for our migration project on HP-UX IA64
platform.
My question is:
Can we do labeling to a particular transaction?. If so how can  we do