I have an existing database (on a Linux Red Hat ES3) where the
replication function exists but does not work because the target
database has been shutdown months ago .
My question is what will happens if i start the target database ?

I am trying to use the AIV extender with DB2 PE v 8.2.
However, when i try to enable database for DB2Video I get the following
error report:
db2ext => enable database for db2video

I have to do a full refresh with starting capture with mode = cold.
After that capture is up and running, but:
2005-05-23-09.41.41.613431 <CWorkerMain> ASN0109I  CAPTURE "ASN". The
Capture pr

I'm trying to insert a clob / blob from the local file system into a basic
table. This can be quite easily accomplished in Oracle but I have not found
any wquivalent way on how to do this in DB2. I have the following table:
create table docs(

Hi, two questions --
1. Will compacting lob data help reduce the space occupied by the lob
column and any disadvantages to doing this?
2. I have a table with a lob column that was not compacted when the

Vennela Technologies is a Global Oracle Technologies and Oracle
Applications services Provider with a good customer base in Middle East
and Europe
Vennela started its Training division very recently. We are very happy

I've been working with WSE Win32 on WinServer2003.  For remote
communications, have read all the docs a dozen times.  Keeps talking
about run-time clients and other clients.  I could never get this to
work.

Apols if this is trivial ... but I'm a new user and
can't seem to figure it out.
I'm using QMF on TSO.
As an example assume I have two tables:

Please let me know how can i handle any kind of error conditions with a
single (condition and continue handler).
I need to catch any kind of exception thrown in the procedure with
a single

I had trouble to get the hmon work in 8.x FP 8 and FP 9 .
The server runnig Windows 2003 SP1 on a member server.
The db2 services are running under an domain admin account.
Ok, no problem so far (HMON working) .

I am trying to load data from a Sybase table with 'datetime' column
into a DB2 table with 'Date' type column? I used the following command

db2 "IMPORT FROM tabname.dat OF DEL MODIFIED BY COLDEL^ delprioritychar

We are making a program for benchmarking DB2 databases in C#.NET ( for a
DB2 ESE V8.2 on SuSe 9 SLES).
For this, we also want to request some basic information from the database:
list database directory, list tables for schema dasusr1...

This lookup the service controller, because db2 8.2.2 does not force
connections at "net stop" command .
-Zahni

I am using db2 on AS400.
Where can I find out what type of fields it has?
I am particulary interested to know what is the maximum text field
size.

We are starting a large data warehousing project using DB2 8.2 on AIX.
There is a direction to move any new internal development to Java and a
question was raised: Would it be a good idea to have all stored
procedures that we might need (ETL, additional transformers, etc) for