RE: load error

You are correct. You either need to delete some unneeded data or fragment the table. -Dave David Buchholz Sr. DBA Vital Processing Services david.buchholz@vitalps.com -----Original Message----- From: DBA-BABY [mailto:pippo99@libero.it] Sent: Monday, September 01, 2003 2:58 AM To: informix-list@iiug.org Subject: 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 sending to informix-list