On Mon, 07 January 2002, wrote:

> 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?

How much time between "At first" and "Now"? Was it a gradual lengthening or 
abrupt? Have you tried RCLSTG SELECT(*DBXREF)?

Tom Liotta

Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788
Fax  253-872-7904

The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.