I am looking for a way to insert into one table from another table but
ignore duplicates (because the query will fail since the column I am
inserting into is a unique index).
RE:

I have a question that I'm hoping has an easy answer.
I'm working in DB2 V8.2 on AIX 5.3
I have a timestamp column (i.e. 4/26/2006 1:02:42.000000 PM) that I
want to return in a report from standard SQL.

Hi hi, I'm trying to perform a redirected restore, but I get a nice
error returned. Does anyone have an idea of what the -5130 errorcode means?
db2inst@ELMO:~> db2 restore db efproddb into testprod redirect
SQL1277N  Restore has detected that one or more table space containers are

I have DB2 v8.1.0.0 currently on Redhat 8.0 box.
Want to upgrade it to V8.2, downloaded FP10_MI00138_RTCL.tar from IBM.
Extracted and run db2_install, get the following error.
[root@redhat rtcl]# ./db2_install

how could I do an export of tables via Java / JDBC.
There are very big tables.
I thought about:
EXPORT TO c:\aa.ixf OF ixf SELECT * FROM TEST1

My account has DB2 SYSADM granted to it.
I am trying to issue DB2  Subsystem commands via rexx.
Error:
16.46.34 JOB04218  IEA630I  OPERATOR OPRJAW0  NOW ACTIVE,

Complete DB2 newbie here, so go easy on me. I am having a problem
adding a connection in the DB2 CCA, on a NT server (Citrix). I have
exported the connection from one of the other servers in the farm, but
on adding the connection to this particular box, I get an SQL1317N

The topic pretty much says it all.  The terminal emulation program is
PCOMM connecting to a mainframe.  I can send files as sequential data
sets, but not "DATASET(MEMBER)"
The TSO error message is "incorrect option specified"

Does anyone know if DB2 has the capability to cluster in an
active/active mode over geographical distances.
I am aware of the replication tools and HADR capabilities but this is
more active/passive.

I just installed the express-edition of DB2 server (on a Win-XP
machine),
and then I setup a client JDBC driver to access it.  The query is a
simple

Is this still true?
http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c
36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f987
49d8e2983
would a standard type 4 driver, jar file copy into the WEB-INF/lib
folder not work?

Hallo everybody!
I'm no expert in IBM systems so I hope the probem I'm asking for help is
not OT.
This is the problem: I have an IBM x206 with a Redhat ES 4 update

DB2 8.1 FP7a on AIX 5.2.
$ db2 SET CURRENT LOCK TIMEOUT NOT WAIT
DB20000I  The SQL command completed successfully.
$ db2 values current lock timeout

   Could any one please shed some light as to how an jar whose copy
has been deleted from the SQLLIB\FUNCTIONs\JAR\<schema> still be
referred to from our projects?
Even after installing a fresh copy of the jar, the old copy is still

I have the following table contents:
MONTH       STATES
-----------        ----------------------
         1                   5177