DSNU706I csect-name ROW IS IN WRONG PARTITION RID=rid-value, INDEX=iiii, KEY=kkkk, CORRECT PART=pppp, WRONG PART=wwww
Explanation
The row at the specified RID resides in the wrong partition. The specified partitioning key for the partitioning index indicates that the row should reside in the indicated partition (pppp). However, the RID indicates that the row actually resides in partition wwww.
System action
- csect-name
- The name of the control section that issued the message.
- rid-value
- The record ID (RID) value of the row
- iiii
- The partitioning index.
- kkkk
- The partitioning key.
- pppp
- The correct partition.
- wwww
- The incorrect partition.
System action
Utility processing continues.
User response
Run the RECOVER TABLESPACE utility to recover the data or run REPAIR DELETE utility to delete the row at rid-value followed by the CHECK INDEX and CHECK DATA utilities if referential constraints are involved.
Problem determination
The inconsistency between the table space partition number of a row and the index space partition number of the row's clustering key might be due to a Db2 internal error. However, most likely this problem is due to a user using the DSN1COPY service aid to populate a target table space with data from a source table space when the clustering key values on the source and target table spaces are not identical.
Severity
4 (warning)