Runtime tools : Core components : CHA : Reference : Default createCHATables.ddl contents
  
Default createCHATables.ddl contents
The following is the content of createCHATables.ddl file provided by the toolkit for DB2:
CREATE TABLE CHAINSTANCE
(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 AAA 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);
You can define the length of the Context field in the CHAInstance table according to your business need.
Go up to
Reference