Guardian Procedure Calls Reference Manual

The relative position of an alternate-key record within a set of duplicates may change if a
nonrecoverable error occurs during a WRITEUPDATE of the primary record.
There is a performance penalty for using insertion-ordered duplicate alternate keys. Updates
and deletes of alternate-key fields force the disk process to sequentially search the set of
alternate-key records having the same altkeyvalue until a match is found on the
primarykey-value portion of the key. (The value of the timestamp field in an alternate key
record is not stored in the primary record). The performance cost rises as the number of records
having duplicate alternate-key values increases.
If an insertion-ordered alternate-key file is partitioned, the length of each partition key must
be no greater than the total of altkeytaglen and altkeylen. If the length of any partition
key is greater than this sum, then the file system may fail to advise the user of the duplicate
key condition (indicated by the warning error code 551).
• Queue files
Queue files are created by specifying file-type.<9> = 1 and file-type.<13:15>
= 3.
◦
◦ The key-sequenced-params array must be specified. The minimum key-len must
be 8 bytes, and the key-offset must be 0.
◦ No alternate-key-params can be specified.
◦ No partition-key-params array can be specified.
• Creating format 2 key-sequenced files with increased limits
In H06.28/J06.17 RVUs with specific SPRs and later RVUs, format 2 legacy key-sequenced
files and enhanced key-sequenced files can be created with increased file limits. (For a list of
the required H06.28/J06.17 SPRs, see SPR Requirements for Increased Enscribe Limits for
the H06.28/J06.17 Release (page 31).) The creation of a key-sequenced file with increased
limits occurs if file-type.<13:15> = 3 and at least one of the following is specified:
◦ A data-blocklen value greater than 4096 bytes and less than or equal to 27, 678
bytes
◦ A primary key-len with a length of 256 to 2048 bytes
◦ 64 to 127 secondary partitions in the partition-params parameter
If a key-sequenced file with increased limits is to be created, the internal layout of the file is
dependent upon the number of partitions: a format 2 legacy key-sequenced file is created for
1 to 16 partitions, and an enhanced key-sequenced file is created for 17 to 128 partitions.
Note the following limitations when using these increased limits with the CREATE procedure:
◦ The limits for key-length and key-offset for an alternate key are not increased for
the CREATE procedure in H06.28/J06.17 RVUs with specific SPRs and later RVUs. These
two limits have been increased in the superseding FILE_CREATELIST_ procedure.
◦ The creation of key-sequenced files with these increased limits is not supported on legacy
514-byte sector disks; the creation attempt will fail with an FEINVALOP (2) error.
• Exceeding the file system file label space
An attempt to create a file receives an error 1027 if the file system file label space for the
primary partition would be exceeded.
If the file specification has up to 16 partitions, reduce the number of alternate-key files, alternate
keys, extents, secondary partitions and/or the size of the partition keys.
If the file specification has more than 16 partitions, reduce the number of alternate-key files,
alternate keys, and/or extents.
CREATE Procedure (Superseded by FILE_CREATELIST_ Procedure) 237