Re: Help!!! - - Informix problems - - p, p, p, p, p, p, p, p, PLEASE!! (A real puzzlething)
First I would like to thank all people who will help me with this problem, i'm realy stuck here! Thank you! Some additional information (the problem is more complex then it looked like): Some version numbers fo the software used: SCO_SV Release 3.2v5.0.0 (+ Adv hw supp ver 5.2) 30 user ESQL/C 5.06.uc1 Intel pentium 2 cpus SCO Unix 3.2.5.0 Intel I-SQL 4.14uc1 Intel Pentium 2 cpus SCO Unix 3.2.5.0 Intel I-STAR TCP/IP 5.06.uc1 Intel Pentium 2 cpus SCO Unix 3.2.5.0 Online 5.06.uc1 Intel Pentium 2 cpus SCO Unix 3.2.5.0 ESQL/Runtime 5.06.uc1 Intel Pentium 2 cpus SCO Unix 3.2.5.0 Informix Net for windows PC version 5.01.w ISDN Router : AVM Netware Multiprotocol router for ISDN v3.0 > I haven't ever seen any Informix database do anything like this except > in a crash situation. > Exactly what is happening, and what is your solution to repair it? > And you didn't say anyting about the version of the database. It seems > to be ver 4.x or 5.x but exactly what is it. (OnLine or SE and version > number). It looks like the primary keys of some records are destroyed The error looks like "Rowid Lx003 not found for delete in partnum 20001b3 key 1" "7ffff88c:00000000 0b0000000 180a2401 0100400 ........ ..$..... I repair the record's by creating a new table exporting the old table's records and import them again in the new table Online Version 5.06.uc1 > What is your client software? Is it ESQL/C? That can easily handle > this. You have Informix-NET for Windows. Is there perhaps some other > client software on the PC? I'm using informix-net PC version 5.01.w with Powerbuilder 4.x > Not all that much. Sorry. :.| > Have you installed the needed patches: rs500d, net100, oss449a > Without these you shouldn't expect much to work well. Where can I get these patches? > :Informix - ESQL/C 5.06, I-SQL 4.14, Informix-NET for Windows 5.01.w > These versions seem to be old. Are you sure they are realy for SCO > 5.0.0. If they aren't spesific ports for this version of SCO I > wouldn't expect them to work very well. The changes from earlier > versions of the OS are significant. > > :I hope you can help me but.... > Not much, but possibly a start. > > > Nils.Myklebust@idg.no > NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway > My opinions are those of my company > The Informix FAQ is at http://www.iiug.org >