Hello Gurus of the Informix World,
My ignorance of Informix system had brought me to your doorsteps yet
again.
My Problem:
I have 3 huge huge fact tables in my warehouse design and am trying to
fragment them. I want them to be fragmented monthly i.e. each month for
each year will have its own fragment for at lest for 2 years, later than
that I will keep fragments by years only.

I can use the Fragment by expression but I have to write scripts to add
a new table space and change the expression filter to accommodate the
new fragment every month. Is there any way of automating this process,
so that Informix would automatically decide on adding a new fragment
whenever it encounters a new distinct value like Year+month combination?

Can I also add all the fragments to the same dbspace so that all I have
to do is alter the Expression statement and not go about creating new
table spaces every time a new fragment is generated?

Regards,
Aash
sending to informix-list

--Hello Gurus of the Informix World,

i sure aint a guru......

--so that Informix would automatically decide on adding a new
-- fragment
-- whenever it encounters a new distinct value like Year+month
-- combination?

if you program it.... ahum afaik you can not create some sort
of trigger that when it does not fit in your frag scheme add a
new fragment; sounds really like a nice feature to have though!!!
there are things like remainder.. (would not use it...) everything that

does not fit i would put in a myremainder where the expression
is all that the others are not. before adding a new fragment
check 'myremainder'

--Can I also add all the fragments to the same dbspace so that all I
-- have to do is alter the Expression statement and not go about
-- creating new table spaces every time a new fragment is generated?

afaik V 10 can do so; You have to test it though since i have not
tested and played with this feature yet....

See you

Superboer.