Hi.  I'm in a jam... I restored a DB2 database from one win 2003 DB2 8
server system to another DB2 8 server system now I can't connect.
I'm trying to connect my tomcat app server to the remote DB2 database.
It was initially configured to work against the local DB2 database.

I'm running a merge operation on one of my database tables and i was
wondering if there's any way of knowing on which phase the process is
going (similar to list utilities), or in a simpler way, i want to know
how long will it take to finish, any ideas?

My select process with isolation level=CS on a table with locksize =
row  waits until the other insert process commits.I don't lock the
table level and if I change the select process' isolation level to UR,
it doesn't wait.

We have an "Insert into XYZ_Table(seq_nbr, abc,def) select 3, abc,def
from XYZ_TABLE where  abc > ### " query in our application. This query
is an COBOL Stored Procedure residing on DB2 Mainframes. When multiple
users access the application and call this Stored Procedure

I have an environment that contains V8 (FP 11) and V7 (FP13) Linux
servers.
One of our applications reads data from V8 servers and writes
summarized data into V7 servers that can´t be easily migrated for

db2 v8.1FP 7a on AIX 5.3.
My weekly overnight REORG job sometimes generates SQL2219N rc 9 errors
"START is not allowed as a prior paused table reorganization has not
been stopped".

I am about to convert a program (which is not yet released) from VB6 to
VB2005.  VB2005 uses .NET, and it seems to me that db2 Version 9 only
works with .NET, or am I wrong?
Where do I find instructions on how to install V9 without ODBC so that

can user connect to db2 server without providing username and password
from client?
regards

I'm trying to debug a simple Java UDF written in the DB2General style within
Eclipse.
I'm getting a java.lang.UnsatisfiedLinkError when I execute the set() method
in the UDF. I know that the UnsatisfiedLinkError has something to do with a

Can we add constraints to an existing view?
DB2 V8.1 AIX 5.3
Cheers,
San.

Do anybody in this forum knows of any free tool that can be downladed
from to browse, create, test and execute DB2 queries and objects such
as stored procs, view, etc.
I find the development center hard to use and a little bit slow.

My company is running DB2 on AS400 iSeries V5R3 and making a strong
push to move from RPG/External stored procs to SQL stored procs.  My
background is Oracle/SQL Server and am used to using some "SQL Tool" to
assist in creating and modifing stored procs.  We are currently limping

I have read that raw i/o on Linux has been depricated and support for
it might be removed from future kernal releases.  I am trying to assess
what impact this has.
My current db was built on kernal 2.4 and later upgraded to 2.6.  The

I am trying to get a better understanding of client side settings,
particularly DB2CODEPAGE.
I have a back-end remote unix db that is UTF-8 (1208).   On my remote
clients, I see that my data loads(inserts) behave properly by setting

I know this is possible in Oracle but has anyone done it in DB2 and
could you maybe direct me to some documentation or let me know how I
would go about doing it?
In the oracle world you would basically need to do the following: