datori

Database administration for fun and profit

Simulating a logon trigger in DB2 LUW 9.7 and later

Here’s a nice post by Serge Rielau on how to implement a “logon trigger” in DB2 LUW 9.7 and later using a stored procedure and the CONNECT_PROC database configuration parameter.

The CONNECT_PROC parameter is one of those obscure but very useful features that I wish more people knew about.

Leave a Reply

Your email address will not be published. Required fields are marked *