---------------------------------------------
-- DDL Statements for Table "DB2INST1"."FRAGMENTS"
------------------------------------------------
 

CREATE TABLE "DB2INST1"."FRAGMENTS"  (
		  "FRGMNT_ID" BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (  
		    START WITH +1  
		    INCREMENT BY +1  
		    MINVALUE +1  
		    MAXVALUE +9223372036854775807  
		    NO CYCLE  
		    CACHE 20  
		    NO ORDER ) , 
		  "ATTACH_ID" BIGINT , 
		  "SEQ_NUM" SMALLINT NOT NULL , 
		  "OFFSET" INTEGER NOT NULL , 
		  "FRGMNT_SIZE" INTEGER NOT NULL , 
		  "DATA" BLOB(104857600) NOT LOGGED COMPACT , 
		  "ARCH_MSG_ID" BIGINT )   
		 IN "USERSPACE1" ; 


-- DDL Statements for Primary Key on Table "DB2INST1"."FRAGMENTS"

ALTER TABLE "DB2INST1"."FRAGMENTS" 
	ADD PRIMARY KEY
		("FRGMNT_ID");



-- DDL Statements for Indexes on Table "DB2INST1"."FRAGMENTS"

CREATE INDEX "DB2INST1"."ATT_IDX" ON "DB2INST1"."FRAGMENTS" 
		("ATTACH_ID" ASC)
		PCTFREE 10 MINPCTUSED 10

		COMPRESS NO ALLOW REVERSE SCANS;

-- DDL Statements for Indexes on Table "DB2INST1"."FRAGMENTS"

CREATE INDEX "DB2INST1"."ATT_SEQ_IDX" ON "DB2INST1"."FRAGMENTS" 
		("SEQ_NUM" ASC,
		 "ATTACH_ID" ASC)
		PCTFREE 10 MINPCTUSED 10

		COMPRESS NO ALLOW REVERSE SCANS;

-- DDL Statements for Indexes on Table "DB2INST1"."FRAGMENTS"

CREATE INDEX "DB2INST1"."SEQ_O_IDX" ON "DB2INST1"."FRAGMENTS" 
		("SEQ_NUM" ASC)
		PCTFREE 10 MINPCTUSED 10

		COMPRESS NO ALLOW REVERSE SCANS;

-- DDL Statements for Foreign Keys on Table "DB2INST1"."FRAGMENTS"

ALTER TABLE "DB2INST1"."FRAGMENTS" 
	ADD CONSTRAINT "CC1206717424234" FOREIGN KEY
		("ARCH_MSG_ID")
	REFERENCES "DB2INST1"."ARCH_MESSAGES"
		("ARCH_MSG_ID")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

ALTER TABLE "DB2INST1"."FRAGMENTS" 
	ADD CONSTRAINT "FRAG_ATCH_FK" FOREIGN KEY
		("ATTACH_ID")
	REFERENCES "DB2INST1"."ATTACHS"
		("ATTACH_ID")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

ALTER TABLE FRAGMENTS ALTER COLUMN OFFSET SET DATA TYPE BIGINT