I've been recently trying to set up a replicated environment. The
problem is my database has over 500 tables (complicated business
domain), with many foreign keys. At first I had problems with
performing full refreshes of the tables (initial step taken by apply) -

DB2 8.1.3, Windows
Is there any method to find the routines dependant on any particular
routine.
Say,  I have a stored procedure PROC1 which calls 2 stored procedures and

 I wrote last week about a trigger problem I was having. I want a trigger to
produce a unique id to be used as a primary key for my table. I used the
advice I received, but the trigger is still not working correctly. Here is my
code:

Two part question, PLEASE DO NOT IGNORE THE FIRST PART
ENVIRONMENT = DB2 ESE non-DPF 8.1 FP5 on AIX 5.x
==========
QUESTION 1

I created tables without using the 'INDEX in tablespace' statement.
I want to add indexes on these tables.
How can I mention as to which tablespace the indexes should use?
Thanks.

Hi Gurus,
I am using DB2 UDB 8.2.I want to load/insert images into DB2
database.So I found out we need to enable DB2 Image extender .How to
enable that extender? Please tell the complete process to enable that

We are going to build a DB2 server on a new P570 server for a data
warehouse project. Since the size of the data warehouse is less than
200G, the DB2 server is only assigned 5/10th shared CPU.  In this case,
how many DB2 license we should purchase, also how many CPU should be

     Appreciate if someone can clarify if database Share Memory Limit
(2 GB ) in Unix  32 bit boxes is the top limit for all the databases
put together in a database or is it for each of the database in an
Instance

Hai every one...
                          I was trying List history backup
cmd.......... the output i got is
                   List History File for first

To DB2 Personal Developer Edition GIS users:
How do I acquire a spatial extender license key for the DB2 PDE?  I
expected to be able to use it right out of the box.
Brad

Is it required that the Db2 DAS [db2dasstm.exe ] should be up & running
in the production DB2 instances?
In our production server, this procesess occupies more cpu resource. So
thought of shutting down this process.

I need to write a query that returns the names of all queries in a
library that start with the letters SC.  I have not a clue how to even
start something like this.  If possible, the boss would like this done
is QRY/400.

Linux V8 FP12 with a 64 bit instance.
My DBA called me and said our instance crashed and recovery would never
end.
[db2inst1@autprd04 db2dump]$ db2 list utilities show detail

I have a DB2 instance running in WINTEL platform. The MON_HEAP_SZ set
is 66. Now we received 'ADM2004E" error and as per the soln for this
error, requested to increase to 200.
So can I know what can be impact on DB2 if I increase the heap sz to

sort of a newbie question, but anyways i cant connect to a databas
because i cant start the db2admin server. running db2 v8 on winxp
basically when i do "db2admin start" it gives me SQL4412N error, logo
user account is invalid. if i attempt to "create /user:use