Hello, I have what may be a beginner's question regarding DB2.
How does one access a remote table on a remote database via SQL? What is
the command string, is there an equivalent of Oracle DBLINK? I hope I
was clear.

Here is a small testcase of the problem which I'm facing in prod env.
db2 => describe table tab1
Column                         Type      Type
name                           schema    name               Length

Dear Friends
I am intresting to sit for DB2 Certification exams. I would like to
know how many papers i need to write for DB2 DBA. could you pls provide
me url where i can get full information.

Give a table with a lower bounds, upper bounds, and targets, I would
like to select on a value and supply the target. For example, think
about marginal tax rates:
AgiLo     AgiHi     Marginal

I am getting the following error while trying to alter a table's
column...I am trying to increase the decimal length of the column from
5 to 6 using altobj procedure.
SQL0443N  Routine "SYSPROC.ALTOBJ" (specific name "ALTOBJ") has

I have problem to connect to db server from app server. The error is
SQL30081N  A communication error has been detected.  Communication
protocol
being used: "TCP/IP".  Communication API being used: "SOCKETS".

BHID id the (only) primary key, and thus index, of Animals, which is the
only real table involved.
Pedigree2 is the view based on Animals.
runstats on table is3.animals ON ALL COLUMNS AND DETAILED INDEXES was

Found some samples that say this statement should work, but is doesn't
(invalid token at "Where (Key1," ).   Is there something I'm doing
wrong or a better way to accomplish what I'm trying to do?
delete from FileA

The following query takes 3-5 seconds which seems a bit excessive:
select * from is3.pedigree2
 where  bhid in
        ( 322380, 379701, 380901, 394336, 394342, 396039, 400764)

Dear Friends
Currently in my environment DB2 v8.1.7 is running on windows 2000
Operating system. Now i need apply patch to upgrade database to DB2
v8.1.10

I just recently set up replication for testing purposes and I am having
some difficulties using it. In the log db2inst2.COPYDB.DEPTQUAL.APP.log
these errors show up every 5 minutes, or when the apply process runs:
2006-07-11-15.54.25.984297 <CPEXEI(36/01)> ASN1029E  APPLY "DEPTQUAL" ...

I know that we could insert data from a table to another table by
insert into A(F1,F2) select F1,F2 from B;
However, it seems that DB2 doesn't have insert update for this kind of
statement (i.e. The insertion failed if primary key already exist in A,

I have two tables M_SEG and G_SEG with contents
MSEG     GSEG
-----          -------
BBB        North America

Friends:
In a DB2 UDB LUW table, I have a table with pairs of equivalent ID's.
What I want to do is assign all equivalent IDs to the same group
number, including those that are transitively related, i.e., if A = B

I have created a Stored Procedure in DB2/400 . This stored procedure is
receviing 2 numeric and 4 character variables in *ENTRY of my SP
program named XXXX written in RPG/ILE. Then Create procedure was
executed to make this program XXXX as SP.