Adding referential constraints only possible in single-user mode
Yes, unfortunately, it's true. You cannot
ALTER TABLE my_table ADD/DROP CONSTRAINT ... REFERENCES other_table
while there's someone else accessing your database. You'll
receive friendly "Statement failed, SQLCODE = -607
unsuccessful metadata update
-object OTHER_TABLE is in use".
This is still true for 6.0.
