Re: load error
This error specifies that either u don't have enough space in the
dbspace in which the table resides or number of extents exceeded max.
allowed.
How to check this -
use onstat -d and check available space in the dbspace in which ur
table resides and then verify that it is greater than ur next extent
size of the table. If not
1) either alter table next extent size and make it smaller (
alter table tabname next size .... ) so that it fits.
2) or , add new chunk to the dbspace so that u have enough space.
( preferably do this )
Rgds
Preetinder
DBA-BABY wrote:
>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
>
>
>
>
>
>
sending to informix-list