FP3: Application environments can be customized during the connection process

Starting in DB2® Version 9.7 Fix Pack 3, a procedure can be used to customize an application environment to a database from a central point of control.

The new CONNECT_PROC database configuration parameter is used to input the procedure name. This database configuration parameter accepts a two part procedure name. The procedure is executed implicitly by the DB2 server at the end of the connection process in order to customize a connection.

By using the connect procedure, you can now set special registers such as CURRENT_PATH, CURRENT_SCHEMA, and CURRENT LOCALE LC_TIME, as well as global variables without changing the application.