Re: ISAM error: No more locks
Karsten,
1) You have Foreign key constraint on that table. Check constraint for
cascade deletes even if your table structure has no cascade delete
option on "alter table add constraint" statement.
2) Also check for other foreign key constraints tied to this table.
3) Check triggers.
4) I think Art KAGEL has a very useful script to perform smooth mass
delete from any table with any kind of logging status database. Try thisscript (or ec program) located on www.iiug.org
Good luck.
Gursoy YERLI
"Karsten, Brock" wrote:
>
> I am running into the error :
> ISAM error: No more locks> when I try to delete all records from the following table
>
> DBSCHEMA Schema Utility INFORMIX-SQL Version 7.23.UC2
> Copyright (C) Informix Software, Inc., 1984-1997
> { TABLE "informix".tblinventorytrans row size = 101 number of columns = 15
> index
> size = 12 }
> create table "informix".tblinventorytrans
> (
> lilocationid integer not null constraint "informix".n117_39,
> liproductid integer,
> aserialnumber char(20),
> deffdatefrom date,
> deffdateto date,
> lisequenceno integer,
> litransquantity integer,
> liorderid integer,
> blrentalonly smallint,
> liinvstatusid integer,
> valoginid varchar(30),
> dtlastupdate datetime year to second,
> blactivesernumber smallint
> default 0,
> linotesid integer,
> siareaid smallint
> default 0
> );
> revoke all on "informix".tblinventorytrans from "public";>
> alter table "informix".tblinventorytrans add constraint (foreign key
> (liproductid) references "informix".tblproductmaster constraint
> "informix".fk_tblinventory1);
>
> There a re approx. 10,000 rows in this table.
> I am able to delete more rows from other tables with no problem.
> This is the only database that has unbuffered logging on it.
> in my onconfig, LOCKS is set to 10000.
> I have run oncheck as many ways a possible to try to find the problem.
> I have dbexport/dbimport-ed the database and that did not fix it.
>
> Is there something I am missing?
>
> Sun Solaris 2.5.1, Informix 7.23.UC2
>
> Brock J. Karsten
> Systems Manager
> 1275 W Washington St.
> Tempe, AZ 85281
> (800) 937-5520 x5356
> (602) 286-5356
> Fax: (602) 231-6496
> bkarsten@olgc.com
> <<Karsten, Brock (E-mail).vcf>>