(Informix) sysdbopen() procedure example -- Posted by inturi on Wednesday, February 27 2008
CREATE PROCEDURE public.sysdbopen() set lock mode to wait 30; END PROCEDURE;

This procedure gets executed whenever any user connects to the database.

Using the above exmaple, DBA can force "lock mode to wait" behavior for all user sessions without modifying client applications.

Owner for the sysdbopen()dictates for which user sessions to execute this procedure. 'public' means execute this procedure for all user sessions.