Previous Topic: Multiple Owner RecordsNext Topic: CALC Sets


Invalid Db-keys

CA IDMS/DB Audit reports three types of invalid db-keys:

1. Prior db-key does not point to the prior member of set

When walking a set in the next direction, the prior db-key does not point to the prior record in the set. For example, in Figure 2.14, walking next from the ENGLISH record, Harry Dean is retrieved. Walking next again, Carol Smith is retrieved but her prior db-key does not point back to Harry Dean; it points to another valid record occurrence (Joan Brown).

Figure 2.14: Prior Pointer Does Not Point to Prior Record

2. Next db-key does not point to the next member of set

When walking a set in the prior direction, the next db-key does not point to the next record in the set (the record just walked from). For example, in Figure 2.15, walking prior from the ENGLISH record, all next db-keys point back to the previous record until Harry Dean is retrieved. Harry Dean's next db-key does not point to Jane Doe, but to Carol Smith.

In both of these situations, CA IDMS/DB Audit evaluates the error by walking the set in the next and prior direction and fixes the set such that Harry Dean's next db-key points to Jane Doe.

Figure 2.15: Next Pointer Does Not Point to Next Record

3. Owner db-key does not point to the owner of the set

In Figure 2.16, Jane Doe's owner db-key does not point to the owner of the DEPT-TEACHER set. Instead it points to the HISTORY record, which is an owner record of another DEPT-TEACHER set occurrence.

CA IDMS/DB Audit corrects this error by making Jane Doe's owner db-key point to English.

Figure 2.16: Owner Db-key Does Not Point to Set Owner