When you create a new Component Definition, IBM® Records Manager dynamically creates a new table
and adds it to a default tablespace. With the Custom Component Definition
dialog, you can specify into which tablespace IBM Records Manager creates this custom table. This
set of options lets users set configurable table spaces for a custom
table. The maximum length is 18 symbols. For example, for performance
or storage reasons, you might want to associate a tablespace with
a new or a larger storage location if you anticipate a large amount
of data.
If you performed a custom installation, the default
tablespace may not exist. The default tablespace names are as follows:
- For DB2, USERSPACE8
- For Oracle, USERS
- For SQL Server, [PRIMARY]
For information about copying component definitions, see Copying custom file plan component definitions.
To configure these options:
- Click .
- In the Table space name field, type
the table space name you want to use for the custom component tablespace
This field specifies the name of the tablespace to create
this custom table. Typically, the default is 4K in size. If you do
not specify a value for this field (when the field is empty), IBM Records Manager will use the first available
tablespace. If you choose a tablespace that is too small, you will
not be able to insert many attributes.
Note: If a name is specified
in this field (either the default name or another name), the tablespace
that this name refers to must exist, and it must be properly configured.
This means that the tablespace must be assigned a proper BUFFERPOOL
with an appropriate pagesize. For example, for DB2, USERSPACE8 has
a 32K pagesize, and it uses BUFFERPOOL8 which also has the same 32K
pagesize (created by IBM Records Manager). You
can reuse this BUFFERPOOL provided that the tablespace you create
is also 32K, or you can create your own. If you want to use a tablespace
and BUFFERPOOL with a pagesize smaller than 32K, you will be limiting
the number and size of the custom attributes (columns) that can be
added to that table. If you specify a 4K pagesize, that might not
be a sufficient amount of space to add the custom fields.
- In the Table space index name field,
type the table space index name you want to use for the custom component
table space index.
This field specifies the name of
the tablespace index where the custom tablespace is created (where
the indexes are placed). If the key is missing, the indexes are placed
in the same tablespace as the table data.
- In the Table space name for CLOBs/BLOBs field,
type the table space name you want to use custom component table space
CLOBs/BLOBs.
This field specifies where the BLOBS and
CLOBS are placed. If the key is missing, the BLOBS and CLOBS will
be placed in the default table space.
- In the Permission synchronization table space field,
specify into which tablespace the table will be created during the
permissions synchronization calculations.
Immediately
after installing IBM Records Manager, this field
is empty. This means that any permission synchronization table is
created in a default tablespace. To explicitly specify into which
table space these tables are created, you must specify an existing,
valid tablespace.
- Click Save.
