0x0072050D (7472397) The CA-IDMS Area Table exceeded the maximum entries.

Explanation

The combination of the number of areas needed for the records in the PATH and index sets exceeded the maximum number of CA-IDMS areas supported in the system tables. The system tables currently support a maximum of only 10 records areas. The number of areas needed to execute the PATH is the sum of the following numbers:

  • All areas for each record: All areas for each set in the PATH that is an index
  • All areas associated with the system owned indexes on the Primary record in the path
  • All areas associated with the system owned indexes on the last (target) record in the path
  • All areas associated with owner records for sets that the last (target) record is a member of even if not included on the PATH.

User response

Reduce the number of dependent areas and resubmit the CREATE TABLE statement.