T
TheMadDBA
Guest
Agree with all of the issues that George identified, as well as the frustration about trying run a real world multiple TB Progress database. Uptime, backups, AI applies and online maintenance are all a huge pain compared to Oracle and DB2. The new idxbuild is a major improvment and we really need those kinds of improvements for most of the database utilities. As far as your idxfix issue George.... that utility (along with several others) are notorious for making tons of small IO operations. If you have enough filesystem cache then you can drastically reduce the amount of time required to run idxfix/idxcheck. Starting idxfix on a copy of production the initial estimate was several days. I was able to use dd (over and over again as the utility progressed through the index extents) to read the contents of the index area into the AIX buffer cache. We were able to run the idxfix in a few hours using this approach... although it required much more of my time to keep the buffer cache filled. We shouldn't have to do tricks like this in a modern DB, but hopefully that trick can help you out until the utilities are fixed.
Continue reading...
Continue reading...