DSNIRELU

DSNIRELU is part of the Data Manager component of Db2 and is involved in update primary key processing for tables defined with referential integrity constraints.

Hints

This module appears with the attempt to update a primary key column in a table which has been defined as the parent in a referential constraint.

Referential constraints can negatively impact performance because update operations on a primary key may require references to many rows in many tables.

Foreign keys should be indexed to prevent the use of tablespace scans to enforce referential constraints. The leading columns of the index should match the columns of the foreign key.

Consider placing tables bound by relational constraints in the same tablespace when foreign keys have been indexed. However, when foreign keys are unindexed, place the tables in separate spaces to prevent unnecessary scanning.

Reference Sources

IBM Db2 for OS/390, Messages and Codes, GC26-8979

IBM Db2 for OS/390, Application Programming and SQL Guide, SC26-8958

IBM Db2 for OS/390, Administration Guide, SC26-8957