Is there any tutorial or some kind of simple step-by-step instructions
to setup DB2 Queue Replication ? All I am trying to do is setup
replication on just  1 table from  DB1 of Inst1 to DB2 of Inst2 (Linux
platform).

I use the following SQL statment to bring z_emp_id values to a
employee table:
update employee set z_emp_id =
(select z.emp_id from z.employee z where z.login=employee.login)

I want to execute the following SQL statement for a single emp.emp_id.
Just adding and emp.emp_id=256 to the end of the statement results in
a SQL statement that on average takes 5.5 seconds.
I've tried various permutations of the statement where I add "and

The following statement doesn't work and I need a tip.
Here is a draft:
This selects data from the z table.
And fetches the next value for r_id_seq and creates a table named b.

Is there a way to get the ddl for a subset of tables?
In this case, get all the tables beginning with emp from the sample
db?
Example

I have written a nice application which is working nicely on a DB2
V9.1 LUW with the olap row_number, so far so good but now I have to
let this run on a mainframe (z/os) DB2 ver 8... and this does not
exist there..... the wonderfull row_number.

Is there any command or tool for doing DB2 Catalogs reorg/check to
keep the contents are correct?
If the contents within catalogs are incorrect due to unexpected
situations, is there a way to re-build them?

I have a question on Database threads, would like to know how does
they work.
Suppose I select Table A which has got around 50k rows of data, while
my select is running another user tries to truncate the table A using

I was searching through DB2 InfoCenter, but didn't find an answer to my
question:
When I get an SQLCODE from an SQL command (ADMIN_CMD for example) when I
want to know what this code means; is it a warning, error, ....

       we are adding a new tool for monitoring our DB2 UDB instances
so  any one help me to identify
1) what are all the possible parameter that has to monitored by a DBA
in db2 UDB?

I have always been confused abuot the terminology.  What is the
difference between DB2 and UDB?  Are they one and the same?  Is one a
subset of the other?
Thanks in advance.

If I drop some constraints on a table by 'alter table..' query, does
this table go into check pending state? If no, then what is the way to
put this table into check pending state other than using  the SET
INTEGRITY statement?

We have got 2 DB2-UDB databases (DB1 & DB2) running on separate
instances( Inst1 & Inst2).
DB1 has got Schema1 and DB2 has got Schema2.
We would like to setup some kind of replication to replicate both

Is there a way to use SELECT to reassign the value of a column so it
displays differently?
For instance, I have a column called status.  It is an integer value
in the database (i.e. valid values are 1, 2, 3, 4).  I want to display

I have installed db2 9.1 enterprise trail version on Fedora 7(using
all the default settings except creating a partitioned instance), and
got two response files, one of which is db2ese_addpart.rsp. how can I
add another logical partition on the same computer?