Re: Cannot create indexes

brford@xmission.com (Russ Ford) wrote: >We are having problems creating indexes on several tables. We can get an >exclusive lock on the table and there does not appear to be any other >programs accessing the table but we receive error 242 > 242: Could not open database table (udba00.it_daily_mvmt).> > 106: ISAM error: non-exclusive access. >Error in line 17>This happens very infrequently but it not consistent either. Sometimes the >index builds work fine and sometimes they don't. One weekend we even had >50 out of about 120 servers where the index build failed for some unknown >reason. Are they any Informix bugs or maybe some other possibility than >another program locking the table? Any ideas would be helpful. Thanks. >P.S. We are running Informix Online 5.01 on NCR 3450 OS 2.01. >Russ Ford >brford@xmission.com We got some wierd index build error messages one time when we did not have enough temp space defined. Since in 5.x temp tables go into root you might monitor the space usage on root while the build is taking place to see if the free space goes to almost 0. tbstat -d -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com