Fujitsu UDS/SQL V2.5 Network Router User Manual


 
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 the concen-
tration of data in one page or in contiguous pages within this realm.
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 data 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