SET CURRENT SQLID = 'S100447';
CREATE TABLESPACE CHEROCL0 IN DB2MAPP
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CCSID EBCDIC
MAXROWS 255
CLOSE YES
SEGSIZE 64
;
CREATE TABLE S100447.CHEROCL0
("TYPE" CHAR(1) NOT NULL ,
SOURCE_RID CHAR(5) NOT NULL ,
TARGET_XRID CHAR(9) NOT NULL WITH DEFAULT,
LRSN CHAR(6) NOT NULL )
IN DB2MAPP.CHEROCL0
AUDIT NONE
CCSID EBCDIC
;
CREATE UNIQUE INDEX S100447.IX_CHEROCL0
ON S100447.CHEROCL0
( SOURCE_RID ASC ,
"TYPE" ASC ,
TARGET_XRID ASC ,
LRSN ASC )
USING STOGROUP GSMS
PRIQTY 720
SECQTY 14400
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
COMMIT
;
CREATE TABLESPACE CHEROCLT IN DB2MAPP
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CCSID EBCDIC
MAXROWS 255
CLOSE YES
SEGSIZE 64
;
CREATE TABLE S100447.CHEROCLT
("TYPE" CHAR(1) NOT NULL ,
SOURCE_RID CHAR(5) NOT NULL ,
TARGET_XRID CHAR(9) NOT NULL WITH DEFAULT,
LRSN CHAR(6) NOT NULL )
IN DB2MAPP.CHEROCLT
AUDIT NONE
CCSID EBCDIC
;
CREATE UNIQUE INDEX S100447.IX_CHEROCLT
ON S100447.CHEROCLT
( SOURCE_RID ASC ,
"TYPE" ASC ,
TARGET_XRID ASC ,
LRSN ASC )
USING STOGROUP GSMS
PRIQTY 720
SECQTY 14400
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
COMMIT
;
CREATE TABLESPACE CHEROCLS IN DB2MAPP
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CCSID EBCDIC
MAXROWS 255
CLOSE YES
SEGSIZE 64
;
CREATE TABLE S100447.CHEROCLS
("TYPE" CHAR(1) NOT NULL ,
SOURCE_RID CHAR(5) NOT NULL ,
TARGET_XRID CHAR(9) NOT NULL WITH DEFAULT,
LRSN CHAR(6) NOT NULL )
IN DB2MAPP.CHEROCLS
AUDIT NONE
CCSID EBCDIC
;
CREATE UNIQUE INDEX S100447.IX_CHEROCLS
ON S100447.CHEROCLS
( SOURCE_RID ASC ,
"TYPE" ASC ,
TARGET_XRID ASC ,
LRSN ASC )
USING STOGROUP GSMS
PRIQTY 720
SECQTY 14400
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
COMMIT
;
CREATE TABLESPACE CHEROCLY IN DB2MAPP
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CCSID EBCDIC
MAXROWS 255
CLOSE YES
SEGSIZE 64
;
CREATE TABLE S100447.CHEROCLY
("TYPE" CHAR(1) NOT NULL ,
SOURCE_RID CHAR(5) NOT NULL ,
TARGET_XRID CHAR(9) NOT NULL WITH DEFAULT,
LRSN CHAR(6) NOT NULL )
IN DB2MAPP.CHEROCLY
AUDIT NONE
CCSID EBCDIC
;
CREATE UNIQUE INDEX S100447.IX_CHEROCLY
ON S100447.CHEROCLY
( SOURCE_RID ASC ,
"TYPE" ASC ,
TARGET_XRID ASC ,
LRSN ASC )
USING STOGROUP GSMS
PRIQTY 720
SECQTY 14400
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
COMMIT
;
CREATE TABLESPACE CHEROCLZ IN DB2MAPP
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CCSID EBCDIC
MAXROWS 255
CLOSE YES
SEGSIZE 64
;
CREATE TABLE S100447.CHEROCLZ
("TYPE" CHAR(1) NOT NULL ,
SOURCE_RID CHAR(5) NOT NULL ,
TARGET_XRID CHAR(9) NOT NULL WITH DEFAULT,
LRSN CHAR(6) NOT NULL )
IN DB2MAPP.CHEROCLZ
AUDIT NONE
CCSID EBCDIC
;
CREATE UNIQUE INDEX S100447.IX_CHEROCLZ
ON S100447.CHEROCLZ
( SOURCE_RID ASC ,
"TYPE" ASC ,
TARGET_XRID ASC ,
LRSN ASC )
USING STOGROUP GSMS
PRIQTY 720
SECQTY 14400
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
COMMIT
;