One of my customer having warehouse database running on DB2. Recently
when they execute the following query at db2 command line
the exepected result take ages before return result
select count(*) from dss.fncsvcar where ar_id no in (select ar_id from

i can't find either confirmation or contradiction in the docs
available.  a colleague asserts that a column defined TIMESTAMP
is always and automatically updated when any column in the row
is changed; no triggers or application code needed.  is he

Can someone tell me how to perform exception handling in DB2 UDFs(not
procedures).
ALso, while usin the SIGNAL statement in one of my UDFs I encountered
an error message which is as below

a quick question.
I haven't used DB2 on mainframe since 1995 so my memory is fading a
bit. But I seem to recall DB2/MVS having the ability to perform
unlogged deletes.

Is there a way to find out in a data sharing environment in which member one
is executing ?

Wondering if anyone has made use of this feature?
The manuals don't seem to be very clear on it but it appears that if
you have a connection already created to one instance on that
particular server, you can discover the remaining instances on that

I have an application that uses IBM DB2 Universal Data Base Version 8.2
to update DB2 tables on a RS/6000 platform.
I would like to change it to update DB2 tables on an IBM Mainframe
using DB2 Connect.

I have run an statement event monitor and am digging through the data
it produced.  Some of the rows in the stmt table have me perplexed.
These records have a stmt_text that is blank with a stmt_type of 1.  I
understand that this means it is a static SQL statement and I can use

If you are a minority at IBM check your credit cards carefully, IBM human
resources may be stealing from you.  I found $370 of charges on my card, it
was done by human resources and it took me 5 months to get it back

I am primarily an Informix DBA. In recent years I am also working with SQL
Server. In fact
more with SS than Informix. Now I may get a chance to work on DB2 in Linux.
Right now we are deciding between SQL Server and DB2. Informix is out.

I am trying to find a nice way to compare objects (tables, colums,
indexes, primary and fk) between my production and my test dabatase.
I would like to known if their are tricks or tools available to help me
with this besides starting to compare systems tables contents?

I wrote a stored procedure that contains some COMMIT logic, but keep
runnign into an odd problem. As soon as the procedure gets to the
COMMIT statement, the CURSOR closes. Here's the procedure:
CREATE PROCEDURE AIM.UPDATEARCHIVERETRIEVALSTATUS ( )

All:
We are evaluating for possible migration and  I would like to invite
comments on what are the reasons for Migrating database from Sybase to
DB2.

Can someone tell me how to perform exception handling in db2 UDFs
(not procedures) I am using db2 version 8.2 on windows xp platform.
Also , can I use SIGNAL statement in UDFs?.
I tried to use a exit handler code in my UDF as below

Hi Serge,
I have a question on your exciting recent article on High Perf. SQL: why do
we have to describe datatype for include columns in an INSERT .... INCLUDE
... statement - in your example, the columns come from the DATA CTE, so