Fujitsu UDS/SQL V2.5 5.4 Defining the placement of member records, tables and hash areas

Placement SSL
160 U929-J-Z125-9-76
5.4 Defining the placement of member records, tables and hash
areas
The SSL provides options to define the placement of the following objects:
– member records
–lists
– pointer arrays
– sort key tables
– SEARCH key tables
– DBTTs
– hash areas.
These options include, in particular:
– For member records, lists, pointer arrays, sort key tables and set SEARCH key tables,
you can define not only the realm that is to contain the records but also th e concen-
tration of data in one page or in contiguous pages within this real m.
– In the case of hash areas, DBTTs and record SEARCH key tables, it is only possible to
define the realm in which they are to be stored.
5.4.1 Defining the placement of member records, associated tables and
hash areas for secondary keys
This section covers the possibilities of defining the placement of da ta belonging to one set
occurrence. Such data may be:
– an owner record
– member records or list
– a pointer array
– a sort key table
– a set SEARCH key table
– a hash area for the set secondary key