Appendix F. Tables used in Q replication scenarios 809
, PART 46 USING STOGROUP ITSOASTG
PRIQTY 230
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 47 USING STOGROUP ITSOASTG
PRIQTY 187
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 48 USING STOGROUP ITSOASTG
PRIQTY 180
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 49 USING STOGROUP ITSOASTG
PRIQTY 180
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 50 USING STOGROUP ITSOASTG
PRIQTY 165
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 51 USING STOGROUP ITSOASTG
PRIQTY 165
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 52 USING STOGROUP ITSOASTG
PRIQTY 316
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 53 USING STOGROUP ITSOASTG
PRIQTY 223
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 54 USING STOGROUP ITSOASTG
PRIQTY 180
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 55 USING STOGROUP ITSOASTG
PRIQTY 201
SECQTY 108
PCTFREE 20
810 WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios
COMPRESS YES
, PART 56 USING STOGROUP ITSOASTG
PRIQTY 187
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 57 USING STOGROUP ITSOASTG
PRIQTY 208
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 58 USING STOGROUP ITSOASTG
PRIQTY 187
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 59 USING STOGROUP ITSOASTG
PRIQTY 316
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 60 USING STOGROUP ITSOASTG
PRIQTY 237
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 61 USING STOGROUP ITSOASTG
PRIQTY 187
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 62 USING STOGROUP ITSOASTG
PRIQTY 187
SECQTY 108
PCTFREE 20
COMPRESS YES
, PART 63 USING STOGROUP ITSOASTG
PRIQTY 172
SECQTY 108
PCTFREE 20
COMPRESS YES
)
BUFFERPOOL BP1
LOCKSIZE PAGE
CLOSE NO
MAXROWS 255
CCSID EBCDIC
;
SET CURRENT SQLID = 'QREPADM';
Appendix F. Tables used in Q replication scenarios 811
CREATE TABLESPACE ITTSTTA IN ITSTRDB1
NUMPARTS 3
( PART 1 USING STOGROUP ITSOASTG
PRIQTY 475
SECQTY 252
PCTFREE 25
COMPRESS YES
, PART 2 USING STOGROUP ITSOASTG
PRIQTY 367
SECQTY 216
PCTFREE 25
COMPRESS YES
, PART 3 USING STOGROUP ITSOASTG
PRIQTY 324
SECQTY 180
PCTFREE 25
COMPRESS YES
)
BUFFERPOOL BP1
LOCKSIZE PAGE
CLOSE NO
MAXROWS 255
CCSID EBCDIC
;
SET CURRENT SQLID = 'QREPADM';
CREATE TABLESPACE ITTSIMT IN ITSTRDB2
NUMPARTS 18
( PART 1 USING STOGROUP ITSOASTG
PRIQTY 302
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 2 USING STOGROUP ITSOASTG
PRIQTY 453
SECQTY 252
PCTFREE 20
COMPRESS YES
, PART 3 USING STOGROUP ITSOASTG
PRIQTY 396
SECQTY 216
PCTFREE 20
COMPRESS YES
, PART 4 USING STOGROUP ITSOASTG
PRIQTY 324
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 5 USING STOGROUP ITSOASTG
PRIQTY 360
812 WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 6 USING STOGROUP ITSOASTG
PRIQTY 252
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 7 USING STOGROUP ITSOASTG
PRIQTY 295
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 8 USING STOGROUP ITSOASTG
PRIQTY 273
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 9 USING STOGROUP ITSOASTG
PRIQTY 338
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 10 USING STOGROUP ITSOASTG
PRIQTY 259
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 11 USING STOGROUP ITSOASTG
PRIQTY 280
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 12 USING STOGROUP ITSOASTG
PRIQTY 280
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 13 USING STOGROUP ITSOASTG
PRIQTY 302
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 14 USING STOGROUP ITSOASTG
PRIQTY 223
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 15 USING STOGROUP ITSOASTG
Appendix F. Tables used in Q replication scenarios 813
PRIQTY 302
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 16 USING STOGROUP ITSOASTG
PRIQTY 252
SECQTY 144
PCTFREE 20
COMPRESS YES
, PART 17 USING STOGROUP ITSOASTG
PRIQTY 309
SECQTY 180
PCTFREE 20
COMPRESS YES
, PART 18 USING STOGROUP ITSOASTG
PRIQTY 136
SECQTY 72
PCTFREE 20
COMPRESS YES
)
BUFFERPOOL BP1
LOCKSIZE PAGE
CLOSE NO
MAXROWS 255
CCSID EBCDIC
;
SET CURRENT SQLID = 'QREPADM';
CREATE TABLESPACE ITTSSJE IN ITSTRDB8
NUMPARTS 18
( PART 1 USING STOGROUP ITSOASTG
PRIQTY 712
SECQTY 360
PCTFREE 15
COMPRESS YES
, PART 2 USING STOGROUP ITSOASTG
PRIQTY 1000
SECQTY 504
PCTFREE 15
COMPRESS YES
, PART 3 USING STOGROUP ITSOASTG
PRIQTY 900
SECQTY 468
PCTFREE 15
COMPRESS YES
, PART 4 USING STOGROUP ITSOASTG
PRIQTY 655
SECQTY 360
PCTFREE 15
COMPRESS YES

Get WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.