Placement SSL
168 U929-J-Z125-9-76
5.4.2 Defining the placement of record SEARCH key table, DBTT and record hash areas For this data, the user can specify only the realm in which it is to be stored.
The following clauses are used to allocate data to specific realms:
Record SEARCH key table
NDEX NAME IS name PLACING IS WITHIN realm-name
DBTT
DATABASE-KEY-TRANSLATION-TABLE WITHIN realm-name
Hash area for primary key
POPULATION IS {integer WITHIN realm-name},...
Hash area for record secondary key
INDEX NAME IS name PLACING IS WITHIN realm-name
name specifies the name of the table or hash area to be placed. This name must have been
assigned in the schema DDL (see the section “Assigning names to hash areas and tables”
on page 107).
realm-name specifies the realm in which the table or the hash area is to be stored. If no realm
name is specified, UDS/SQL stores the DBTT and the secon dary keys in the realm
specified first in the DDL WITHIN clause for this record type.
The hash area for primary keys is always set up according to the DDL WITHIN specification .