Yes you can mix them but why should you? A binary dump is safer (no ASCII conversion) and is always faster then a regular (ASCII) dump.
A Dump with several dump procs at the same time to multiple disks is very fast.
I can dig up a 4GL program which generates the multi-thread dump scripts if...
A regulair index rebuild takes account for 80% of the performance improvement of a full dump and load and is much easier to perform.
So an index rebuild a month will keep your database fast.
Peter
PROGRESS PATCH Version 8.3C22
We are using a RS6000 P660 (4xCPU 4GB RAM) connected through fiber to an IBM SAN (Storage Array Network). Each of the four databases has a RAID 0 (stripe) for the database and one single disk for the BI file. OS and swap are on a local disk.
My issue is that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.