|
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) |
