ISAM error: No more locks
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------ =_NextPart_000_01BE9BC1.D0E4AE56
Content-Type: text/plain
I am running into the error :
ISAM error: No more lockswhen 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>>
------ =_NextPart_000_01BE9BC1.D0E4AE56
Content-Type: application/octet-stream;
name="Karsten, Brock (E-mail).vcf"
Content-Disposition: attachment;
filename="Karsten, Brock (E-mail).vcf"
BEGIN:VCARD
VERSION:2.1
N:Karsten;Brock;;;
FN:Brock Karsten (E-mail)
ORG:Orthologic;IT
TITLE:Systems Manager
TEL;WORK;VOICE:(800) 937-5520 x5356
TEL;WORK;VOICE:
TEL;HOME;VOICE:
TEL;CELL;VOICE:
TEL;CAR;VOICE:
TEL;PAGER;VOICE:
TEL;WORK;FAX:(602) 231-6496
TEL;HOME;FAX:
ADR;WORK:;;1275 W Washington St;Tempe;AZ;85281;United States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:=0D=0A=0D=0A1275 W Washington St=0D=0ATempe, AZ 85281=0D=0AUnited States of =
America
ADR;HOME:;;;;;;
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:=0D=0A=0D=0A, =0D=0A
ADR;POSTAL:;;;;;;
LABEL;POSTAL;ENCODING=QUOTED-PRINTABLE:=0D=0A=0D=0A, =0D=0A
EMAIL;PREF;EX:/o=OrthoLogic/ou=OLGC.COM/cn=Recipients/cn=BKarsten
REV:19990329T211252Z
END:VCARD
------ =_NextPart_000_01BE9BC1.D0E4AE56--