By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,389 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

DDL Triggers

P: n/a
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
Aug 28 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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
Aug 28 '06 #2

P: n/a
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

Aug 29 '06 #3

P: n/a
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

Aug 29 '06 #4

P: n/a
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.
Aug 29 '06 #5

P: n/a
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/
Aug 29 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.