create table J2EE_CONFIG (
	"CID" bigint not null,
	"PARENTCID" bigint,
	"PATHPREFIX" vargraphic(127) CCSID 13488,
	"CPATH" vargraphic(300) CCSID 13488,
	"PATHHASH" integer,
	"CACHEMODE" integer,
	"CTYPE" integer,
	"LINKEDCPATH" vargraphic(300) CCSID 13488,
	primary key (CID)
);
create unique index J2EE_CONFIG_I0 on J2EE_CONFIG(CPATH);
create index J2EE_CONFIG_I1 on J2EE_CONFIG(PATHPREFIX);
create index J2EE_CONFIG_I2 on J2EE_CONFIG(PATHHASH);
create index J2EE_CONFIG_I3 on J2EE_CONFIG(PARENTCID);
create index J2EE_CONFIG_I4 on J2EE_CONFIG(CTYPE);
create table J2EE_CONFIGENTRY(
	"CID" bigint not null,
	"NAMEHASH" integer not null,
	"ISFILE" smallint not null,
	"NAME" vargraphic(256) CCSID 13488,
	"DTYPE" bigint,
	"VBIGINT" bigint,
	"VDOUBLE" double,
	"VSTR" vargraphic(2000) CCSID 13488,
	"VBYTES" varchar(2000) FOR BIT DATA,
	"FBLOB" blob(2G)
);
create index J2EE_CFGENTRY_I0 on J2EE_CONFIGENTRY(CID, NAMEHASH, ISFILE);
create table J2EE_KEYSEQUENCE (
	"SEQUENCE_ID" integer not null,
	"INC_VALUE" bigint,
	primary key (SEQUENCE_ID)
);