Re: Informix 4GL error code -564

Kenny Fong wrote: > Thanks Marat. > > Marat <maratkotik@mail.ru> wrote in message > news:391FB831.51E83067@mail.ru... > > > > > > Webmaster wrote: > > > > > Hi, > > > > > > I am having this error -564 (cannot sort rows) with the system error -5 > (I/O > > > error) repeatedly while openning a cursor. > > > > > > I have no idea on what is the I/O error referring? Basically, I have > checked > > > and ensure that the harddisk space should be enough for generating the > > > temporary files while sorting the table. > > > > Are you sure? Is DBSPACETEMP set? What is its value? > > The DBSPACETEMP is not set in the system. > > > > > > > > > > > > Could anyone explain what the actual problem with this Informix 4GL > error > > > and how to solve the problem. > > > > > > Thanks, > > > Kenny mailto:kenny_fong@ctimail3.com > > > > Another possible solution: > > You can eliminate the sorting through some optimization. > > 1.1) SET EXPLAIN ON and run your SQL in dbaccess > > or > > 1.2) add SET EXPLAIN ON into your code > > 2) see sqexplain.out for possible optimization > > > > > I know that we could a a new index to the system to prevent the temporary > file generation. However, the system is an online system where it is not > possible to shutdown it and then create the index. In general case it isn't necessary to shutdown the server. By example you can SET LOCK MODE TO WAIT in other sessions that are needing this table. You can catch the moment when this table isn't used and run CREATE INDEX (itsets exclusive lock on the table). > BTW, if do you know what > is this error -564 with the system error 5 mean? 1. I guess you know that /home/informix:$finderr -564 -564 Cannot sort rows. This internal error reflects an unexpected condition during a sort. Check the accompanying ISAM error code for more information. If the error recurs, please note all circumstances and contact Informix Technical Support. 2. Related ISAM error /home/informix:$infxmsg 5 I/O error 3. What does it mean together? I don't know exactly. I think that reasons are different in different cases. > > > Thanks, > Kenny