2956025 - DB6: SQL1224N when MAX_LOG reached

Symptom

An application may receive SQL1224N when there are following errors in the db2diag.log:

MESSAGE : ADM1542W Application "disp+work" with application handle
"xxx.xxx.xxx.xxx.33222.200612072820" and application id "SAPxxx "
executing under authentication id "40" will be forced off of the
database for violating database configuration parameter MAX_LOG
(current value ""). The unit of work will be rolled back.

The same error can be reported for a violation of the NUM_LOG_SPAN parameter.

Environment

IBM Db2 on Linux, Unix, and Windows

Keywords

MAX_LOG, SQL1224N, ADM1542W, NUM_LOG_SPAN , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.