i have two questions:
1. A query plan only shows estimated cost and size at each operator.
is it possible to show the actual cost/cardinality of each plan
operator after running the query?

We have been testing a few sql statements and noticed that using an
inequality, for example:
where recdate > '08/25/2008'
has much poorer performance than

I'm trying to write an SQL statement that provides a list of insurance/
product groups and then lists a total and percentage on the same line
e.g.
XX     5     4     80%

Could someone please tell me whether DB2 supports hash functions such
as MD5sum and SHA-1 or checksums like CRC-32. I would like to know
whether the DB2 database would have a function like SQL server and
Oracle have that takes an input of a certain length and computes a

Is the java type 3 driver definitely dead in DB2 V9.1 and V9.5?
I have an application here without source, so I can't change it easily
(asking the supplier will take a long time). Does that mean I can't
run it? Or did someone find a workaround? At least, I still have the

I need to create 101 columns table and populate it with following information:
RN,C1,C2,C3,C4,C5..........................................C100  
0     1   0    0   0   0.............................................. 0
1     0   1    0   0   0......................................... ...

Hi, all.
I need to enforce a one-to-many relationship on 2 tables, with a join
table.
Say the join table contains account information. It has cust_no and

I am writing a SELECT statement which calculates the average quantity for
last 3 weeks for each week in year 2008 for each productid:
WITH TEMP(Week, ProductID, Quantity) AS
(VALUES(200752, 1, 130),

my database has column defined as GENERATED ALWAYS:
   TXT_VERMITTLERNR        VARCHAR(10)     NOT NULL GENERATED ALWAYS AS
(RTRIM(CAST(ID_VERMITTLER AS CHAR(10))))
ID_VERMITTLER is:

Folks
Just a quick question.  How many of you out there are on 9.5 UDB with
DPF.  If you are on DPF what version of UDB did you transition from to
get to 9.5.  Thanks.

The db2 diag log shows the last log file archived was S0011941.LOG.
cat db2diag.log| grep -i archived
MESSAGE : Successfully archived log file S0011938.LOG to USEREXIT from
MESSAGE : Successfully archived log file S0011939.LOG to USEREXIT from

I have a composite index on two columns in a table.  However, the
index is not used in a query that restricts the 2nd column to a
constant.  If both columns are linked with columns in other join
tables, the index will be used.

I wrote a trigger for the follwing requirement:
In a given table T with columns A,B,C are up to 5 entries allowed for a given
combination
of (A,B).

My Problem:
------------------
1- When I was trying to run some queries like below, I got the error
like this:

We have started planning our DB2 generation 8 -> 9.1/9.5 upgrades, as
April 30 2009 is no longer distant future (ordinary support for DB2
generation 8 on Linux/Unix/Windows==LUW will end on April 30).
We are unsure if it's safe to move directly to version 9.5, or if we