DB21034E - Alter Table problem

Red Hat Linux DB2 8.2

Enterprise Server Edition

db2 'ALTER TABLE APPL_LOG ALTER COLUMN DETAIL SET DATA TYPE VARCHAR(30000)'

this returned a error message : DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0670N The row length of the table exceeded a limit of "4005" bytes. (Table space "USERSPACE1".) SQLSTATE=54010 The normal solution would be to expand the Tablespace. Given the allocations already on this server this would be problematic. Given that the data length for this column was potentially large , a CLOB was appropriate . It has got disadvantages related to the way it can be maniipulated in sql statements Initially I needed to view the table definition , this was done through "db2 list tablespaces show detail" There was no data in the table , therefore there was no requirement to export the data . The following statement recreated the table

CREATE TABLE "MyDB"."MY_TABLE" ( "LOG_DATE" TIMESTAMP , "SERVER_NAME" VARCHAR(16) , "SYSTEM" VARCHAR(16) , "APPLICATION_CODE" VARCHAR(16) , "SEVERITY" VARCHAR(16) , "LOGGER_NAME" VARCHAR(128) , "MESSAGE" VARCHAR(512) , "DETAIL" CLOB , "UNIQUE_ID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) ) IN "USERSPACE1" ;

 Ref:Jack Vamvas(http://www.dba-db2.com)