Sorry about not changing the subject on the last reply. We have a process that drops the constraints on tables (physical files), clears them with a CLRPFM, and then rebuilds the constraints. At first this process took 20 minutes. Now it takes 2 1/2 hours. My question is why? or how is this possible? Here is a small sample: RUNSQLSTM SRCFILE(SourceLib/SourceFile) SRCMBR(Member1) + NAMING(*SQL) DFTRDBCOL(DataLib) CLRPFM FILE(Table1) . . RUNSQLSTM SRCFILE(SourceLib/SourceFile) SRCMBR(Member2) + NAMING(*SQL) DFTRDBCOL(DataLib) Here is some of the sql source from each member: Member1: ALTER TABLE Table1 DROP CONSTRAINT R_1848; Member2: ALTER TABLE Table1 ADD CONSTRAINT R_1848 FOREIGN KEY (key1, key2) REFERENCES Table2 ON DELETE CASCADE ON UPDATE RESTRICT; Patrick Conner www.ConnecTown.com (828) 244-0822 Yes. Is this the correct forum for SQL questions?
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.