load error

hello group I have a problem : i'm loading data into table but i have this errore : 271: Could not insert new row into the table. 136: ISAM error: no moreextents 847: Error in load file line 192811. the number of extent is 35, so i things that is not a extent's problem. i things that the problem is Data pages per fragment, is right? my Database release is Informix Dynamic Server Version 7.31.UC4 ############################################################################ # this is the output of oncheck -pT on my table. Physical Address 800005 Creation date 08/21/2003 14:35:16 TBLspace Flags 802 Row Locking TBLspace use 4 bit bit-maps Maximum row size 1234 Number of special columns 0 Number of keys 7 Number of extents 35 Current serial value 1 First extent size 18159831 Next extent size 3355443 Number of pages allocated 16777215 Number of pages used 16777215 Number of data pages 16093228 Number of rows 16093228 Partition partnum 8388610 Partition lockid 8388610 ############################################################################ ### This is the output of file /product/informix/release/en_us/0333/SERVERS_7.2 Capacity Table-Level Parameters (based on 2K page size) per Table ----------------------------------------------------------------- Data rows per fragment............................. 4,277,659,295 Data pages per fragment............................... 16,775,134 Data bytes per fragment........................... 33,818,671,136 (excludes Binary Large Objects, BLOBs; roughly double this number for 4K page size) Binary Large Object bytes.................................. 2**31 Row length................................................ 32,767 Number of columns............................................ 32K Indexes....................................................... 77 (roughly double this number for 4K page size) Columns per index............................................. 16 Bytes per index.............................................. 255 ############################################################################ ### How i can resolve it? thanks

David Bucholz is correct, you need either to delete some unneeded data or fragment the table. Interestng that the number of data pages used is exactly equal to the number of rows. Or perhaps it isn't, if all the rows are long (perhaps the same size) .... Do you have attached or detached indexes? We didn't the remainder of the oncheck output, but I'd suspect attached, in which case you can buy some time by dropping an index or two. You can expect this exercise to take some considerable time (ie hours) on a table of that size though. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "DBA-BABY" <pippo99@libero.it> wrote in message news:9LE4b.281368$Ny5.8667672@twister2.libero.it... > hello group > > I have a problem : > > i'm loading data into table but i have this errore : > > 271: Could not insert new row into the table. 136: ISAM error: no more> extents > 847: Error in load file line 192811.> > the number of extent is 35, so i things that is not a extent's problem. > > i things that the problem is Data pages per fragment, is right? > > my Database release is Informix Dynamic Server Version 7.31.UC4 > > > ############################################################################ > # > this is the output of oncheck -pT on my table. > > Physical Address 800005 > Creation date 08/21/2003 14:35:16 > TBLspace Flags 802 Row Locking > TBLspace use 4 bit bit-maps > Maximum row size 1234 > Number of special columns 0 > Number of keys 7 > Number of extents 35 > Current serial value 1 > First extent size 18159831 > Next extent size 3355443 > Number of pages allocated 16777215 > Number of pages used 16777215 > Number of data pages 16093228 > Number of rows 16093228 > Partition partnum 8388610 > Partition lockid 8388610 > > > > ############################################################################ > ### > > This is the output of file /product/informix/release/en_us/0333/SERVERS_7.2 > > Capacity > Table-Level Parameters (based on 2K page size) per Table > ----------------------------------------------------------------- > Data rows per fragment............................. 4,277,659,295 > Data pages per fragment............................... 16,775,134 > Data bytes per fragment........................... 33,818,671,136 > (excludes Binary Large Objects, BLOBs; roughly double this > number for 4K page size) > Binary Large Object bytes.................................. 2**31 > Row length................................................ 32,767 > Number of columns............................................ 32K > Indexes....................................................... 77 > (roughly double this number for 4K page size) > Columns per index............................................. 16 > Bytes per index.............................................. 255 > > ############################################################################ > ### > > > How i can resolve it? > > thanks > > > >