Session With On_logfull
When the transaction log file fills, the oldest transaction is, by default, aborted to free up log space. The SET SESSION WITH ON_LOGFULL statement can be used to modify this behavior.
The ON_LOGFULL= option takes the following parameters:
COMMIT
Silently (without notification) commits the transaction.
ABORT
Aborts the transaction.
NOTIFY
Commits the transaction and writes notification of the commit to the DBMS log.
ON_LOGFULL can appear any number of times during a transaction, either within or without the scope of the transaction.
When specifying COMMIT or NOTIFY, if a logfull condition occurs, the multi-row update can be partially committed. For example, using the following syntax commits the rows deleted from table_name up to the moment the logfull condition is detected.
[EXEC SQL] SET SESSION WITH ON_LOGFULL = COMMIT;
[EXEC SQL] DELETE FROM table_name;
If the transaction is aborted after the commit point, only the post-commit updates are rolled back.