-355   A LOB COLUMN IS TOO LARGE TO BE LOGGED

Explanation

One of the following has occurred:
  • 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
  • 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 characters

System action

The statement cannot be processed.

Programmer response

Either change the attribute of the LOB table space to LOG NO or drop the base table, and re-create it with columns of an acceptable length for logging.

SQLSTATE

42993