[IQUG] [iqug] IQ catalog cache (high low settings) in 16.0

Mark Mumy markdmumy at gmail.com
Mon Sep 24 05:40:10 MST 2018


With that much RAM, I’d go with 4-8gb for the catalog.

How large is your db file?

Mark

> On Sep 24, 2018, at 7:37 AM, Louie, David <David.Louie at blackrock.com> wrote:
> 
> Hi Everyone,
>  
> We had a crash of our IQ 16.0 server with this error:
>  
> I. 09/24 07:38:33. Cache size adjusted to 1046664K
> I. 09/24 07:38:33. Cache size adjusted to 1046924K
> I. 09/24 07:38:33. Cache size adjusted to 1047188K
> I. 09/24 07:38:33. Cache size adjusted to 1047448K
> I. 09/24 07:38:33. Cache size adjusted to 1047712K
> I. 09/24 07:38:33. Cache size adjusted to 1047972K
> I. 09/24 07:38:33. Cache size adjusted to 1048240K
> I. 09/24 07:38:33. Cache size adjusted to 1048500K
> E. 09/24 07:38:33. Fatal error:  no free pages available in cache
> admcdba001{dlouie}:/u1/dlouie=>
>  
> This issue is due to undersized catalog cache according to some solved cases in the SAP incident logs.
>  
> I know these setting are probably low because this was based on when we had catalog issues back in 12.X
>  
> ### catalog low and high limit
> -cl 512m
> -ch 1024m
>  
>  
> What is the recommended values for 16.0?   Host has 758 GB of RAM.
>  
> 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/en-us/compliance/email-disclaimers <http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers> for further information.  Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy <http://www.blackrock.com/corporate/en-us/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/en-us/about-us/contacts-locations <http://www.blackrock.com/corporate/en-us/about-us/contacts-locations>.
> 
> © 2018 BlackRock, Inc. All rights reserved.
> 
> _______________________________________________
> IQUG mailing list
> IQUG at iqug.org <mailto:IQUG at iqug.org>
> http://iqug.org/mailman/listinfo/iqug <http://iqug.org/mailman/listinfo/iqug>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180924/2fc26ab9/attachment-0001.html>


More information about the IQUG mailing list