Can anyone please provide some assistance with a trigger that I need to
develop.  Here is the situation:

Our program updates depend on database updates.  If a client receives
the program update and the database hasn't been updated then it's a
huge mess.  No problem right?  Just document the changes to the
database that you made and then send out a SQL script that will update
the database with the program update right?

Well, I don't trust anyone here to document anything, so I wanted to
automate the tracking of the changes made to the database.  So, I want
to create a table that stores changes made to any part of the database
(create table, drop table, rename table, create column, drop column,
column reorder, change column data type/length/precision).

I am very new to triggers and do not know all I need to know about them
to create what I want so that's why I need someone's help.

(I do not know if DB2 tracks changes somewhere, only place I would know
where to look is on a INSERT,UPDATE,or DELETE from the SYSIBM.SYSTABLES
and SYSIBM.SYSCOLUMNS and SYSIBM.SYSCOLPROPERTIES and SYSIBM.SYSOPTIONS
and SYSIBM.SYSCONSTDEP)

What I need is a trigger that will work one of two ways, if a change
was made to the database then the trigger would either:

1) write a line of text to a txt file or xml file explaining the change
or
2) insert a record into a table that I create so that I can select from
it to view the changes.

Is there an easier way of doing this?

Thanks,
Keith Culpepper
McAleer Solutions