This is the DDL that compass generated: create table index_discovery (name_ varchar(50) , value_ blob(500000 K) , size_ integer , lf_ timestamp , deleted_ smallint, primary key (name_) ) I had to alter the SQL to work with the db as follows (there were two problems I found, name_ wasn't specified to be 'not null' even though it was the primary key and our instance of db2 choked on blob(500000 K)): create table index_discovery (name_ varchar(50) not null, value_ blob(500000000) , size_ integer , lf_ timestamp , deleted_ smallint, primary key (name_) ) Checking through the DB2 documentation, the 500000 K seems like correct syntax but it didn't like that.