OmniMessaging Installation Guide 1.7

OmniMessaging Installation Guide
07/22/04 Opsol Integrators Inc. Confidential and Proprietary 37
B
B
.
.
A
A
P
P
P
P
E
E
N
N
D
D
I
I
X
X
:
:
D
D
A
A
T
T
A
A
B
B
A
A
S
S
E
E
P
P
A
A
R
R
T
T
I
I
T
T
I
I
O
O
N
N
I
I
N
N
F
F
O
O
R
R
M
M
A
A
T
T
I
I
O
O
N
N
15 Command to add partitions
ALTER TABLE ==\system.$vol1.subvol.tablename
ADD PARTITION ==\system.$vol2.subvol.tablename
EXTENT ==[for FORMAT1: 2-65535 for FORMAT2: 2-512000000]
== or
EXTENT [PRIMARY,SECONDRY] ==[for FORMAT1: 2-65535 for FORMAT2: 2-
512000000]
MAXEXTENT ==[for OLD SYSTEMS: 16-959 for NEW SYSTEMS: 16-940]
CATALOG ==[catalog name]
== for remote systems
REMOTE CATALOG ==[remote catalog name]
FIRST KEY ==[for integer primary key: maximum value of primary key /no
of partitions for equal distribution of data];
15.1 Keys to use in partitioning
=ACCESS_CONTROL_LIST_TB PRIMARY KEY ( MAILBOX_ID, USER_ID )
=ACCOUNT_BASE PRIMARY KEY ( ACCOUNT_ID )
UNIQUE INDEX =ACCOUNT_I0 ON =ACCOUNT_BASE (PROVISIONING_ID)
INDEX =ACCOUNT_I1 ON =ACCOUNT_BASE (SERVICE_PACKAGE_ID)
VIEW =ACCOUNT_TB AS SELECT * FROM =ACCOUNT_BASE WHERE STATUS <> "d"
=AUTOREPLY_TB PRIMARY KEY ( ADDRESS_ID )
=AUTO_REPLY_LOG_TB CLUSTERING KEY (ADDRESS_ID, ADDRESS_HASH_KEY)
=CLIENT_DOM_BL_TB PRIMARY KEY (BLACKLIST_ID, DOMAIN_NAME)
=CMCOPTION_TB PRIMARY KEY (USER_ID)
=DOMAIN_BASE PRIMARY KEY (DOMAIN_HASH_KEY, DOMAIN_NAME)
UNIQUE INDEX =DOMAIN_I0 ON =DOMAIN_BASE (DOMAIN_ID)
INDEX =DOMAIN_I1 ON =DOMAIN_BASE (ACCOUNT_ID)
VIEW =DOMAIN_TB AS SELECT * FROM =DOMAIN_BASE WHERE
DOMAIN_STATUS <> "d"
=DOMAIN_ACCESS_TB PRIMARY KEY ( ACCOUNT_ID, DOMAIN_ID)
=SMTP_BLACKLIST_TB PRIMARY KEY (BLACKLIST_ID, MAIL_ADDRESS)
=ID_ALLOCATION_TB PRIMARY KEY ( ID_TYPE )
=IP_BLACKLIST_TB PRIMARY KEY (BLACKLIST_ID, IP_ADDRESS)
=LOGIN_USER_BASE PRIMARY KEY (NAME_HASH_KEY , LOGIN_NAME)
UNIQUE INDEX =LOGIN_USER_I0 ON =LOGIN_USER_BASE (LOGIN_USER_ID)
INDEX =LOGIN_USER_I1 ON =LOGIN_USER_BASE (ACCOUNT_ID)
VIEW =LOGIN_USER_TB AS SELECT * FROM =LOGIN_USER_BASE WHERE
LOGIN_USER_STATUS <> "d"