Re: Illegal key descriptor (isam error 103)
--0__=88BBE4CADFC570A88f9e8a93df938690918c88BBE4CADFC570A8
Content-type: multipart/alternative;
Boundary="1__=88BBE4CADFC570A88f9e8a93df938690918c88BBE4CADFC570A8"
--1__=88BBE4CADFC570A88f9e8a93df938690918c88BBE4CADFC570A8
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable
Can u try to drop and recreate the index on the table ... or run tbchec=
k on
the table to see if the index is okay or not. Usually, this error signi=
fies
something's wrong in the index definition on the partition page of the
table. I think the easiest way would be to just drop/recreate the index=
.
Thanx much,
Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
=
Franz Gr=FCtzmacher =
<franzg@biblesoci =
ety.co.za> =
To
Sent by: <informix-list@iiug.org> =
owner-informix-li =
cc
st@iiug.org =
Subj=
ect
Illegal key descriptor (isam err=
or
03/17/2004 01:11 103) =
AM =
=
=
=
=
=
Hi All
I am not getting any replay from the classis-list, but most of you must=
have grown from SE to Online.
Maybe you can help.
We are running Informix SE
SCO Unix vers 5.0.5
Informix SE 5.08.UD1
SQL vers 4.17.UC1
RDS vers 4.17.UC1
on a Pentium Pro with a SCSI hd and 128meg ram.
When I try running a sql script (wild select) on a table:
select * from tab
I get error -1201 Number is too small for a DECIMAL data type.
The DECIMAL data type accommodates numbers from 10-130
through 10124 in absolute value. The precision (number of significant
digits)
varies from 1 to 32; however the source of this error is not in
the length of the number but in its magnitude.
What are it trying to tell me????
If I change the select to include a where part I recieve the following
error:
245: Could not position within a file via an index.
103: ISAM error: illegal key descriptor (too many parts or too long).
But if I change the select to (select field01 from tab) it returns outp=
ut.
If I change the select to (select field01,(price*1) from tab) it works.=
Price is define as a float.
So this could be a problem with NULLS? and I can live with it, but hiw =
do I
solve
isam error 103 when using a where part in the select ?
Plz help!!!!!!!!!!!!!!!
=
--1__=88BBE4CADFC570A88f9e8a93df938690918c88BBE4CADFC570A8
Content-type: text/html; charset=ISO-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body bgcolor=3D"#FFFFFF">
<p>Can u try to drop and recreate the index on the table ... or run tbc=
heck on the table to see if the index is okay or not. Usually, this err=
or signifies something's wrong in the index definition on the partition=
page of the table. I think the easiest way would be to just drop/recre=
ate the index.<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer (RAS)<br>
IBM Data Management Group <br>
Ph : (602)-217-2100<br>
Fax: (602)-217-2100<br>
T/L : 667-2100<br>
<br>
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison<br>
<br>
<img src=3D"cid:10__=3D88BBE4CADFC570A88f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for Franz Gr=FCtzmacher=
<franzg@biblesociety.co.za>">Franz Gr=FCtzmacher <franzg@bibl=
esociety.co.za><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE4C=
ADFC570A88f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">Franz Gr=FCtzmacher <franzg@biblesociety.co.=
za></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">03/17/2004 01:11 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE4CADFC570A88f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE4CADFC570A88f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2"><informix-list@iiug.org></font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE4CADFC570A88f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE4CADFC570A88f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE4CADFC570A88f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D88BBE4CADFC570A88f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Illegal key descriptor (isam error 103)</font></td></t=
r>
</table>@@NL