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.