I have SQL ...
    select     A.UNITCOMMON_ID,
            A.POLICY_ID,
            A.LOGICAL_ENTITY_ID,

Start up db2 8.2 as "db2 -td@"
and execute the following command :
CREATE OR REPLACE TRIGGER "BZ".ALERT_CREATED_DATE
BEFORE INSERT ON TS_ALERTS REFERENCING OLD AS OLD NEW AS NEW

         We have a table(say A) with one clob column . Some data from
this table needs to be archived from time to time . My question is if i
use :
insert into archive_table select * from A where <condition> ;

Machine : AIX 5.2
Product : UDB DB2 Release 8.1 FP4a
I have problem loading data into destination table. The data file is
huge with more than 6 Million records. This what i have done

I'm trying to move db2 data from a windows to a linux machine. I am a
newbie though, I have to work with db2 for a benchmarking project in
college.
I figured out i need db2move to change platforms, and i succesfully

Is there a tool or view to display the status of a Load utility job on
windows or Unix(say loading few million rows into a table)? I
understand in OS/390 there is a dis utility to show the status of the
utility. Is it also possible in UDB? I'm using UDB 8.1 on windows 2000.

I have a issue in federated database.
I will explain the scenario
I have a table T1 in database called offlinedb. It has one column F1
I have an another table T2 in database uatdb.

Hi team we have DB2 7.2 Server on Win 2000 mechine.
I am getting a dialog box on the Server
db2 db2syscs.exe - Application Error
The Instruction at "0x6c8008ea" referenced memory at "00720b3807". The

Very interesting for me
  [...]
  Lock Manager Heap is of size 16809984 bytes
  Database Heap is of size 9273344 bytes

After restoring my database I have some problems with diag.log who
becomes very large. The "logretain" and "userexit" are set to
"recovery" and "on" respectively.
Any suggestions are welcome...

Not feeling especially sharp tonight, I couldn't find the reference to
this:
given:
select * from table where name = 'text'

I have a problem to resolve: I wrote a Perlscript which caches data from a
server (local on my machine) I would like to have a other connection to a
remote server but I don't know how to define the servername / hostname in
my Perl Progrem..

         I have to create a procedure which has a cursor declared
inside as  :
Declare c_1 cursor for select name,dept,sal,desig from employee where
join_date  < ( current timestamp - 100 days);

I am using UDB v 8.1 on win2000.
I have setup the ODBC datasources.
My application is connecting to the database and performing DML activities.
But I am getting the following error

DB2 UDB v8.1.5 on Windows
I want to grant some system function to user
DB2 GRANT EXECUTE ON FUNCTION "SYSPROC".SNAPSHOT_DATABASE(INTEGER,VARCHAR()) TO
USER