I am consulting on an application which was specifically written with DB2 and
Rexx in mind. The application architecture (C/C++) is responsible for the
connection to the database, and as the C/C++ code is written to the db2api.dll,
and IBM's DB2 Rexx driver uses the same API path ...

How are TYPE1 Indexes Created. All the indexes which i am creating are
TYPE2 . This might because i am using V9, but how are TYPE1 and TYPE2
indexes are created earlier and in what cases? Do they use any Keyword
in the CREATE INDEX statement.

I'm using DB2 Express on XP. (See version details below).
I'm trying to get LOCK TABLE working. Hypothetically I have two
processes on separate machines and I have a table called "locktable".
Each process will try to lock that table, do some operation and then

Hi NG,
I have a little hardtime to figure out what the numbers above the arrows
in visual explain means. Ie. the query:
select * from consignee where cid in (1,2)

We need to allow the customer to customize the database by adding
custom attributes to some of the entities in the database (i.e. we
have a tables like UserGroup, Component etc, each having a set of core
attributes, and the user must be able to extend this by defining its

I'm getting this message on my Standby server, and it seems to be the
cause more alerts we are getting from HADR. Lately we are getting alot
more REM_CATCHUP and LOCAL_CATCHUP
2009-01-24-02.25.37.575001   Instance:INST1   Node:000

Hi Knut, Sergei and other IBM guys in the group,
Although I could get the status of tablespaces and views through
scripts, I would rather to have them in the control center gui. One
stop shop type of thing.

     As many applications are failing in our ENV with SQL0911N error
(mainly because of LOCKTIMEOUT "68"). Is there any log files where
these error codes are recorded. I wanted to make a script that as soon
as this error comes, i get a notification mail.

I'm trying to run db2pd in a script started by windows task scheduler.
I've tried a script file containing
db2cmd -c db2pd -hadr -db SAMPLE > C:\1\HADR.txt
and variations, but I either get an empty txt file or one

We have v 8 fp12 on windows mscs, and wish to upgrade to fp15
or higher. If we upgrade, then hit showstopping problems, how do
we revert back to fp12?
TIA,

Ok W2K DB2 v8.1 fix pack 5.
On production I took a an online backup of production and copied it
over to my staging environment.
restored the production database on top of staging database redirect.

I have several jobs merging into a table.   If the jobs run at
different times, it works well.  However, if any two of them run at
the same time, I got a dupe insert error SQL0803N on the primary key.
Is there a better way to avoid the problem than not letting the jobs

Let us consider I have a table
t ( A, B, C )  with values
a, b, c
d ,e, f

1) Is there any tool to identify the data model of the selected tables
in db2 ?
2) Is it possible to refer tables from 2 different databases at the
same time in a query ?

I try to execute following query:
update UNIT.TVMO_EINMALIGE_BUCHUNG
set
DAT_ABRSALDO_VERARBEITUNG = timestamp(cast((DAT_ABRECHNUNG_GEPLANT + 1 month - 1 days) as char(10)) || ' 00:00:00.000000')