[Info-ingres] 4k Cache

[Steve]

On Friday, September 10, 2021 at 12:28:10 AM UTC+10, Martin Bowes wrote:
> Hi Steve, 
> 
> Catalogs are typically 8k, but this would be version dependent. You can find out for sure by querying iitables. 
> 
> select distinct table_pagesize from iitables\g 
> 
> It's certainly reasonable to reduce the 2k cache and expand the 8k in its place, but you may like to monitor with dm420 to get some cache usage stats before going wild. 
> 
> Martin Bowes

Thanks Martin, I like your phrase "...before going wild." :)

Could running trace point DM420 cause a drag on the system and can I leave it running (for days), or should I run it for specific periods?