Troubleshooting
Problem
The DB2 Transaction log (logfilsiz) value of the database will need to be increased if you encounter a transaction log full message, SQL0964C in the db2cli.log.
Symptom
SQL0964C error shows up under two conditions.
a. During data load using an ldif file which contains large entries, e.g.: entries with blob attributes or group entries with lots of members.
b. During the normal ldap server functionality with ldapadd working with large entries
The db2cli.log shows the following:
a. During data load using an ldif file which contains large entries, e.g.: entries with blob attributes or group entries with lots of members.
b. During the normal ldap server functionality with ldapadd working with large entries
The db2cli.log shows the following:
SQL0964C The transaction log for the database is full. SQLSTATE=57011
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7NB","label":"IBM Security Verify Directory"},"ARM Category":[{"code":"a8m0z0000001hpoAAA","label":"Administration"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"and future releases;10.0.0;10.0.1;10.0.2;10.0.3;10.0.4"},{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVJJU","label":"IBM Security Directory Server"},"ARM Category":[{"code":"a8m0z0000001hpoAAA","label":"Administration"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.3.1;6.4"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
WI XX001148
PMR 37340 500 000
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21121437