logo  
Google
 

DB2 SQL-Error: -355

SQLState: 42993

Short Description: A LOB COLUMN IS TOO LARGE TO BE LOGGED

One of the following has occurred: v a CREATE TABLE statement for an auxiliary table stores a BLOB, CLOB or DBCLOB column whose length exceeds 1 gigabyte but whose associated LOB table space was defined with the LOG YES attribute v an ALTER TABLESPACE statement of a LOB table space specifies the LOG YES clause but the auxiliary table in the LOB table space stores a BLOB or CLOB column whose length exceeds 1 gigabyte or a DBCLOB column whose length exceeds 500 megabyte charactersSystem action: The statement cannot be executed. Programmer response: Either change the attribute of the LOB table space to LOG NO or drop the base table, and recreate it with columns of an acceptable length for logging.

 <-  BACK TO INDEX