Can you please give your inputs for this,
OS : AIX 5.2
S/W : DB2 ESE 8.1 with fixpak 9.(Partitioned environment)
DB Size : approx 4TB

I have a table which is replicated for after images only.  I tried to
do an import using the replace option into the source table with data.
For some of the rows, they were not in the import file, so were
replaced in the master table as a result of the import.  For the

I am running this command.
db2 "CREATE SERVER <servername> TYPE DB2/UDB VERSION 8.2 WRAPPER DRDA
AUTHORIZATION "authid" PASSWORD "pwd" OPTIONS( DBNAME 'dbname',
PASSWORD 'Y')"

One question - to connect to a db2 database in the same UNIX server we
can use from UNIX command prompt:
db2 connect to <dbname> USer <name> using <pwd>
Now if the db2 database is in a differrent server where/how do we

Does anyone know what's difference among "connect reset", "disconnect",
and "terminate"?
Thanks in advance,

DB2 UDB v 8.2
In the restriction section for HADR it states:
-    The database versions used by the primary and standby databases must
be identical. During rolling upgrades, the database version of the

I have two questions about HADR recovery.  I am running db2 v8 fp12.
1) If the primary suddenly crashes would you always want to switch the
standby to the primary by force...or would there be times when you
would want to make it a standard?  (and why)

Using a base table, a MQT table was created.  With optimization - when
querying the base table with calcuation that are already completed in
the MQT - I would assume the optimizer would use the MQT table instead
of the base table.

Guys,
Assume i have taken the db2pd -locks output and there i have seen
lockesculations
like this

I have 2 LUNs , one for data and another for logs.
Currently, I want to implement DR environment. For some reasons I'd
like to implement async mode for data and sync mode for logs. May I do
db2 command db2rfpen & rollforward after switch over to DR site? Is it

Hi.  I've been using the personal edition of db2 Connect to access our
mainframe database from java apps for the last 9 months or so.  I'm using
prepared statements, and the setLong method has proven unreliable for both
parameters and insert values, not finding search filters or ...

Can somebody help me out here?
I have a web server sitting on a DMZ that has DB2 UDB version 8
installed running on it.  I would like this server to be completely
independent of our internal network.

Laws and Myths of Usability & Interface Design
Introduction
Usability and relevance have been identified as the major factors
preventing mass adoption of

Hi i am using this tool called db2mon by Chu Zhoi. But when i
downloaded it and am trying to use it an error failed to load
db2mon.dll comes. I tried extracting the dll and the exe file and
putting them in the same location but it doesn't work. Does anyone know

I have a sql in a siebel environment that is running for a long time.
Is there any way I can tune this sql :
UPDATE siebel.S_ORG_EXT BT
SET PR_POSTN_ID = (SELECT MIN(T_ACCNTPOST_POSITI) C1