Can I kill a Dense restructure?
jtsOct 26 2009 — edited Dec 15 2011Follow-up to my other problem, we had a sparse dimension that actually fit the profile of being able to spread evenly through the block so we made it dense.
The restructure is now on 4.5 hours and still going. We do not have that big of a database.
Our number of blocks is all sparse dimensions added up 6 * 8 * 9 * 9 * 9 * 26 * 56 * 91 * 961 = 4455484330752
Our previous block size was 49000, the adjustment would make the block size 8 * 4 * 7 * 4 * 2 = 1792 * 8 bytes = 14336
Yes we have that many dimensions and yes come Dec we do a new app we will be trimming this CONSIDERABLY...
I inherited this mess and trying to make it more efficient. Basically though this restructure is not going as planned.
Can I simply stop the Hyperion services and then trash the .pan and .inn files then restart?
JTS