DB2 Version 9.7 for Linux, UNIX, and Windows

userexit - User exit enable configuration parameter

This parameter has been deprecated since Version 9.5, but is still being used by pre-Version 9.5 data servers and clients. Any value specified for this configuration parameter will be ignored by the database manager in DB2® Version 9.5 or later releases. Starting in Version 9.5, the logarchmeth1 configuration parameter is used to set the USEREXIT value.

Note: The following information applies only to pre-Version 9.5 data servers and clients.

If this parameter is enabled, log retention logging is performed regardless of how the logretain parameter is set. This parameter also indicates that a user exit program should be used to archive and retrieve the log files.

Configuration type: Database
Parameter type: Configurable
Default [range]: Off [On; Off]

Log files are archived when the log file is full. They are retrieved when the ROLLFORWARD utility needs to use them to restore a database.

After logretain, or userexit, or both of these parameters are enabled, you must make a full backup of the database. This state is indicated by the backup_pending flag parameter.

If both of these parameters are de-selected, rollforward recovery becomes unavailable for the database because logs will no longer be retained. In this case, the database manager deletes all log files in the logpath directory (including online archive log files), allocates new active log files, and reverts to circular logging.