The following is the content of createCHATables.ddl file provided by the toolkit for DB2(R) :
CREATE TABLE CHAINSTANCE (DISCRIM_CHAINSTANCE VARCHAR(32) NOT NULL, INSTANCEID VARCHAR(250) NOT NULL, NAME VARCHAR(250), PARENTID VARCHAR(250), ISROOT SMALLINT NOT NULL, CONTEXT BLOB(1000000), TYPENAME VARCHAR(250)); ALTER TABLE CHAINSTANCE ADD CONSTRAINT PK_CHAINSTANCE PRIMARY KEY (INSTANCEID); CREATE INDEX pidx ON CHAINSTANCE(PARENTID); CREATE TABLE CHACONTROL (NUM INTEGER NOT NULL, INSTIDPREFIX INTEGER, HASCTXTREE SMALLINT NOT NULL); ALTER TABLE CHACONTROL ADD CONSTRAINT PK_CHACONTROL PRIMARY KEY (NUM); CREATE TABLE CHACHILDREN (CHILDINSTANCEID VARCHAR(250) NOT NULL, INSTANCEID VARCHAR(250)); ALTER TABLE CHACHILDREN ADD CONSTRAINT PK_CHACHILDREN PRIMARY KEY (CHILDINSTANCEID);
You can define the length of the Context field in the CHAInstance table according to your business need.