Hello, every body.
When execute dynamic generated multiple OPENQUERY statements (which
linkes to DB2)  in SQLServer, I always got SQL1040N The maximum number
of applications is already connected to the database. SQLSTATE=57030.

I have three tables
   ALIGNMENT
----------------

Given the following COBOL statements with embedded SQL...
      Select-ppissue.
          EXEC SQL DECLARE c1 CURSOR FOR
              SELECT

DB2 V8.2 on AIX, type II index is created.
I see this from deadlock event monitor.
5) Deadlocked Connection ...
 Participant no.: 2

I have a database v9.1 ESE on Windows. I'm working on Linux. On Linux I have
Express-C V9.1. I have started db2ca tool to catalog the database on
Windows. The tool gives you the option to test the connection at the end of
the wizard. The connection was succesful.

------------------------
UPDATE A
SET A.ID = '?' + A.ID
FROM TABLEA A

Given a table with an identity column (GENERATED BY DEFAULT AS
IDENTITY),
is there any way to get the last generated value by DB2 for the
identity column?

i have seen the check status then it is showing like :
Type Of Thread                Status
HoldL                              Resting
Admin Thread                  Resting

I saw a presentation on SQL that's supported in DB2 UDB v8 for z/OS, and
it mentioned that the following syntax:
   A IS NOT DISTINCT FROM B
is equivalent to:

I am trying to configure php with IBM-DB2 and I get the following
error:
checking for IBM DB2 support... no
configure: error:

I have a table which has around 3 billion records on an env and a
simple query against it goes for a tablescan eventhough an index has
been defined and this happens only on an env.
Details are as below. Please advice

i have a udf that returns a table  i then want to set a variable in
using a select on the returned table :
an example (not the real code)..
.

I was hoping I might be able to get an answer regarding DB2 and HADR.
Let me preface this by saying that I know very little about networking
and I'm not familiar with the HADR product or clustering. But, I've
been asked to research a couple issues for a client.

I see, that even in V9 they are not supported.
Question to IBM:
Is this functionality planned in future?
They are supported in iSeries and I think it's very convenient...

Question
DB2 Enterprise Server Edition(ESE) is running on Linux and needs to
validate the userids and passwords on the z/OS server for the DB2
clients connecting to DB2 for z/OS. Which of the following