Reconfiguration Estimator time estimates are affected by how busy the system is while the estimates are being generated. The accuracy of estimates is improved when other system work is minimized, and best when Reconfiguration Estimator runs on an idle system.
If you are adding AMPs to the configuration, Reconfig Estimator asks you which tables will be redistributed: Data Dictionary tables, specific user tables, all tables, or no tables.
Reconfig Estimator performs a sample run of the Reconfiguration utility in order to determine estimation constants that are appropriate for the system. Because this process involves inserting and deleting sample data, the program requires the user name and password of an account that has rights to create and insert table rows. Create a user account exclusively for the use of Reconfiguration Estimator, and assign it a non-critical password. (The username and password you enter are visible in Reconfiguration Estimator user interface.) Grant the account all privileges specified above. The account should have at least .5 to 1 GB of perm space per system AMP.
Best estimates are obtained when Pseudo Reconfig (as noted in the utility output) runs for five to ten minutes on an idle system. The minimal time required to obtain reasonable estimates is proportional to how busy the system is while the estimates are being calculated. For example, if the system is only 10% idle, best estimates are obtained if the utility runs for 50 to 100 minutes. If Reconfiguration Estimator runs for less than an optimal time, run the utility again, after increasing the amount of perm space assigned to the account used by Reconfig Estimator.
If Reconfiguration Estimator encounters any problems, the estimation process aborts and returns an error message.
For more information on the reconfiguration process, see Reconfiguration Utility (reconfig).