[IQUG] [iqug] Post IQ 16.0 upgrade FP index rebuild hangs

John Anthony chirayithaj at gmail.com
Tue Oct 1 06:42:00 MST 2019


Is TEMP maxed out ?

On Tue, Oct 1, 2019 at 8:34 AM Mark Mumy <markdmumy at gmail.com> wrote:

> Do you see anybIO?   CPU usage?   Grab pstacks 1-2 minutes apart and get
> 3-5 of them.  That will help support.
>
> Mark
>
> ========================
>
> 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.
>
>
>
> Thanks
>
> David
>
>
>
>
>
> This message may contain information that is confidential or privileged.
> If you are not the intended recipient, please advise the sender immediately
> and delete this message. See
> http://www.blackrock.com/corporate/compliance/email-disclaimers for
> further information.  Please refer to
> http://www.blackrock.com/corporate/compliance/privacy-policy for more
> information about BlackRock’s Privacy Policy.
>
> 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
> http://iqug.org/mailman/listinfo/iqug
>
> _______________________________________________
> IQUG mailing list
> IQUG at iqug.org
> http://iqug.org/mailman/listinfo/iqug

-- 
Sent from mobile device
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20191001/67d9326d/attachment.html>


More information about the IQUG mailing list