I*SMers, Well, I didn't see many responses to Paul's question about unload - reload database reorganization, and most disconcerting, nothing from the gurus in Tucson.
I looked back in the archives, and there are a lot of exchanges regarding this issue, but my conclusion is, no one really knows how long this will take for large databases (>100GB). Evidently a database audit is not necessary if no errors are encountered, and the unload - reload really does improve performance and reduce database size. Given this, why doesn't IBM Tivoli / ADSM provide us with better ways to reorg our databases? In our situation, we can't possibly risk a reorg, considering the downtime could run into days or weeks. One response I saw in the archives told us that a 46GB database was reduced to 26GB and select statements "that would never finish before" now run in seconds to minutes. However, the time involved was 16 hours unload, 7 hours reload, and if an audit had been necessary, another 92 hours there. Why such a heavy price for something that would help us all? This is a sad state of affairs (my opinion). John Bremer
