IDS 12.10.FC14
Solaris 10 1/13
Background:I have a legacy database that was laid out based on the Oracle S.A.M.E. (Stripe And Mirror Everything) strategy. It has served us well for many years. We have had no problem with performance, and there has been nearly zero admin effort on space issues (table organization, dbspaces layout, etc.)
But, now I would like to "evolve it" a little. I want to do two things, immediately; and, possibly a third thing a bit later.
First two things I want to do:
1) Put indexes into a separate dbspace. I want to use wide (16K) pages for indexes. (Our current dbspace pages are 2K.)
2) Move the database out of the root dbspace.
Questions:I would solicit opinions related to these objectives:
1) How best to move the indexes?
My first thought is to write a script using ALTER FRAGMENT. Or, I wonder if HPL could be of use (I have to admit that I have only rarely used HPL, and need to "bone up" on it).
2) Does the order matter?
That is, move the indexes to a new dbspace, and then use dbexport/dbimport to move the database (system catalog and all tables) to a new dbspace. Or, move the database first, then move the indexes.
At some later time, I will work on creating multiple dbspaces and placing tables (possibly fragmented) into them. But, steps 1 & 2, above, are first.
Thank you for any comments.
Regards,
DG
------------------------------
David Grove
------------------------------
#Informix