Fujitsu UDS/SQL V2.5 Network Router User Manual


 
SSL Linkage methods
U929-J-Z125-9-76 149
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. Oktober 2007 Stand 08:58.55 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k05
The physical placement of records can be defined only once:
If a record type is a member of several sets, only one of the sets can be defined with
MODE IS LIST.
It is not possible to define records with MODE IS LIST and PLACEMENT
OPTIMIZATION at the same time (see the section “PLACEMENT OPTIMIZATION” on
page 165).
If the records of a record type are placed both by LOCATION MODE IS CALC and
MODE IS LIST, they are stored in lists, and the hash area consists of indirect CALC
pages.
The following restrictions also apply:
MODE IS LIST may only be specified if the set membership has been defined as
MANDATORY AUTOMATIC in the schema DDL (see the section “Defining the type of
membership of records in a set” on page 79).
MODE IS LIST may not be specified in the following cases:
if the record lengths (including pointers; see page 220, SCD) exceed
993 bytes in a database with a 2048-byte page length (2-Kbyte page format)
1963 bytes in a database with a 4000-byte page length (4-Kbyte page format)
4011 bytes in a database with a 8096-byte page length (8-Kbyte page format)
(At least two records must fit in a list, but this would not be possible in the above cases.)
if a member record type contains an item of variable length;
if the order of the records within the set occurrence is defined with ORDER IS SORTED
(without INDEXED) or
if member records are to be stored in compressed form (see the section “Storing the
records of a record type in compressed form” on page 176).