Transfer Online 4.1 -> Online 5.0
Posted in 1993
Hello,
I need some net.wisdom about the best way to transfer a complete ONLINE
System from a machine running 4.1 to a machine running 5.0
Current config:
Siemens-Nixdorf MX300-30, Online 4.1, root-dbspace mirrored (via
the Online-mechanism) ca. 8MB, data-dbspace unmirrored ca. 300 MB
New Machine:
Siemens-Nixdorf RM400-10, Online 5.0
We haven't decided yet how to configure the disks of the new machine.
There will be 3 harddisks with 1GB each. We are currently thinking of
using 1 disk for the OS, swap, tmp, and home and the two other disks
for online: One as primary and one as mirror, using the OS mirroring
mechanisms (not Online's, I was told that using the OS for mirroring
is probably faster).
Here are my qestions:
1) What is the best way to configure the disks? This machine will primari-
ly be used as a database server and maybe secondarily as a file server
via NFS (this is of very minor importance).
That is why we want to use two disks for Online (raw devices) and one
for everything else. Is that a good idea? Should we only configure
one large dbspace (rootdbs) or a small rootdbs and one ore more
others? Blobs are of no big significance for us, and we should be
able to store them in a "normal" dbspace.
2) How do we best transfer our current databases to the new Online system?
Of course, we want to preserve current extent/next sizes. I have no
idea whether dbexport/import, tbunload/load or even dbunload/load
are the best choice. Besides, since I haven't got the 5.0 manuals yet,
I don't even know if there are significant differences against 4.1
which I will have to take into account.
All I know now that I want to make the transition as quickly as possible,
since our current machine is very overloaded and VERY slow :-(
All input will be appreciated. I will be happy to post the results of
our transition to this group.
Regards, Richard
--
+----------------------------+-------------------------------------------+
| Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de |
| EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 |
| Klinikum Grosshadern | FAX : +49-89-7095-8886 |
| 81366 Munich, Germany | |
+----------------------------+-------------------------------------------+