I work primarily on Oracle databases. I am trying to convert a
recursive stored procedure written in Oracle to DB2.
Does DB2 UDB v8.2 (Windows/AIX) supports recursive stored procedures ??
After some research, I found out that to call recursively in DB2, the

Is there any way to make a Trigger use Uncommitted Read?
I want to avoid the possibility of deadlocks in my triggers by setting
them to use Uncommitted Read in all of their Select Stmts.
I get an error when I add WITH UR to the end of select statements in a

I have a problem connecting to a db2 database on our mainframe.
With a windows 2000 client uk version I have no problem but
a windows 2000 client with Japanese Language installed will not
connect. On the client we use DB2 Connect 7.2 patch 10.

I created and tested a stored SQL procedure in our test database.
When I add this stored SQL procedure to our production database our
users get errors saying that they don't have permission to execute
object.

The db2fm process on our server is using 12 % cpu  even when no
applications are connected. Can i stop this process? Is this required
for db2 to function normally? we are on db2 v8.1 with logical
partitioning.

Hey hey all...
I'm in the following situation:
I installed SuSE SLES9 on a dual core Opteron 275 (proliant DL385).
2GB Mem, hardware raid.

I found this in the doc:
"HADR does not replicate stored procedure and UDF object and library files.
You must create the files on identical paths on both the primary and standby
databases. If the standby database cannot find the referenced object or

I have a peculiar situation  where the same query is giving different
out on th edatabase server and the when the same database is catalogged
to another server
What  I find is the out put on server2 where the database is catalogged

When I connect with my database, I became the error "Username and/or
password invalid".
I have created a usergroup AG41 with User AG1 and AG2 on my Win2000
PDCN.

I'm not sure if DB2 has a tool specifically for this, but I was
wondering if there's a revoke tool that will completely wipe a
group/user off the database without having to revoke from the table
level, index level, etc

Why is that even though I have added index with DESC sort order on
primary key, records in Control Center are displayed by the sequence
they were previously inserted, not by the value of primary key?
If I perform REORG on table primary index, records get sorted by

Hi, I found the folowing errors in my diag log
ADM5500W  DB2 is performing lock escalation.  The total number o
locks
currently held is "1031", and the target number of locks to hold i

The application I work on has a table created with a clustered index. A
stored procedure that updates this table is then created while the
table is empty. As i understand it, the access plan for the stored
procedure is determined when the stored procedure is created/compiled.

   We made a backup image file for a database on one machine (A), and
we restored the database on another machine (B), using the backup image
file. Everything went fine. But when we try to connect to the database
on B, it's taking forever (about 1 minute) if it's the first ...

Any information you may have on why this error would be occurring would
be greatly appreciated!!
DBD: ERROR:DBD07001:JDBC jar/zip not found in the drivers directory
DBD: ERROR:ERROR: Loading drivers : com.ibm.db2.jcc.DB2Driver