I am not able to increase the extent size , next size beyond a
particular
level even if specify more number

what to do?
example
create table test (with 200 columns ) extent size 3902 next size
1858692


what to check?

calyanram@hotmail.com wrote:
> I am not able to increase the extent size , next size beyond a
> particular
> level even if specify more number
>
> what to do?
> example
> create table test (with 200 columns ) extent size 3902 next size
> 1858692
>
>
> what to check?

indikaj wrote:
> calyanram@hotmail.com wrote:
> > I am not able to increase the extent size , next size beyond a
> > particular
> > level even if specify more number
> >
> > what to do?
> > example
> > create table test (with 200 columns ) extent size 3902 next size
> > 1858692
> >
> >
> > what to check?

What's the error you hit when you do the task ?

there is no error but the table is created with the extents which is
less
than what i specify in create table command

with the extents we cannot load more data what we are having
at present?

so what is the reason that table is not created with the extents
what i specify?

regards

indikaj wrote:
> indikaj wrote:
> > calyanram@hotmail.com wrote:
> > > I am not able to increase the extent size , next size beyond a
> > > particular
> > > level even if specify more number
> > >
> > > what to do?
> > > example
> > > create table test (with 200 columns ) extent size 3902 next size
> > > 1858692
> > >
> > >
> > > what to check?
>
> What's the error you hit when you do the task ?

calyanram@hotmail.com wrote:
<snip>
> so what is the reason that table is not created with the extents
> what i specify?
<snip>
Have you checked what your attempting to do against the information
supplied in the manuals ? They're available online, here's a starting
point for you:
http://publib.boulder.ibm.com/infoce...c/admin340.htm

HTH

On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com
<calyanram@hotmail.com> wrote:
> I am not able to increase the extent size , next size beyond a
> particular
> level even if specify more number
>
> what to do?
> example
> create table test (with 200 columns ) extent size 3902 next size
> 1858692
>
>
> what to check?
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>

With what extent sizes is the table being created ?
You are asking for an initial extent of 3.9 Mb and a next extent of 1.85 Gb??
Seems to be the wrong way round!! Do you have the contiguous free
space available for extents of this size?? How wide is the table and
how many rows are you loading?

Keith

records is around 5 million
table colums are 70

how to check for the contigious space?


Keith Simmons wrote:
> On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com
> <calyanram@hotmail.com> wrote:
> > I am not able to increase the extent size , next size beyond a
> > particular
> > level even if specify more number
> >
> > what to do?
> > example
> > create table test (with 200 columns ) extent size 3902 next size
> > 1858692
> >
> >
> > what to check?
> >
> > _______________________________________________
> > Informix-list mailing list
> > Informix-list@iiug.org
> > http://www.iiug.org/mailman/listinfo/informix-list
> >
>
> With what extent sizes is the table being created ?
> You are asking for an initial extent of 3.9 Mb and a next extent of 1.85 Gb??
> Seems to be the wrong way round!! Do you have the contiguous free
> space available for extents of this size?? How wide is the table and
> how many rows are you loading?
>
> Keith

On 3 Oct 2006 07:01:48 -0700, calyanram@hotmail.com
<calyanram@hotmail.com> wrote:
> records is around 5 million
> table colums are 70
>
> how to check for the contigious space?
>
>
> Keith Simmons wrote:
> > On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com
> > <calyanram@hotmail.com> wrote:
> > > I am not able to increase the extent size , next size beyond a
> > > particular
> > > level even if specify more number
> > >
> > > what to do?
> > > example
> > > create table test (with 200 columns ) extent size 3902 next size
> > > 1858692
> > >
> > >
> > > what to check?
> > >
> > > _______________________________________________
> > > Informix-list mailing list
> > > Informix-list@iiug.org
> > > http://www.iiug.org/mailman/listinfo/informix-list
> > >
> >
> > With what extent sizes is the table being created ?
> > You are asking for an initial extent of 3.9 Mb and a next extent of 1.85 Gb??
> > Seems to be the wrong way round!! Do you have the contiguous free
> > space available for extents of this size?? How wide is the table and
> > how many rows are you loading?
> >
> > Keith
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>

This would appear to be approx. a 2Gb table. You do not say which
engine you have, so assuming you still have a 2Gb chunk limit and a
'normal' growth of 20% per annum I would suggest placing this table in
its own (new) dbspace with an extent size of 4900000 and a next size
of 2500000.
Detached indexes would also be a good idea.
You can check for contiguouc space with oncheck -?? database:table
(sorry, poor memory and no manual to hand) or oncheck -pe for the
entire instance.

Keith

actually still we are having more space in the dbspace.

around 25 chunks are empty.

we are using informix 7.31 and os is HPUX 11

I am able to recreate the table with larger extents but how to allocate
more
pages to it :
the data

Maximum row size 860
Number of special columns 11
Number of keys 11
Number of extents 3
Current serial value 1
First extent size 1951
Next extent size 929346
Number of pages allocated 1860643
Number of pages used 1763435
Number of data pages 1151792
Number of rows 2591100
Partition partnum 7341108
Partition lockid 7341108

It may grow up to 30 million records
initially the extent size is very less, but when i tried to increase ,
it increases size up to 929346?
the pages allocated is very less why?

why?

regards
s.kalyan.

malcolm weallans wrote:
> I use a script which checks for contiguous free space. It queries the
> sysmaster syschfree table. Any self-respecting database administrator can
> easily work out the script. I would provide it but I'm not in the office
> and so don't have all the details to hand. Generally I find that the amount
> of free space is fairly segmented just a few weeks after creating the
> dbspace. Especially if databases and/or tables and indexes are added and
> dropped.
> But you don't say which hardware platform, operating system, or IDS version.
> That information could be very relevant as there is a maximum chunk size of
> 2Gbytes on early versions and that artificially limits the extent size as
> extents cannot span chunks.
>
> Regards
>
> Malcolm
>
> -----Original Message-----
> From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
> On Behalf Of calyanram@hotmail.com
> Sent: 03 October 2006 15:02
> To: informix-list@iiug.org
> Subject: Re: Not able to increase the extent size?
>
>
> records is around 5 million
> table colums are 70
>
> how to check for the contigious space?
>
>
> Keith Simmons wrote:
> > On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com
> > <calyanram@hotmail.com> wrote:
> > > I am not able to increase the extent size , next size beyond a
> > > particular level even if specify more number
> > >
> > > what to do?
> > > example
> > > create table test (with 200 columns ) extent size 3902 next size
> > > 1858692
> > >
> > >
> > > what to check?
> > >
> > > _______________________________________________
> > > Informix-list mailing list
> > > Informix-list@iiug.org
> > > http://www.iiug.org/mailman/listinfo/informix-list
> > >
> >
> > With what extent sizes is the table being created ?
> > You are asking for an initial extent of 3.9 Mb and a next extent of
> > 1.85 Gb?? Seems to be the wrong way round!! Do you have the contiguous
> > free space available for extents of this size?? How wide is the table
> > and how many rows are you loading?
> >
> > Keith
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

calyanram@hotmail.com wrote:
> actually still we are having more space in the dbspace.
>
> around 25 chunks are empty.
>
> we are using informix 7.31 and os is HPUX 11
>
> I am able to recreate the table with larger extents but how to allocate
> more
> pages to it :
> the data
>
> Maximum row size 860
> Number of special columns 11
> Number of keys 11
> Number of extents 3
> Current serial value 1
> First extent size 1951
> Next extent size 929346
> Number of pages allocated 1860643
> Number of pages used 1763435
> Number of data pages 1151792
> Number of rows 2591100
> Partition partnum 7341108
> Partition lockid 7341108
>
> It may grow up to 30 million records
> initially the extent size is very less, but when i tried to increase ,
> it increases size up to 929346?
> the pages allocated is very less why?

If you do not have enough contiguous space in your chunks, then the
extent which will be initially allocated will be the largest contiguous
space. I suspect that your chunks are somewhat fragmented. Check out
oncheck -pe to view the extent mapping in the chunks.


>
> why?
>
> regards
> s.kalyan.
>
> malcolm weallans wrote:
>> I use a script which checks for contiguous free space. It queries the
>> sysmaster syschfree table. Any self-respecting database administrator can
>> easily work out the script. I would provide it but I'm not in the office
>> and so don't have all the details to hand. Generally I find that the amount
>> of free space is fairly segmented just a few weeks after creating the
>> dbspace. Especially if databases and/or tables and indexes are added and
>> dropped.
>> But you don't say which hardware platform, operating system, or IDS version.
>> That information could be very relevant as there is a maximum chunk size of
>> 2Gbytes on early versions and that artificially limits the extent size as
>> extents cannot span chunks.
>>
>> Regards
>>
>> Malcolm
>>
>> -----Original Message-----
>> From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
>> On Behalf Of calyanram@hotmail.com
>> Sent: 03 October 2006 15:02
>> To: informix-list@iiug.org
>> Subject: Re: Not able to increase the extent size?
>>
>>
>> records is around 5 million
>> table colums are 70
>>
>> how to check for the contigious space?
>>
>>
>> Keith Simmons wrote:
>>> On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com
>>> <calyanram@hotmail.com> wrote:
>>>> I am not able to increase the extent size , next size beyond a
>>>> particular level even if specify more number
>>>>
>>>> what to do?
>>>> example
>>>> create table test (with 200 columns ) extent size 3902 next size
>>>> 1858692
>>>>
>>>>
>>>> what to check?
>>>>
>>>> _______________________________________________
>>>> Informix-list mailing list
>>>> Informix-list@iiug.org
>>>> http://www.iiug.org/mailman/listinfo/informix-list
>>>>
>>> With what extent sizes is the table being created ?
>>> You are asking for an initial extent of 3.9 Mb and a next extent of
>>> 1.85 Gb?? Seems to be the wrong way round!! Do you have the contiguous
>>> free space available for extents of this size?? How wide is the table
>>> and how many rows are you loading?
>>>
>>> Keith
>> _______________________________________________
>> Informix-list mailing list
>> Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
>