In that situation, you did not need an index over just the FK column, so long as the first column in the index is the same as PK of the parent.
Originally Posted by spohnsoftware
Actually, you don't absolutely need an index on every FK. It all depends on the SQL statements issued against the table, and also the Parent table (such as when you try and delete a parent row and DB2 needs to insure no children exist).
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390