On my machine, someone had previously installed the trial version of
db2 v7.1.  I don't have the image anymore and hence don't have
db2_deinstall.  How can I cleanly remove it off the system?
Thanks

My developers are loading the DB2 tables from flat files through
DataStage.  
DB2 V8.1.1 on AIX V5.2
They are committing every 500 rows.

I have a problem with delete using where in clause. This is a query:
delete from tab1 where id not in (select id from tab2)
I calculated costs using select instead of delete:
select count(*) from tab1 where id not in (select id from tab2)

This is a merge questions which has been posted and answered... in my
case need more clairification when target table (tableB) matched
multiple rows to be updated based on the ON condition for a single row
from source table (tableA). There is a one to many relationship from

i have sript which will create the database
when i ran it  through db2cmd it gives me an error like below:
DB21034E  The command was processed as an SQL statement because it was
not a valid Command Line Processor command.  During SQL processing it

I have an application which would very much benefit from what's
described as "native XML" in Viper.  It is written in VB6.

without converting the source code of my app to VB.NET.  That cannot be

Have an authentication/authorizaiton question.  Our usual means to
provide SYSADM authority for incoming connections to DB2 v8.2 on AIX
has been to use SERVER authentication and set the SYSADM_GROUP dbm cfg
parameter accordingly. How can same be accomplished for incoming z/OS

i've been thrown into a pit with DB2 and have to start writing things such
as tables, indexes, stored procedures, triggers, etc. The online reference
is only so helpful. The two pdf manuals are only so helpful. Googling is
only so helpful.

How can one call SYSPROC.DB2LOAD procedure within a SQL stored
procedure.
I get the following error:
DB21034E  The command was processed as an SQL statement because it was

When I installed DB2 UDB 8.2 on AIX 5.3 it got installed in
/home/db2inst1 (and I didn't care about it much then but now I would
like to move the same instance of DB2 to a dedicated filesystem. May I
know the steps involved in doing this migration activity.

can anyone help me writing a query that starts from the outer query
selecting a few fields which are to be used in the nested subquery and
the result should be returned based on evaluation and the query should
again continue in the same way for the remaining records in the outer

I'm driving Windows XP and could use a tip on installing a function
written in Java.
1. I created the a Java jar file, named UdfUtils.jar, from the Java
source file shown below:

I recently being bugged by the following error on my DB2.
SQL0902C
SQLSTATE = 58005
Reason Code = 14

To reconfigure oracle9i from server to client operation,
two files need to be modified:
listener.ora (for the server IP address), and tnsnames.ora
(for user permissions).

Can anyone tell me why a EEE system might be created to have two
separate tablespaces with the same 4k pagesize ?  They both appear to
be in use as I can see the underlying files being modified.
These were created with SMS and reside on the same disk and filesystem