#43 ASEMON is writing hundreds of pages into the iq message log every minute

[Ranga Rajen Komanduri]

Sybase iq upgraded from SAP IQ 16.1 SP02 PL06 to SAP IQ 16.1 SP05 PL04 and ever since then ASEMON is writing hundreds of pages into the iq message log every minute which is causing performance issue and also log became unreadable with log of ASEMON messages

I. 07/27 01:28:38. 0000000035 [hos_svbio::GetMonitorStats ] Value of stats : _numReads : 1457
I. 07/27 01:28:38. 0000000035 _numWrites : 6966
I. 07/27 01:28:38. 0000000035 _numReadBytes :756449280
I. 07/27 01:28:38. 0000000035 _numWriteBytes : 2404122624
I. 07/27 01:28:38. 0000000035 [hos_svbio::GetMonitorStats ] Value of stats : _numReads : 3413
I. 07/27 01:28:38. 0000000035 _numWrites : 2161
I. 07/27 01:28:38. 0000000035 _numReadBytes :765100032
I. 07/27 01:28:38. 0000000035 _numWriteBytes : 432996352
I. 07/27 01:28:38. 0000000035 [hos_svbio::GetMonitorStats ] Value of stats : _numReads : 1362
I. 07/27 01:28:38. 0000000035 _numWrites : 1093
I. 07/27 01:28:38. 0000000035 _numReadBytes :80183296
I. 07/27 01:28:38. 0000000035 _numWriteBytes : 75694080
I. 07/27 01:28:38. 0000000035 [hos_svbio::GetMonitorStats ] Value of stats : _numReads : 2570
I. 07/27 01:28:38. 0000000035 _numWrites : 1828
I. 07/27 01:28:38. 0000000035 _numReadBytes :611680256
I. 07/27 01:28:38. 0000000035 _numWriteBytes : 362708992
I. 07/27 01:28:38. 0000000035 [hos_svbio::GetMonitorStats ] Value of stats : _numReads : 2997
I. 07/27 01:28:38. 0000000035 _numWrites : 2161
I. 07/27 01:28:38. 0000000035 _numReadBytes :701333504
I. 07/27 01:28:38. 0000000035 _numWriteBytes : 501710848
I. 07/27 01:28:38. 0000000035 [hos_svbio::GetMonitorStats ] Value of stats : _numReads : 3062
I. 07/27 01:28:38. 0000000035 _numWrites : 2161
I. 07/27 01:28:38. 0000000035 _numReadBytes :760283136
I. 07/27 01:28:38. 0000000035 _numWriteBytes : 435388416
I. 07/27 01:28:38. 0000000035 [hos_svbio::GetMonitorStats ] Value of stats : _numReads : 3027
I. 07/27 01:28:38. 0000000035 _numWrites : 2161
I. 07/27 01:28:38. 0000000035 _numReadBytes :670302208
I. 07/27 01:28:38. 0000000035 _numWriteBytes : 431816704

[Jean-Paul Martin]

Hi,
I could reproduce this problem with IQ16.1SP05PL07

The problem is generated by the IQSYSMON collector. You can deactivate this collector by putting it in comment in the config file :

<!--             <md> IQSysmon.xml             </md> -->

This collector execute IQ commands :
exec sp_iqsysmon start_monitor
and
exec sp_iqsysmon stop_monitor
These commands generate these new messages in IQ msg file

You can open an incident at SAP support to ask for a fix for this problem

Best regards
JP