Re: Consistency Check Duration

Scott Hanson wrote: > > Hello, > > When we put a system live about 18 months ago, a full consistency check > (oncheck -crceID) took apprx 12 hours. > This has increased slowly to 24 hours now. > > The database is apprx 20GB in terms of allocated dbspace, and the > hardware is HP 9000 K420 2 CPU's, 1GB RAM. The disks all reside on fast > EMC Symmetrix storage. > > Does anyone know what would be causing the increase in time taken for > the consistency check? There is no-one using the system while the check > is going on. You do not state IDS version. If you recently upgraded to 7.24 part of the problem is that 7.24 does a more extensive testing of the logical log files which was accidentally skipped in earlier versions and purposely left out of 7.30 because it is too slow. Beyond that your database may be becoming fragmented and is probably growing. You really do not need to do this level of checking constantly like this. Change to checking a subset of your tables along with the system checks each week rotating the subset so all tables are covered monthly. Art S. Kagel