Re: too many rows?

Several suggestions: Include the version number of the Informix engine (e.g. OnLine 5.08) as well as the tool. Review the release notes to learn the max limits for your product. Include the error message that you see. Among the reasons you might not be able to load more rows are: Max number of rows reached (unlikely) Max number of extents allocated (likely) Logical logs filled (possible) LTHWM set too low Confusion about fs space and raw space leading to misunderstanding about how much available space is full See TFM regarding the permissions settings. You almost certainly *don't* want 777 on the actual data devices. The potential for disaster (data being over-written) is worth careful research to avoid. Finally, be aware that sometimes anti-spam return addresses keep otherwise more helpful people from replying directly to you. HTH, Clem At 10:07 AM 09-02-99 -0500, DS wrote: >Hi, I have a problem on a large database, hopefully someone can help me. > >I'm running ISQL 4.10.UC2, SCO OpenServer 5.0.4c > >the database has 1,900,000+ rows & I can't load any more rows into it. I >thought the indexes or table might be corrupted, so i rebuilt them on >another fs, didn't work. I re-wrote the table & loaded from an ascii file, >didn't work. the fs is @ 65% so space is no issue. the permissions have >been set to 777(rwe all the way across.) _______________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Informix Software, Inc Last seen: Battening down the hatches for monsoon season USA

Clem Akins wrote: > > Several suggestions: > Include the version number of the Informix engine (e.g. OnLine 5.08) > as well as the tool. Yes please. Another possibility is that Informix limits a single fragment (or unfragmented table) to 16,777,216 pages of data (note that a bug in versions before 5.07 will allow a table to SEEM to grow beyond this limit if the dbspace is larger than 16,777,216 pages but actually your page addresses will wrap and overwrite older data pages corrupting the table). If you have 7.xx fragment the table. If you have 5.07+ split the data to additional tables and use UNIONS or, better, upgrade. If you are using 5.06 or earlier - Sorry. Art S. Kagel [SNIP excellent reply> > At 10:07 AM 09-02-99 -0500, DS wrote: > >Hi, I have a problem on a large database, hopefully someone can help me. > > > >I'm running ISQL 4.10.UC2, SCO OpenServer 5.0.4c > > > >the database has 1,900,000+ rows & I can't load any more rows into it. I > >thought the indexes or table might be corrupted, so i rebuilt them on > >another fs, didn't work. I re-wrote the table & loaded from an ascii file, > >didn't work. the fs is @ 65% so space is no issue. the permissions have > >been set to 777(rwe all the way across.) > _______________________________________________________________ > Clem Akins (aka clem@informix.com) Menlo Park x5937 > Customer Course Development Informix Software, Inc > Last seen: Battening down the hatches for monsoon season USA