[Info-ingres] 4k Cache

[Martin Bowes]

Hi Steve,

Trace point dm420 is just a quick snapshot of the existing buffer stats at the time you execute it.
So it has no impact on the system. Also you don't turn it on and leave it on, it's a matter of execute, wait, execute. Typically I would suggest a day between executions.

The default output channel is II_DBMS_LOG, but this can be altered if you do as follows:
set trace output '/full/path/to/file';
set trace point dm420;
set trace nooutput;

Typically I'd connect to iidbdb to do this, but you could use any database.

Best of luck,

Marty
-----Original Message-----
From: Steve <s.anderson.au at gmail.com> 
Sent: 10 September 2021 11:06
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] 4k Cache

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? 
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres