Hi all,

Thanks for your responses.

The issue was resolved after we raised a PMR with IBM support. The issue was with referential integrity corrruption. (APAR IZ00678). -440 is also sometimes encountered as part of this issue it seems. After we dropped and recreated our FKs, the issue went away.

The catch here is even if you upgrade to the latest fixpak, the issue does not get resolved, because the referentail integrity constarints are already corrupted. So dropping and recreating is the only option. I guess IBM also has a patch just in case to clean up this mess.

ps. The same sqlcode was encountered even when we were trying to delete from the table. Both the issues got resolved now.

Thanks
Ravee