Re: ISAM error: No more locks
Why don't you drop the table? remind to obtain the schema before dropping it.
Jorge Puente
"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>>