The merge statement below is (still!) running an inordinately long time.
the table animals has bhid as its primary key, so the double self join
should not take too long. What I'm afraid of is the merge using no
indices because both parts as subselects.

If I am trying to locate a specific ID value [int] that could be
located in any of several tables, I can search each table by using the
UNION command right ?
SELECT ID FROM TAB1 WHERE ID = 17

When I try call sql stored procedure on version 7 (win) server from 8.2
fixpack 9 (win32) I got:
C:\SQLLIB\bnd>db2 "call proc(1)"
SQL1109N  The specified DLL "SYSIBM.SQLPROCEDURECOLS" could not be

I need help generating a sql statement for showing columns and comments
of a table.
Something like:
db2 select columname,comment from dontknow where tablename='table'

I have found some text on HADR / Q replication comparison. Please let
me know if you agree with the accuracy!!
HADR                              DB2 II Q based Replication
-------------------------------------------------------------------

I have query like this..
MERGE  INTO POL_INT_NAME_V A
USING (
    SELECT  DISTINCT(A.INT_NAME_ID),

what are the commands to copy archived logs in disk to TSM? I need them
urgently, i would be thankful for any help
raj

Does anyone know of any good tools for fast, on-line reorgs of a very
large DB2 UDB table?
We need to reorg a couple of our large (+1 billion rows) tables.  We
migrated from V7.2 to V8.1, but we still have type-1 indexes defined on

All:
Anyone had bad experience with doing DECLARE DGTT "WITH REPLACE"
option?
The suggested workaround was to do "DELETE FROM DGTT" sql statement.

All,
Seeing the behaviour below on DB2 v8 on zOS
create table test(intcol integer);
insert into test values (1);

hello friends,
                 I have to develop a script to archive logs to disk
and then use tsm to back them up to tape. can somebody help me with
this?

I've a question regarding backup/restore using
DB2 V8.1.5 on Solaris 2.8 and TSM-API 5.x.
What we have encountered during our testing is that
it seems not to be possible to restore inactivated

In AS/400, have a table that has a character field defined. This has to
be converted to date format of YYYY-MM-DD.
The sample character data is as follows: 02/05/2005.
In UDB, you can do a bind of DB2 utility packages to use ISO, USA or

I have taken a table snapshot, and noticed two tables with high
overflows. What should be done, if any.
Table Schema        = CASTING
Table Name          = ABC

Is there any way in DB2 to get the exact command.
I have an event monitor I created for statments, and all the statment
values are filled with a question mark.
I was using this at another site (different application too) and the