RE: ontape restore takes forever .....
Look for 7.11, it contains A LOT of bug fixes, one of which is the ontape performance problem.
Jon Vemo
----------
From: Jack Gross[SMTP:gross@pb.net]
Sent: Friday, October 06, 1995 1:08 PM
To: informix-list@rmy.emory.edu
Subject: Re: ontape restore takes forever .....
In article <451e3d$cmv@eccdb1.pms.ford.com>,
Michael Reed - Radiix <mreed@ese721> wrote:
}Jack Gross (gross@pb.net) wrote:
}
}: Hi, we are running Informix Online 7.10 under Solaris 2.4 and found that when
}: attempting to restore a backup that was made using ontape that it takes
}: a very long time. Our database is about 4.5 GB with about 2 GB of data in
}: blobspaces and the rest in dbspace. A backup using ontape takes about
}: two hours while a full restore takes about ten hours. In fact, I have been
}: trying to set up replication which requires that I build the secondary server
}: from a backup of the primary and it is painfully slow.
}
}: I have asked Informix about this and they are not aware of a problem !!!!
}
}
}
}: Jack Gross gross@dpg.rnb.com
}: Derivative Products Group Republic National Bank of New York
}: (212)525-8000
}
}You didn't mention which version of 7.10 you were using. That
}would be interesting for us to know. I became aware of a similar
}problem in 7.10.UD1: A known bug causes the archives to take
}four (4) times longer than in 7.10.UC1. Perhaps they are related.
}In any case, I'd personally be interested in what you find out
}since I'm on the same platform.
}
}Regards,
}
}Michael Reed, Radiix, Inc.
}3588 Plymouth Rd. suite 257
}Ann Arbor, MI 48105
}313-677-UNIX mreed@radiix.com
I am actualy running 7.10 UC1 which really scares me if UD1 will be four times
slower than the snails pace that I am already at !!!!!
Jack Gross gross@dpg.rnb.com
Derivative Products Group Republic National Bank of New York
(212)525-8000