Default createCHATables.ddl contents

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.