i accidentally ran an UPDATE statement without the WHERE clause on a
customer's live customers table. After saying "oh sh.t" many many times, i
closed the ad-hoc query tool, hoping DB2 would see my disconnect and
rollback the implicit transaction. (Either that or DB2 would have ...

I need to somehow relate certain records together in a table and I am
wondering if this is possible in SQL at all.  Consider the table
definition below.  I need to find all pairs that have associations
whether through id1 or id2.  For the sample data set, the result should

we have the following problem using a DB2 version 7 on z/OS, referring
also <a
href="http://groups.google.de/group/comp.databases.ibm-db2/browse_thread/thread/255501
8c0d364314/ea946c98e25ce4b7?lnk=gst&q=assmann&rnum=2#ea946c98e25ce4b7">this
thread</a>:

I am running the following commands on an AIX 5.2 server, using db2 udb
v8.2.2.
my ipcs -mb command gives me the following:
IPC status from /dev/mem as of Mon Nov 20 12:47:25 EST 2006

Hi hi.
I'd like to gain some knowledge on packages.
We're getting an error "SQL0805N  Package "NULLID.SYSLH214
0X5359534C564C3031" was not found.  SQLSTATE=51002" On our production

I'm linking a DB2 database running on Linux to SQL Server 2000, in
Enterprise Manager. I've done this successfully on several servers, but
on some servers I'm getting the following error when I try to access
the DB2 tables:

My reorg script is taking around 17hrs and still running,generally it
used to take around 30mins(Production Server).
Im planning to kill it,Can any one please let me know how to kill and
if i kill, does it effect my

Can anybody tell me what the error code for Export is. Like i get the
message
SQL3104N  The Export utility is beginning to export data to file
"/home/db2as/sqllib/bluee_tables1/DBCHECK.ixf".

I'm normally not the guy to push marketing, but this one is actually
quite funny. Oh.. and it takes 30min. Longer than your average
commercial break. But goes down easy with popcorn and a coke ;-)
http://www.soalaunch.com/exclusive/

Assuming the following setup:
Server1 running DB2 V8.2 with two databases DB_1 and DB_2:
db2 catalog db DB_1 as CURR_DB
Server2 DB2 runtime client:

I hear that DB2 V9.1 has dropped, or will soon drop Net Search
Extender.
I have occasion to require quick search for a particular word of
several columns of data, and very many rows.

I have a strange problem.. Creating and installing java stored
procedures through :
1) call sqlj.install_jar
2) Creating the sprocs db2 -td@ -vf sproc1.sql

db2advis gave me error like

execution started at timestamp 2006-11-15-09.51.37.046473
Using the default table space name USERSPACE1

while am trying to access the db2 database from a J2ee application it
is giving the following
error.
com.crystaldecisions.report.web.viewer.CrystalReportViewer

In my environment we are using DB2 UDB for Windows for development and
DB2 UDB for z/OS for production.   In DB2 UDB for z/OS uniqueness of
columns that permit nulls may be enforced with a unique index created
with the "WHERE NOT NULL" parameter; this has the effect of ensuring