Bookshelf v7.5: Altering the Objects

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Optimizing Performance with Buffer Pools > Master Worksheet >

Altering the Objects

Alter the objects to correspond to the newly defined buffer pool settings.

Because the table space object names might not correspond to the table space in your environment, check these to make sure they are accurate. The following index examples relate to Siebel Financial Services.

S_ADDR_ORG

ALTER TABLESPACE SIEB0008.AAAA489 BUFFERPOOL BP40;

ALTER INDEX SIEBTO.S_ADDR_ORG_EI BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_F1 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_II BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_M1 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_M2 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_M3 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_M4 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_M5 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_M6 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_P1 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_P99 BUFFERPOOL BP41;

ALTER INDEX SIEBTO.S_ADDR_ORG_U1 BUFFERPOOL BP41;

S_ADDR_PER

ALTER TABLESPACE SIEB0008.AAAA494 BUFFERPOOL BP42;

ALTER INDEX SIEBTO.S_ADDR_PER_EI BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_F50 BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_II BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_M1 BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_M2 BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_M3 BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_M4 BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_M5 BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_P1 BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_P99 BUFFERPOOL BP43;

ALTER INDEX SIEBTO.S_ADDR_PER_U1 BUFFERPOOL BP43;

S_ASSET

ALTER TABLESPACE SIEB0008.AAAA585 BUFFERPOOL BP44;

ALTER INDEX SIEBTO.S_ASSET_F10 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F11 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F12 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F13 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F14 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F2 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F4 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F5 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F50 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F51 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F52 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F53 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F54 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F6 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F7 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F8 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_F9 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_II BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M1 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M2 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M3 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M4 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M5 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M50 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M51 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M52 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M53 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_M54 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_P1 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_P99 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_U1 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_U2 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_U3 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_U51 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_V1 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_V3 BUFFERPOOL BP45;

ALTER INDEX SIEBTO.S_ASSET_V50 BUFFERPOOL BP45;

S_CONTACT

ALTER TABLESPACE SIEB0012.BBBB826 BUFFERPOOL BP16K0;

ALTER INDEX SIEBTO.S_CONTACT_F1 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F10 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F11 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F12 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F13 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F15 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F2 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F3 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F4 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F5 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F50 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F51 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F52 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_F7 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_II BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M1 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M12 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M18 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M19 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M2 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M20 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M21 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M22 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M3 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M4 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M50 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M51 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M6 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_M8 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_P1 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_U2 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_V1 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_V2 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_V3 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_V5 BUFFERPOOL BP10;

ALTER INDEX SIEBTO.S_CONTACT_EI BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_F6 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M11 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M13 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M14 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M15 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M16 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M17 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M52 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M53 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M55 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M56 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M57 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M58 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_M9 BUFFERPOOL BP30;

ALTER INDEX SIEBTO.S_CONTACT_U1 BUFFERPOOL BP30;

S_DEFECT_PRDINT

ALTER TABLESPACE SIEB0006.AAAA1053 BUFFERPOOL BP46;

ALTER INDEX SIEBTO.S_DEFECT_PRDINT_U1 BUFFERPOOL BP47;

ALTER INDEX SIEBTO.S_DEFECT_PRDINT_P1 BUFFERPOOL BP47;

ALTER INDEX SIEBTO.S_DEFECT_PRDINT_F1 BUFFERPOOL BP47;

S_EVT_ACT

ALTER TABLESPACE SIEB0009.BBBB1248 BUFFERPOOL BP16K9;

ALTER INDEX SIEBTO.S_EVT_ACT_F1 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F10 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F11 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F12 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F13 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F14 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F15 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F16 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F17 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F18 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F19 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F2 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F20 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F21 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F22 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F23 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F24 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F25 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F27 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F28 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F29 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F3 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F30 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F31 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F32 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F33 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F34 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F35 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F36 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F37 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F38 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F5 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F50 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F51 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F52 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F53 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F54 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F55 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F56 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F57 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F58 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F59 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F6 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F60 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F61 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F62 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F7 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F8 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_F9 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M1 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M10 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M11 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M2 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M3 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M5 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M50 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M51 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M6 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M7 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M8 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_M9 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_P1 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_P99 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_U1 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_V1 BUFFERPOOL BP39;

ALTER INDEX SIEBTO.S_EVT_ACT_V2 BUFFERPOOL BP39;

S_INS_ITEM

ALTER TABLESPACE SIEB0015.AAAA1513 BUFFERPOOL BP48;

ALTER INDEX SIEBTO.S_INS_ITEM_F1 BUFFERPOOL BP49;

ALTER INDEX SIEBTO.S_INS_ITEM_F3 BUFFERPOOL BP49;

ALTER INDEX SIEBTO.S_INS_ITEM_F4 BUFFERPOOL BP49;

ALTER INDEX SIEBTO.S_INS_ITEM_F5 BUFFERPOOL BP49;

ALTER INDEX SIEBTO.S_INS_ITEM_F50 BUFFERPOOL BP49;

ALTER INDEX SIEBTO.S_INS_ITEM_M1 BUFFERPOOL BP49;

ALTER INDEX SIEBTO.S_INS_ITEM_P1 BUFFERPOOL BP49;

ALTER INDEX SIEBTO.S_INS_ITEM_P99 BUFFERPOOL BP49;

ALTER INDEX SIEBTO.S_INS_ITEM_U1 BUFFERPOOL BP49;

S_OPTY

ALTER TABLESPACE SIEB0010.AAAA1689 BUFFERPOOL BP22;

ALTER INDEX SIEBTO.S_OPTY_F1 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F3 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F4 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F5 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F50 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F51 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F52 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F53 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F54 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F55 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F56 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F57 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F58 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F6 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F7 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_F8 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_II BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M1 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M2 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M3 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M4 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M50 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M51 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M52 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M53 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M54 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M55 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M56 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M57 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M6 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M8 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_M9 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_P1 BUFFERPOOL BP12;

ALTER INDEX SIEBTO.S_OPTY_U1 BUFFERPOOL BP32;

ALTER INDEX SIEBTO.S_OPTY_U2 BUFFERPOOL BP32;

ALTER INDEX SIEBTO.S_OPTY_V1 BUFFERPOOL BP32;

ALTER INDEX SIEBTO.S_OPTY_V2 BUFFERPOOL BP32;

ALTER INDEX SIEBTO.S_OPTY_V3 BUFFERPOOL BP32;

ALTER INDEX SIEBTO.S_OPTY_V4 BUFFERPOOL BP32;

ALTER INDEX SIEBTO.S_OPTY_V5 BUFFERPOOL BP32;

S_OPTY_BU

ALTER TABLESPACE SIEB0006.AAAA1701 BUFFERPOOL BP23;

ALTER INDEX SIEBTO.S_OPTY_BU_M1 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_M2 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_M3 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_M4 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_M5 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_M6 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_M7 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_M8 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_M9 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_P1 BUFFERPOOL BP33;

ALTER INDEX SIEBTO.S_OPTY_BU_U1 BUFFERPOOL BP33;

S_ORG_EXT

ALTER TABLESPACE SIEB0012.BBBB1792 BUFFERPOOL BP16K4;

ALTER INDEX SIEBTO.S_ORG_EXT_F1 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F10 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F11 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F12 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F13 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F14 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F15 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F16 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F17 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F18 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F19 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F2 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F20 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F3 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F4 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F5 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F50 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F51 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F52 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F53 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F54 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F55 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F56 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F57 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F58 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F59 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F6 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F60 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F61 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F62 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F7 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F8 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_F9 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_II BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M1 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M10 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M12 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M13 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M14 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M19 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M3 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M4 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M50 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M51 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M52 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M53 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M6 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M7 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M8 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_P1 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_U3 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V1 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V2 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V3 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V4 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V5 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V6 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V7 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V8 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_V9 BUFFERPOOL BP14;

ALTER INDEX SIEBTO.S_ORG_EXT_M11 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_M15 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_M16 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_M17 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_M2 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_M20 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_M5 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_M9 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_U1 BUFFERPOOL BP34;

ALTER INDEX SIEBTO.S_ORG_EXT_U2 BUFFERPOOL BP34;

S_ORG_GROUP

ALTER TABLESPACE SIEB0012.AAAA1807 BUFFERPOOL BP25;

ALTER INDEX SIEBTO.S_ORG_GROUP_F1 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_F2 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_F50 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_M1 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_M50 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_P1 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_U1 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_U2 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_V1 BUFFERPOOL BP35;

ALTER INDEX SIEBTO.S_ORG_GROUP_V2 BUFFERPOOL BP35;

S_PARTY

ALTER TABLESPACE SIEB0010.AAAA1853 BUFFERPOOL BP26;

ALTER INDEX SIEBTO.S_PARTY_F1 BUFFERPOOL BP16;

ALTER INDEX SIEBTO.S_PARTY_M1 BUFFERPOOL BP16;

ALTER INDEX SIEBTO.S_PARTY_M2 BUFFERPOOL BP16;

ALTER INDEX SIEBTO.S_PARTY_M3 BUFFERPOOL BP16;

ALTER INDEX SIEBTO.S_PARTY_M4 BUFFERPOOL BP16;

ALTER INDEX SIEBTO.S_PARTY_P1 BUFFERPOOL BP16;

ALTER INDEX SIEBTO.S_PARTY_P99 BUFFERPOOL BP16;

ALTER INDEX SIEBTO.S_PARTY_U1 BUFFERPOOL BP36;

S_PROD_INT

ALTER TABLESPACE SIEB0010.AAAA1992 BUFFERPOOL BP27;

ALTER INDEX SIEBTO.S_PROD_INT_F10 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F11 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F12 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F14 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F2 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F3 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F4 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F5 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F50 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F51 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F52 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F53 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F6 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F7 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F8 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_F9 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_II BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M1 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M10 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M11 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M14 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M15 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M16 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M4 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M9 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_P1 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_V1 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_V2 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_V3 BUFFERPOOL BP17;

ALTER INDEX SIEBTO.S_PROD_INT_M12 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M13 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M2 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M3 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M5 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M50 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M51 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M6 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M7 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_M8 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_U1 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_U2 BUFFERPOOL BP37;

ALTER INDEX SIEBTO.S_PROD_INT_U3 BUFFERPOOL BP37;

S_SRV_REQ

ALTER TABLESPACE SIEB0011.BBBB2291 BUFFERPOOL BP16K8;

ALTER INDEX SIEBTO.S_SRV_REQ_F1 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F10 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F12 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F13 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F14 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F15 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F16 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F17 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F18 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F19 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F2 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F20 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F21 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F22 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F23 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F24 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F3 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F4 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F5 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F50 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F51 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F52 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F53 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F54 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F55 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F56 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F57 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F58 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F59 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F6 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F7 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_F9 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M10 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M2 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M3 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M4 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M5 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M50 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M51 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M6 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M9 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_P99 BUFFERPOOL BP18;

ALTER INDEX SIEBTO.S_SRV_REQ_M1 BUFFERPOOL BP38;

ALTER INDEX SIEBTO.S_SRV_REQ_M7 BUFFERPOOL BP38;

ALTER INDEX SIEBTO.S_SRV_REQ_M8 BUFFERPOOL BP38;

ALTER INDEX SIEBTO.S_SRV_REQ_P1 BUFFERPOOL BP38;

ALTER INDEX SIEBTO.S_SRV_REQ_U1 BUFFERPOOL BP38;

ALTER INDEX SIEBTO.S_SRV_REQ_U2 BUFFERPOOL BP38;

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS
Published: 18 April 2003