I was asked to recreate a new clean database for our developers because
the current one they use is not entirely up to date. So I created a new
database and I run into the followin strange problem. First some facts:
System: DB2 V8.1 Fixpack5 Redhat Linux 8.0 dual processor

Dear Group,
I have the task of designing a table with similar characteristics of
Oracle range partitioning.
Note: we are migrating from ORacle to DB2 and we have many tables with

Following is a simple trigger definition:
CREATE TRIGGER TRIG_EMPLOYEE_1
AFTER UPDATE OF SALARY ON DB2ADMIN.EMPLOYEE
FOR EACH STATEMENT MODE DB2SQL

This is a simple problem I expect, but I cant seem to crack it.
I have to tables I wish to join A & B. I wish to join them where A.a =
B.a. There are multiple entries for B.a, and I wish to join to the
rows with the lowest B.b.

Doozie of a problem here - may open a ticket with support, but wanted
to see what others had to say first...
We have an AIX 5.2 server with DB2 V8 FP5 and 32-bit instance. ~45GB
db. Reorgs and runstats are done weekly and the server is at least

Anybody know when DB2 is going to support Concurrent I/O on Aix... I
heard it was coming but I don't know when?
Thanks
Scott

we use db2 udb v8.1 on windows, our application use jdbc to create
connection and sql statement, we will need the row lock prevent other
session update but allow to read at the same time for the same row.
since the row lock holding could be couple minutes, so for the

I have a SQL stored proc in DB2 8.1.5  (linux)
This SQL proc depends on a table in the database. When I drop this
table from the database and try to execute the stored proc - I
correctly get the error message :Error:  [IBM][CLI Driver][DB2/LINUX]

We have server 2003 with sql 2000. as a client getting data from an IBM
iseries server with DB2 UDB. The connection is through a linked sever with
ODBC connection to DB2. If we invoke a SQL stored procedure to txfr data
from DB2 to SQL 2000 the stored procedure completes fine but ...

does anyone know, where the configuration of a db2-client on a
windows-machine is stored?
I searched the registry and the filesystem on my machine and couldn't find
anything.

I want to replicate 5 tables from a production OLTP database to an OLAP
database several times a day. What's the best way to do this?
export/import? db2move? Two of tables will contain at most 30k rows and no
LOBS. The others < 10 rows.

For some reason SQL0407N error messages never reveal the name of the column
to which a NULL value has been assigned. Here is an example:
SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2,
TABLEID=10, COLNO=11" is not allowed

I have problem with replication db2 database.
Program Capture view error ASN5150W and ASN0059W.
What i doing wrong?

Why is this simple SQL SP not returning any results? It is running fine
(gives RC=0) but just not returning the result set.
CREATE PROCEDURE SQLSP9
(

During a routine performance check using an event monitor, I
discovered a class of query whose performance has me baffled.
The monitor captured:
SELECT * FROM EWM_CASE fetch first 1 rows only