Dear Aash,
Sorry , nothing in Informix like automatic fragment creation
based on expression. The problem or better one of the problems, is,
that IDS does not have a sematic understanding of your sexpressions
used for fragmenting , so it would have a hard time to guess what
expression to use for the next fragment.
You can have a remainder fragment (for all the rest) but that is,
I guess, NOT what you want.
In IDS 10 it is possible to have multiple fragments or better said
partitions in one dbspace. For the ins and outs of this see IDS
10 doukmentation (available somewhere under
http://www.ibm.com/software/data/informix/pubs/
or (if you like it better )
http://www-306.ibm.com/software/data/informix/pubs/
:-)
The 'multiple fragment in one dbspace' is one of the nice new
features in IDS 10.
Best regards
Tilman
-----Urspr|ngliche Nachricht-----
Von: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] Im Auftrag von Aashish Ramsinghani - ASDC, Chennai
Gesendet: 13 December 2005 11:20
An: informix-list@iiug.org
Betreff: Problem with Table fragments
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
sending to informix-list