I got this while reorganizing a database after doing perhaps a million
INSERTs. Not the best way to populate a relation, but the most practical.
Then I did a REORG and got this (looked up SQL2215N)
SQL2215N SQL error sqlcode occurred while committing previous work for the

I am on:  Database server = DB2/AIX64 8.1.5
It is also a partitioned database.
I am trying to create an UDF that uses cursors.  The following is a
simplified version of my UDF and error given.

I have an old version of DB2 Connect (v 6) installed on a Sun Solaris
(v 2.9)box.  It has been installed for several years, and to me, it
seems to work okay.  However, an application that uses DB2 Connect is
having problems.  While looking through db2diag.log I noticed a lot of

All of a sudden I am unable to create tables or add columns to
existing tables if I specify CHARACTER greater than 254. If I try I
get the following error:
DB21034E  The command was processed as an SQL statement because it was

Just been dabbling  with java stored procedures and I'm having
problems replacing
System: db2 8.1.4 on RH 7.1 linux system
1). Look at java jdbc samples as supplied with db2 and run the

I am presently running DB2 V8.1.6 on Red Hat Enterprise Linux 3 ES.
Every second, the following messages appear in my /var/log/messages file:
Jul 10 09:04:45 kernel: application bug: db2fm(21697) has SIGCHLD set to
SIG_IGN but calls wait().

I need to connect db2 client to server db2, but I don't know how!!  if
anybody know how  to do....  please.
thanks.
sorry, my english is bad. ::))

Just had an IBMer tell me that even with physical partitioning
that if one node fails, the transactions of those people/apps
connected to all the other nodes fail while the cluster starts
HACMP and recovers from the failure. I thought only those

Has anyone run into issues of having db2set run by an instance owner process
every 10 seconds.
We are performing auditing and it is showing up literally every 10 seconds.
I have shut down the governor and all event monitors except for

Im using DBI/DBD to connect to a db2 federated database. Id like to
detect if the different databases in the federated groups are active.
DBI provides the $dbh->ping command, but this only tells me is the
main database is active. How can I detect if the other databases are

I have a few rather urgent questions that I hope someone can help with (I
need to figure this out prior to a meeting tomorrow.)  First, a bit of
background:  The company I work for is developing a web-based application,
one part of which involves allowing the user the ability to ...

I am interested in finding out how DB2 DBAs automate tasks/jobs in
their environments.
What platform do you run DB2 on (Unix, Linux, Mainframe, Windows)?
If you currently have a solution, what product do you use?

I am trying to recreate a database under the following environments :
From: Solaris with DB2UDB version 7.2 with FP 9
To: Linux with DB2UDB version 7.2 with FP 9
It will be of really a great help if any one help me in step-by-step

Hello Esteemed Listers,
     Have also cross posted this to the Mainframe DB2 community.
We have been asked to look into the feasibility and the method of
migrating a SYBASE application to DB2. It is also being debated

While converting from SYBASE to DB2, can the entire Transact-SQL code
in stored procedures in SYBASE be converted to SQL type stored
procedures on DB2 (since there is no transact SQL equivalent available
on DB2) or do we have to code the stored procedures in some external