Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Glossary P
U929-J-Z125-9-76 287
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
18. Oktober 2007 Stand 11:29.52 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.mix
PETA
Preliminary end of transaction: UDS-D or openUTM-D statement that causes a
preliminary transaction end.
The PETA statement belongs to the first phase of the two-phase commit protocol
which terminates a distributed transaction.
The PETA statement stores the following information failproof in the RLOG file
of the local DBH:
each updated page
rollback and locking information
the names of all participating configurations.
This information is required for any future warm start.
pointer array
Table of pointers to the member records of a set occurrence. Used for sequential and
direct access to member records.
prepared to commit (PTC)
Part of the two-phase commit protocol:
State of a subtransaction after execution of a PETA statement and before receipt
of the message that the complete transaction is to be terminated with FINISH or
FINISH WITH CANCEL.
primary key
Distinguished from secondary keys for reasons of efficiency. Usually a unique
identifier for a record.
primary key (DDL)
The key of a record type which is defined by means of "LOCATION MODE IS
CALC" or the key of an order-determining key of a set occurrence which is
defined by means of "ORDER IS SORTED [ INDEXED]". Also used for direct
access to a record or a set of records with the same key values or within a search
interval.
primary key (SQL)
In the broader sense (SQL), a record element uniquely identifying a record.
In UDS-SQL, the database key of an owner record output as the "PRIMARY
KEY" in the BPSQLSIA log (see also foreign key).
A record element which uniquely identifies a record is flagged as "UNIQUE" in the
BPSQLSIA log unless it is the aforementioned "PRIMARY KEY".