HP Large Objects System Management Manual

HP Large Objects System Management Manual – 543599.001
the calculation of the extent sizes.
Guardian security oooo The standard Guardian security
setting to be used in creating the SQL
tables.
3.6.5 createPartition.sh script
The createPartition.sh script accepts parameters interactively via the OSS command
prompt. This is an optional script to partition certain SQL tables that would benefit
from being spread across multiple volumes – either because of the volume of
expected data or the frequency of update hits.
Notes:
1) The unstructured BuddySpace and FSM files must NOT be partitioned – only SQL
tables are partitioned by this script.
2) This script is designed to partition the SQL tables during the installation sequence.
When partitioning is to be applied after the system has been used to store objects, then
standard SQLCI commands can be used to add partitions and spread the existing rows
over the new partitions.
The following is a list of the SQL tables that are partitioned by this script:
Table Name Reason for
partitioning
Usage
qbuddy update
frequency
Publish and subscribe table for
notification of BuddySet/Spaces
being closed and reopened.
buddysp volume of data One row for every BuddySpace.
objbuddy volume of data Many rows for each object stored on
the system.
uidobj update
frequency
Used to allocate objectIds.
Invoke the script from the OSS prompt by typing:
createPartition.sh
Accepted Parameter Default Value Usage
Maximum Process Pin 512 One of the SQL Tables (UIDOBJ)
uses Process Pin as the partitioning
key. You may optimise the spread of
rows across all partitions by entering
the maximum likely Process Pin (per
CPU) on your system.
List of Volumes none The volumes where partitions are to
be created. Volumes can be entered
in two ways, either by keying in a
simple list, or by responding to a list
Page 25 of 37