DSNU367I csect-name - ENFORCE PHASE STATISTICS - n ROWS DELETED FROM TABLE t
Explanation
This message reports the results of the ENFORCE phase of the LOAD utility. Data rows added during the RELOAD phase of the LOAD utility have been deleted because they contained foreign keys which did not have a corresponding primary key. A total of n data rows were deleted from table t.
Primary errors may cascade and remove additional records. The count is the sum of both primary and secondary constraint violations.
System action
Processing continues.
User response
Determine why no primary key exists for the deleted record.
Problem determination
All primary errors are accompanied by a DSNU361I message which identifies the relationship and input record which does not have a primary key value. The report phase will report all secondary errors and indicate the primary error record which caused this record to be deleted.
The relevant parent table can be found by querying the SYSIBM.SYSRELS catalog table. The relevant columns can be found by querying the SYSIBM.SYSFOREIGNKEYS catalog table.
Severity
4 (warning)