DB2 - Problem description
Problem IT36467 | Status: Closed |
A TRUNCATE TABLE STATEMENT ON A COLUMN ORGANIZED TABLE WITH LOBSMAY RETURN SQLCODE -964 (TRANSACTION LOG IS FULL). | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
A TRUNCATE TABLE statement on a column organized table may fail with SQLCODE -964 (transaction log is full) message if the table contains LOB Columns (CLOB, BLOB, or DBCLOB). The db2diag.log may contain a message similar to the following. 2021-03-11-11.27.04.920299+000 I14822384E656 LEVEL: Error PID : 5212 TID : 139790443865856 PROC : db2sysc 8 INSTANCE: myinst NODE : 008 DB : MYDB APPHDL : 0-41506 APPID: 00.00.000.000.00000 UOWID : 4 ACTID: 86 AUTHID : MYID HOSTNAME: server1 EDUID : 69191 EDUNAME: db2agntcol (MYDB) 8 FUNCTION: DB2 UDB, data protection services, sqlpWriteLR, probe:6680 MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE "Log File has reached its saturation point" DIA8309C Log file was full. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.04.2021 10.06.2021 10.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |