CA IDMS/DB Audit detects integrated index orphan records. An integrated index orphan occurs when the upper level pointer of an SR8 record or a member record of an integrated index set does not point to the correct record in the level above it. Integrated index orphans are not integrity errors because this condition can occur normally when the database spawns new SR8 records to accommodate the addition of new member records. Their presence, however, can degrade performance.
For example, in Figure 2.19 upper level record 9000-06 points to record 9000-03 but record 9000-03 points back to record 9000-05. To fix this condition, specify INDEXORPHANS in the FIX parameter statement. INDEXORPHANS also causes the orphan counts in SR8 records to be corrected.
Figure 2.19: Orphan Record in Integrated Index Set
|
Copyright © 2013 CA.
All rights reserved.
|
|