DDL Triggers

[Praveen_db2]

Hi All
Are there DDL triggers in DB2?
By DDL triggers I mean the triggers which can be fired on ALTER, DELETE,
DROP, GRANT and REVOKE commands.
Such triggers are there in Oracle and SQL Server. I was hoping that they
are in DB2 as well. But till now couldn’t find any.

Regards
Praveen

[Knut Stolze]

Praveen_db2 wrote:

Hi All
Are there DDL triggers in DB2?
By DDL triggers I mean the triggers which can be fired on ALTER, DELETE,
DROP, GRANT and REVOKE commands.
Such triggers are there in Oracle and SQL Server. I was hoping that they
are in DB2 as well. But till now couldn’t find any.

There is no such thing in DB2.

I'm curious: what is this used for?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Praveen_db2]

Hi Knut,
I got this information from a oracle dba friend of mine.I think DB2
Governor does similar functionality but trigger seems to be a one time
job.

Use DDL triggers when you want to do the following:
• You want to prevent certain changes to your database schema.
• You want something to occur in the database in response to a change in
your database schema.
• You want to record changes or events in the database schema.

DDL Triggers are supported in Oracle and SQL Server 2005 but not in DB2.
Regards
Praveen

[Praveen_db2]

Hi Knut,
I got this information from a oracle dba friend of mine.I think DB2
Governor does similar functionality but trigger seems to be a one time
job.

Use DDL triggers when you want to do the following:
• You want to prevent certain changes to your database schema.
• You want something to occur in the database in response to a change in
your database schema.
• You want to record changes or events in the database schema.

DDL Triggers are supported in Oracle and SQL Server 2005 but not in DB2.
Regards
Praveen

[Ian]

Praveen_db2 wrote:

Hi Knut,
I got this information from a oracle dba friend of mine.I think DB2
Governor does similar functionality but trigger seems to be a one time
job.

No, the governor does not do this.

Use DDL triggers when you want to do the following:
• You want to prevent certain changes to your database schema.
• You want something to occur in the database in response to a change in
your database schema.
• You want to record changes or events in the database schema.

As Knut said, DDL triggers do not exist in DB2.

[Serge Rielau]

Praveen_db2 wrote:

Hi Knut,
I got this information from a oracle dba friend of mine.I think DB2
Governor does similar functionality but trigger seems to be a one time
job.

Use DDL triggers when you want to do the following:
• You want to prevent certain changes to your database schema.
• You want something to occur in the database in response to a change in
your database schema.
• You want to record changes or events in the database schema.

DDL Triggers are supported in Oracle and SQL Server 2005 but not in DB2.

Praveen,

This looks like "right out of the text book". The question really is:
What do YOU (as a DB2 customer with an existing or new application) need
this feature for?
There are all sorts of features other vendors have DB2 doesn't and the
other way around. Often times features address business scenarios which
can be addressed in different ways just as effectively.
In planning we are customer driven, not competition driven. :-)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/