Re: load error
On Mon, 01 Sep 2003 05:58:29 -0400, DBA-BABY wrote:
The limit of data in a single table/index fragment (including a non-fragmented
table) is 16,777,216 pages, exactly what you have! You need to fragment the
table or delete old data or both.
Art S. Kagel
> 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