Re-building a database server
Posted in 1998
I have a client with a database server (v7.24) which contains a single
database, but which has multiple dbspaces. It's important that a table
remains in its allocated dbspace because the application (Lawson)
maintains its own table/dbspace mapping.
I want to re-build the database server because it currently has stupid
chunk names, and I want to impose a new standard. Obviously I must
dbexport or ununload, then scrap and re-build the server, then
dbimport/onload.
I'll have no problems restoring tables to their allocated dbspaces with
dbimport. But it will be slow (this is a 10GNyte database). But onload
will only restore all tables to the dbspace specifed in my onload
statement.
Does anyone have any other ideas?
Thanks
Neil Truby
aracnet Limited
Weybridge, UK
P.S. Furthermore, I may want to repeat this exercise on another client's
v5.02 server, and put mirroring on the re-built server. Does anyone
have any views on whether it's quicker to re-build the server first with
dbimport/tbload, THEN put on mirroring, or vice-versa?