============================================================
About DB2 Administration Tools Environment
============================================================
DB2 administration tools level:

Using DB2 8.1 FP5 on Win2000
After creating and configuring a new database, we stop db2 and start it
again.  We then launch our application and the SQLExecute calls start slowly
and get progressively slower.  Our application basically looks like this:

There's something clearly missing in my understanding of recovery:
I set up  a small sample datavase and deleted all the rows from a table.
Crucially, I omitted the "commit".  I then shut down db2, and copied
everything under the db2inst1/db2inst1/NODE0000 directory to another ...

For tests purpose, I have tried to install DB2 CONNECT V8.1 on a
separate partition but on a same Windows 2000 Server as the one on
which I had already installed DB2 WSE V8.1 + Fixpack 5
After installation of DB2 Connect, DB2 WSE commands don't work anymore

Is there a special register (or any other variable/function) which will
return the cpu time my sql procedure has used? I have a fairly long but
simple procedure which reads an input table of ~20,000 rows, writes 3
tables with a combined count of < 50,000 rows with a commit every ...

I have tried to install DB2 v 8.1 on AIX 5.2L ML 2, during the initial phase
the install asks
for the location of the various components. I have pointed these to
directories on a filesystem

hi, i am using db2 udb v8.1 on windows, i create a index on a unique
value column on a table to try to create row lock, here is what i do ,
sql = select value from table where id=1 for update, the auto commit
is true. if the table has more than one row, i got row U lock, but if

we've sold a few suse and redhat solutions with ibm data management software
recently (60% margin from ibm on new licences - thanks very much ibm!).  we
thought about becoming suse partners, in solidarity with our fellow
europeans.  1600 euros (or us dollars) to join the partner ...

I have a federated database (7.2 FP11, AIX 4.3) that seems to work
fine in most aspects. Today I'm trying to add a new user mapping with
the following statement:
create user mapping for mngdrq01 server opencases options

Is it possible for a Java Stored Procedure in DB2 V7.2 (Windows) to pass a
Throwable back to the calling program as an OUT parameter?
If yes, what datatype should I use when registering the Throwable as an OUT
parameter and what datatype should I use in the CREATE PROCEDURE and DROP

We have been using a long select-subselect query on a db2 server on
aix , the operation was taking nearly 4 minutes , but a mystical kind
of thing happened which we dont know, and the query started to take 6
hours , but mystically again by using the exported data from the aix

typed this into the ibm.com search window, but didn't get anything
that looked like it would answer a question:
+trigger +faster +db2 +cobol
the question:  are DB2 (390/v6, at the moment) triggers better

I have a table on wich I perfom an indexed search like
SELECT * FROM MYTABLE WHERE MYFIELD = ?
I'm designing the table and I can decide the type
of column MYFIELD. The two choices are:

The new driver db2jcc has a very poor error message description and
sometimes is very difficult to understand the error. Exist a way to set the
driver that output more descriptive error message ????

As the DBA for a development project a couple of years ago, I was in
charge of migrating/promoting stored procedures from the development
environment to the QA and production environments once they had been
proven. I automated the process with a script that sucked the source