Question regarding oncheck

Posted in 2004

Topics: Versions, Editions & End-of-Life

Jerry Williamson — Fri, 30 Apr 2004 15:52:37 — source: IIUG Forums & Mailing Lists

Hello Informix group, I have a question regarding the oncheck utility on IDS 9.4 on HPUX 11i. When I run "oncheck -cI dbname", I get this warning for just about every index: "WARNING: index check requires a s-lock on tables whose lock level is page." From what I can tell, the index check is occurring, but what does this warning really mean? Does it mean that the oncheck was unable to check something, or is it just telling me what type of lock it is using? Thank you in advance, Jerry Jerry Williamson Grossmont-Cuyamaca Community College District

↪ replying to Jerry Williamson

MAHESH DASHORA — Fri, 30 Apr 2004 23:46:13 — source: IIUG Forums & Mailing Lists

This warning means that ONCHECK has acquired a table level lock required for its operation. It does NOT mean that ONCHECK was unable to check something. It is info for you to indicate that exclusive access can not be obtained on table while this check is on. Regards, Mahesh Dashora Development Manager - Backup Restore, High Availability and Utilities IBM Informix Development, IBM Data Management Solutions 4100 Bohannon Drive Menlo Park, CA - 94025

Glossary

IDS (Informix Dynamic Server)