We are in the process of migrating from Version 7, running on an OS/2
server, to Version 8.2, running on a Windows 2003 server.  I have
created two databases on the new server, and have moved the data into
the databases.  One of the databases has a single user entering

I was just wondering if, like the db2diag.log, the notification log can
simply be deleted when it starts getting too big (I cannot find this
information in the db2 Info Centre).
Thanks

I cannot start the Control Center GUI tool on my production box. It
crashes every time with error "Faulting application javaw.exe, version
141.2004.3.1, faulting module db2jddba.dll, version 8.1.8.762, fault
address 0x0002bfbf." logged in the Event Log. It's a Windows Server

Hello, The create index statement executes for the past 1 hour while
trying to add a new index to a logically partitioned table which has 58
million records. Is there a command/utilit where I can check the status
of index creation phase?

I've been tasked with writing a z/OS C program to read and update a table
(DB/2 v8).  This Table contains a single row with a single column of data.
This program (which will run as a Stored Proc) needs to implement a strategy
for concurrency as the Stored Proc can be called ...

How we can eliminate duplicate records using SQL query.
Problem is :
Suppose there are two tables: TABLE1 (10 columns) & TABLE2(7 columns).
I need to eliminate duplicate from these two tables. 5 columns are

i have to do some  utility task like reorgnizing and runstat.
but my db contains about 200 table and i think it's very vague to run
this on each and every table
is there any way (like any scripts) to run  this on all tables at once

   Y'day one of my friend showed me how to connect to a Oracle
database as
SYSDBA, DBA etc
I have DB2 UDB installed in Linux machine.Right now, I have a user WADI

Dear Friends
Is there any thrid party tools available for db2 backup and recovery.
Currently for other databases like oracle and ms sql we are using
LEGATO Backup and Recovery Tool.

I'm currently writing a z/OS DB2 Stored Proc in C, using an example from the
IBM Stored Procedure guide (SG24-7083-00).  The database calls to read and
update the database work fine...however, I can't seem to figure out how to
pass parms to the C Program.  The compile, bind, and ...

DB2 UDB 8.1 FP7
We are getting intermittent deadlocks (911 RC 2) even when U row-lock
has been secured.
The transaction is as follows:

As a requirement,.NET(C#) Application has to access the data from DB2
Server(Windows) and DB2 AS/400 Server with windows authentication.
which drivers i have to use to access the data from DB2 Server(Windows)
and DB2 AS/400 Server.

I have 2 databases I need to search through. I am looking for say...
"bad.string" and want to replace it with "good.string". I do not know
where in which table or even field the "bad.string" will show up in.
What commands could I use to get this done?

Several weeks ago I asked what comments I could pass to DB2 in a SELECT
statement. I don't remember whether I said via PHP/ODBC. I was assured
that both /* */ style comment blocks and -- comment lines were allowed.
Unfortunately, neither work. Both -- and /* */ comments cause a

look at the procedure below
CREATE PROCEDURE PR_2 (  )
dynamic result sets 1
BEGIN