var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Time Require to rebuild of indexes
I have 1 very big table whose data is in range of crores.
When i restarted the server and then database some of the indexes of that table is invalid so rebuilding of indexes is started automatically after crash recovery.
Can anyone please suggest how to check when (time prediction) this rebuilding of indexes on that table is done?
I mean how to determine amount of indexing is done and the time to take the completion of indexes?
Also please suggest can we stop this index rebuilding to load the data in this table?
Thanks in advance
Originally Posted by Pra
As i understood, Your index recreation is taking a lot of time and you want an estimate about its completion.
1. You can do "db2top -d <dbname>" ----> then press "u"
u= utility (progress in real time)
2. You can query SYSIBMADM.SNAPUTIL_PROGRESS for UTILITY_TYPE = RESTART_RECREATE_INDEX
i will revert on stopping index creation shortly.
I afraid Index rebuilt can not be stopped.
Just curious why don't you set
db2 update db cfg using INDEXREC RESTART
(if DB startup time is not critical)
This will prevent such situation to happen .