we have a contention problem because of an application which tries to
insert a duplicate row in a table with primary key. This insert fails
of course but the locks are not released within this transcation.
Why DB2 does not release the X lock after a failed insert???

W2K, db2 v7, fp11.
Given:
create table pays (
acode integer not null,

Can UDB V8 fp 5 connect to datajoiner 2.1.2 fp 13? We are receiving this error:
SQL30081N  A communication error has been detected.  Communication protocol    
being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location      
where the error was detected: "10.92.1.183" ...

I have a database which I have loaded onto our as/400 v4r5.  All the
tables and data have loaded successfully.  I am using DB2 connect to
access.  I now want to delete the data in a table which is where the
problem is starting.

db2 => connect to ksdbs
(... ... about 10min,then report following:)
SQL1224N  A database agent could not be started to service a request, or was
terminated as a result of a database system shutdown or a force command.

I would like to know whether DB2 get a command like sybase sp_depends.
For example, I need to drop a table. How can I know which stored
procedures depend on the table?
Thanks a lot

About to create a table which will "include" a BLOB.  Am not sure how
large to make the container and the tablespace.
What I see says that BLOB is stored "separately."  However, I don't
know where.

I've done this before, but apparently I didn't keep my notes..
I have DB2 Personal Edition on my Windows XP box to talk to our DB2
database on our AS/400.  This HAS been working fine.  Until this
morning, that is.  It was working Friday afternoon, and this morning,

I'm getting some rather strange behavior with PHP4 on Debian Linux
accessing a DB2 V8.1 box on AIX.  I've recompiled PHP "--with-ibm-db2"
support.  I'm able to connect to the database just fine, but when I
attempt to select data from a table "WITH UR", I get the following

Look below..  I'm baffled - what is going on?
db2 => select tablespace_name from table(snapshot_tbs('epmdev01', -1))
as snapshot_tbs
Do you want to execute the above command ? (y/n) y

I figure how to create a sequence alias, in the same fashion that one can
create table alias. Is there a proper way to do so? Thanks !

In an SQL procedure which I'm going to use for a model for several
others, I tried:
DECLARE v_schema            character(8) default 'is2';
SELECT bhid INTO v_tmp_bhid FROM v_schema.animals

I have a DB2 UDB Express on Windows system (Server: Win2003 - Client: WinXP
Home Edition)
Message of error (on client machine):  IBM-Informix-DB2 Universal Database
Express Edition is not supported on this version of operating system

Coming from Oracle background:
How do you carry thiese admin tasks in DB2 Environment :
Check instance availability
Check listener availability

We are trying to determine the easiest (and cheapest) way to get
connections for about 50 Win2K workstations on our LAN to DB2 on a
z/OS server.
We could install DB2 Connect Personal Edition on every workstation,