We have developed an application which was running under DB2 v7.2.5
quite well for some years. Four weeks ago we installed DB2 v8.1.5
Express Fixpak 5 on a new Server (hardware is nearly the same as on the
DB2 v7.2.5 machine). The new Server runs on Windows 2003. Last week we

Bonjour,
J'ai un problème avec une colonne type IDENTITY; pouvez certainement
m'aider.
J'ai 2 tables identiques dans des environnements différents avec une

how can I get the number of data sets with a specific value for a whole
table? I want to have a statement that gives me a result set where each
data set tells me the value and the count of the value to do the
following in one statement.

I have gone through the archives and found some info but I would like
to get more opinions.
I will insert 3-4 gigs of data in a table with appx 60 columns. My
source is other tables on the same database. There are about 10 source

Can anyone say is Db2 7.2 (client and server) compatible with Windows 2000?

I wrote the following statement:
SELECT CASE
WHEN (SELECT count(*) FROM employee where empno='000010')>0 THEN
'true'

WRITE(YES) externalizes buffers to disk.  WRITE(NO)does not.  My
question: why externalize to disk WRITE(YES) when WRITE(NO) will do
the job when recovering to the quiesce point?  Thanks!

Read this about the Universal JDBC Driver....
"In a Type 2 mode, the Universal JDBC driver provides local
application performance gains (because it avoids using TCP/IP protocol
to communicate to the DB2 server). "

Our db2diag.log is full of messages like this:
2004-05-31-17.15.10.383766   Instance:tminst1   Node:000
PID:394948(db2agent (TMDB1) 0)   TID:1   Appid:GA140956.EF26.03A4B1202647
data management  sqldEscalateLocks Probe:3   Database:TMDB1

   What is the current fixpack level for the DB2 beta?
Where are fixpacks?
I have the beta from early April.
I've searched the DB2 tech support site downloads, developer forum, and

i want to use sql query to open a resultset, say i want the cursor
point to whatever position i start with by giving a row number , so is
there anyway i can use the sql function  to do that, so when the
resultset return, the first row will be the absolute row dertermine by

when i create a field FOR BIT DATA, UDB where write this information ?
I have server win 7.2
thank.

Does any body have solution for performing bitwise on db2 such that I
can call it from function or stored proc

We had some data which had low cardinality (86) , the count for that
table is 9 million rows.
How to optimize query which involve joining this table on that column?
I'm not sure if dynamic bitmap Index Anding  would help ....but how to

How do I know whether the 'runtime client' and the 'application
development client' are installed on my machine? When I issue the
command "db2licm -l", it gives the following output:
Product Name                  = "DB2 Personal Edition"