[IQUG] [iqug] Post IQ 16.0 upgrade FP index rebuild hangs
markdmumy at gmail.com
Tue Oct 1 06:34:23 MST 2019
Do you see anybIO? CPU usage? Grab pstacks 1-2 minutes apart and get 3-5 of them. That will help support.
Sent from my mobile device
> On Oct 1, 2019, at 09:31, Louie, David <David.Louie at blackrock.com> wrote:
> We are trying to rebuild all FP indices on our large 30 TB table. We run about 60% of it and then had to kill the flight index to hand back the database to the DEV team.
> We restarted it and it’s been running for 4 days and seems stuck as sp_iqtransaction shows now movement on main or temp kb usage.
> Anyone come across this issue?
> Not sure dropping the connection and restart will fix it.
> For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/about-us/contacts-locations.
> © 2019 BlackRock, Inc. All rights reserved.
> IQUG mailing list
> IQUG at iqug.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the IQUG