If I perform a Takover by force peer window only what is the
recommended action with db2 on the old primary in terms of HADR.
Thanks.

for a hardware migration project I would like to implement HADR
between the old and the new system. on the old system runs DB2 9 WSE
on the new system will be DB2 9 ESE both with fixpak 4a. The idea is
to minimize outage for this hardware change by limiting the downtime

Using Express-C 9.5, I'm moving the server to an AMD 64x2 box from a 32-bit
one.  Can I simply use backup/restore or is the architecture such that I'll
need to use either dbmove or brute force to re-position the databases?

In DB2 v7, there is a basic directory /usr/lpp/db2_07_01 which
contains useful stuff like a ./instance directory with more useful
stuff inside (like db2icrt).
In DB2 v8, I have no simple  /usr/lpp/db2_08_01directory (even though

Db2 is throwing the following error for db2nodes.cfg
C:\Documents and Settings\Administrator>db2start
SQL6031N  Error in the db2nodes.cfg file at line number "1".  Reason
code "10".

Footwear (paypal payment)www.king-trade.cn )
Paul Smith shoes
Jordan shoes
Bape shoes

We are using db2 v8.2 on AIX
Would using a VIEW for the sole purpose of only needing to look at one
table to get data make sense?
If you have three tables T1, T2, T3 that contain 2 columns each that

What exactly happens during a statement "alter table t1 activate not
logged initially"?
I have  5 million row table and issued the above statement. It's
taking ages to return and a table snapshot shows me that huge (10

I have three scripts called extract_data_1.sql, extract_data_2.sql,
and extract_data_3.sql each of which exports data from a DB2 UDB
database (in UNIX). Since the data exports are long running, I wanted
to call these scripts in Unix shell script in the background (so that

1) What is the best method to parse a string?
2) How do I throw a sql exception such to return -1 and exit the
stored procedure
A stored procedure is passed a varchar (represents <schema

I need to do a FOR statement with a cursor made from a Select
statement... somthing like this:
DECLARE v_stmt STATEMENT; - some select
SET v_query = 'SELECT .... ;

Need help! For 9.5 I found. Need for 8.2.
Thanks,
Andy

DB2 9.1 doc for DB CFG parameter DB_MEM_THRESH says:
"Some versions of Linux® do not support releasing subranges of a
shared memory segment back to the operating system. On such platforms,
this parameter will be ignored."

What I thought was going to be a simple recursive query, isn't. I have
of data folders that have folders within. Given:
create table fldr (
fldr_id int not null,

I am calling a stored procedure from ISERIES/Terminal on AS400 that
interacts directly with DB2.
CALL XYZ/WABRACADABRA  (81508, 46396, '024582348', '', '', 'I')
The proc takes 6 inputs and has 1 input/output variable. I get the