Anyone know where to get one?  Or a website that has something similar?
TIA
Mairhtin

Is there a way to run the db2-generated HADR-create script outside of
DB2CC beyond the obvious?  My DB2CC generates the HADR script and then
abends because of a java error meaning I can't finish my HADR
creation.

When a client application crash in the middle of a transaction, db2
keeps the locks on tables updated in the transaction whereas the
connection has been killed...there is the same behavior under oracle
as long as the server do not check (by default) the state of

How do you change the schema name of a table?
db2 rename table admin.employees to emp.employees
  returns SQL0108N
db2 +c set current schema emp

I am writing a script to help me migarte von database to another. It
should create all tables, indexes and sequences automaticly. While
developing I have to test the script from time to time. So i have to
delete the created objects sometimes. No problem with tables and

I am trying to export a database and its data from UDB 7.2 or 8.1  to
Mainframe DB2.  Is this possible?  The last time I did this, i ended
up having to write insert statements for each row.   Is there a
utilitity to accomplish this?

I am trying to make connection to Content Manager. Can anyone help me
how to fix this error? Thank you.
Exception in thread "main" java.lang.UnsatisfiedLinkError: SQLAllocEnv
       at COM.ibm.db2.jdbc.app.DB2Driver.SQLAllocEnv(Native Method)

Hello, Im a novice at this so bare with me.
I have two tables which will be match merged based on 10 conditions
(select statements).  For example, if a record exists in table A but
not in Table B then that record will be inserted into a separate audit

In a test environment we have dropped over 100 RI restrictions which showed
a huge instant performance gain where some jobs were running with 2 or 3
times the performance than previously.
The problem is that we have now dropped the same restrictions in the

I am about to (fingers and mouse at the ready) install DB2 on a Linux
machine using the db2setup command.  All is well.  But ....
During the install it asks if I want to create an instance, which I
believe I do.  My hesitation is that this computer will be the co-

Folks,
 I have a perl script that creates and uses global termporary table.
This script worked fine with UDB 7.2 on AIX. Sometime ago I moved the
database to UDB 8 on Linux. The select statement that used to take less

I am trying to read BLOBs from a large table (i.e., greater than 34K
rows) using Java and the IBM JDBC driver (actually through an
Application server).
I get the following:

Hi, anybody has an example to combine db2uext2.cdisk & db2uext2.ctsm
together, so that db2 log can be keeped into hard drive & tsm?
Thanks

I'm new to DB2 and I need to write a query that will allow me to find
specific dates instead of me having a date range asked for, I want it to be
calculated.
I've done this in Access by coding visual basic scripts and making monthly

I have already specnt many hrs in getting these resultsets but no
success....can anyone help me out please?
I need urgent help to retrive the data in the following format:
Table 1 :