Dropping Foreign Key constraints with HADR - issues

Penny Jaskulke

Dropping Foreign Key constraints with HADR - issues
We have been experiencing a slowdown when using HADR with a batch loader.
The table had 3 foreign key constraints and was in nearsync mode. Through
trial and error (setting up test tables that did and did not have constraints)
we found that it looked like the foreign keys were causing the issue and by
removing them, it would speed up the log shipping to the remote server. We
removed the foreign keys, but it didn't speed up, even though the table shows
that they are gone. The one difference is that we tested it on a new table,
whereas the remove was on an existing table. We did a runstats, then reorg,
runstats and rbind on the existing table, but it still doesn't speed up. Does
anyone or has anyone seen this before? IBM L-3 is working the problem also.
We just need to figure out how to get these constraints off in order to speed
up the process, and deal with the code fix later. On V8.2 Linux.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms