reorgainising dbspaces
Posted in 1999
Hi
This weekend I intend to reorg some of my dbspaces, at the moment I have
3 databases all in the same dbspace with the indexes in a separate
dbspace. So I have decided to get smart and move them around. We are
using 730UC5 with Raid 1+0.
Here's the plan
level 0 archive
export all the databases
drop dbspaces
level 0 archive
create dbspaces
import databases
update stat's
test
level 0 archive
I have just a few quick questions:
First when reorging the dbspace is it best to have one dbspace per 2 gig
chunk or one dbspace per database or option c something else?
What is the dbimport command to import tables into separate dbspaces (I
couldn't find it in the books but I assuming it something like dbimport
'database name' -d 'dbspace name' -t 'table name' - can someone point me
in the direction of which book it is in (I have all the informix manuals
and it has managed to elude me).
Also how does the plan look - have I missed anything?
Thanks for all you help - I just need to check it with the gurus before
I do it to our production databases - didn't get a chance to do it to
our test databases.
cheer Bridget