elovelo

ok, JP. thank you, I will give ot a try with shorter deleteSleep

Thank you. And I suppose there is no way to increase the packet size of these 1000 rows?

Hello JP, so, I restarted the logger with flag 113 and the Purge task works indeed, but apparently it's very slow as it deletes 1000 rows at a time every 100 ms as per the attached ss with logs. It started with the biggest table for the monitored instance, XXX_OpObjAct. It's over 71 GB in size and has over 220 000 000 rows and there are over 40 000 000 rows with Timestamp < '2025/08/08 15:40:03' that are to be deleted as per daysToKeep=31 Is there a way to speed up this purging, e.g. deleting the...

Hello, JP, thank you for a fast response. I will indeed restart that particular logger with the provided traceflag and post any findings worth sharing. will these extra statements be logged in the logger's log file or echoed to the terminal ? I will also try to delete rows from xxx_TrendsCfg table and restart asemon_logger to see if this helps. as for the data dependency between mentioned tables , if StmtPlan, StmObj, StmtPlnHK and StmtSQLHK depend on StmtStat, then this does not make sense to me...

Hello JPM, I am using Asemon v3.2.3 to monitor ASE instances in version 16.0 SP02 PL07 and 16.0 SP04 PL06 HF1. Both Asemon and ASE run on AIX 7.2 For all the instances some of the data for certain tables are kept way over the 'daysToKeep' parameter. For example, for one asemon logger, the 'daysToKeep' is set to 31 days, the 'deleteSleep' is set to default 100, but for all of the tables, the retention period has been crossed by a week now (38 days), and for some by six months already (since enabling...

Hello JPM, I am using Asemon v3.2.3 to monitor ASE instances in version 16.0 SP02 PL07 and 16.0 SP04 PL06 HF1. Both Asemon and ASE run on AIX 7.2 For all the instances some of the data for certain tables are kept way over the 'daysToKeep' parameter. For example, for one asemon logger, the 'daysToKeep' is set to 31 days, the 'deleteSleep' is set to default 100, but for all of the tables, the retention period has been crossed by a week now (38 days), and for some by six months already (since enabling...

Hello JPM, I am using Asemon v3.2.3 to monitor ASE instances in version 16.0 SP02 PL07 and 16.0 SP04 PL06 HF1. Both Asemon and ASE run on AIX 7.2 For all the instances some of the data for certain tables are kept way over the 'daysToKeep' parameter. For example, for one asemon logger, the 'daysToKeep' is set to 31 days, the 'deleteSleep' is set to default 100, but for all of the tables, the retention period has been crossed by a week now (38 days), and for some by six months already (since enabling...