I am new to DB2,
Currently i am using DB2 version 8.02 personal edition on Windows XP
Professional.
And Facing problem with rowlock in insert query.

I have a requirement as follows:
I have a COBOL+DB2 program that inserts data into a DB2 table when an
order is placed. Now, The same data should be inserted into the same
table after every 7 days until a condition is met. This means I need

We're trying to set up an HADR pair on two databases on instances with
different names on separate servers.  The databases were defined as
follows:
CREATE DATABASE database1 ON '/db2home/instanceA';

Is it possible to write a DB2 stored procedure in JAVA that can call a
Web Service?
We are using DB2 UDB Version 8. Do we need any additional packages/fix
packs to existing version?

The scenario is that i have one server but due to the number of users in 3
countries and the amount data it runs slowly
What i want to do is to install another server , both servers will be the
backup of each other. Users from country 1 will access server 1 and users

Folks,
 I am having hard time figuring out the problem I have with setting up new
 DB2 instance. This is 22nd instance I am creating on the server and I
 have never encounterd this problem. My server and client (2 different

I am trying to script a manual operation using DB2's command line.
Simple commands are working, but the command entered below displays a
"db2 (cont.) =>" prompt, then fails on any input? I'm missing something
obvious, but I don't see it.

I know db2advis will list unused indexes for a particular SQL,
workload etc.
what if I want to see all unused indexes at database level. How can i
do that?

I am starting to config a 64 bits DB2 in IBM 595 AIX box with 2 dual
core CPU and I would like to assigned one 'processor' for one db
partition. Should I config it as a 4 nodes or 2 nodes instances? How
about other setting such as IO cleaner, Default degree etc?

im trying to install the DB2 9 version and while installation it is
asking DAS user for DB2 tools.
i've given as many passwords as i can but it always says  "The
password specified is invalid. Enter a valid password".

I am trying to add new tables to the source and target databases and
adding them for replication. I am trying not to start a full refresh
by issuing a CAPSTART signal. I have 1 source database and 2 target
databases. How can I prevent full refresh for both the targets? Any

Our DB2 V8 FP14 application cleans up backups over 8 days old using
the "db2adutl delete full older than 8 days" command. However our user
has asked that we keep one backup for a year. Is there any way to
manage this within TSM?

I have one server running OS/2 with DB2 V7.2 (last available for this
platform). I have the Linux version of the installed V7.2 available. The
databases are relatively large so disk space is at a premium on the box and
I would really like to be able to share the instance when ...

I use db2 v8.1 on AIX 5L
Evrytikme I take a snapshot for one my databases I can see that there
are Hash join overflows and small hash join overflows..
Jus need to know what shud i look into yo solve the problem..

Can someone give me the command to check who is logged onto the the server