A record designated as an orphan record points at another set or record, but neither the owner of the set nor any member record in the set points back at the orphan record. This type of integrity error is detected during walknext and QuickCheck processing. Do not confuse an orphan record with an integrated index orphan (described earlier). An orphan record is an integrity error.
There are two types of orphan record errors:
1. Orphan string points into valid set
CA IDMS/DB Audit found a record that can not be retrieved when the set is walked from the owner, even though the record points into the set.
For example, in Figure 2.28, records Carol Smith and Ron Barker are connected into the set occurrence owned by the ENGLISH record. When the set is walked from the owner record (ENGLISH), however, only Harry Dean, Jane Doe, and Robin Hayes are retrieved. The Carol Smith and Ron Barker records can only be retrieved if stored CALC, or if the area is swept. CA IDMS/DB Audit corrects this situation by making Harry Dean point to Ron Barker.
Figure 2.28: Orphan String Points into Valid Set
2. Orphan string is fully disconnected
CA IDMS/DB Audit could not retrieve an owner record in a set occurrence that was entered either by retrieving one of the member records in an area sweep or by retrieving a member record that was stored CALC. In addition, the member record chain cannot be retrieved by walking from the owner of the set.
For example, in Figure 2.29, TEACHER records Ron Barker and Carol Smith are connected together; however, no valid owner of a DEPT-TEACHER set points to the string. Also, Carol Smith's next db-key is invalid. CA IDMS/DB Audit cannot correct this situation.
Figure 2.29: Orphan String is Fully Disconnected
|
Copyright © 2013 CA.
All rights reserved.
|
|