Re: Stored procedure failing after IDS4 server crash

Posted in 2006

david@smooth1.co.uk — 11 Apr 2006 15:43:22 -0700 — source: Usenet: comp.databases.informix

"If the physdbs is shown as online, does it mean that it definitely is ok. " Try running - oncheck -cr (checks reserved pages - fast) - oncheck -cR (checks all physical and logical log pages - takes however long it takes to read that many pages) - oncheck -cc (checks all system catalogs - oncheck -ce (check extents are ok). This may take a while to run (say 1 hour, perhaps more for a huge instance) and I might consider skipping oncheck -ce if you have a multi-Tb database! David.