Activity for elovelo
-
elovelo posted a comment on discussion Help
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...
-
-
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, and for some by six months already. See attached ss. I check...
-
Hello JPM, I am running Asemon v 3.2.3 on ASE 16.0 SP02 PL07. Today MonSQL collector reported this kind 'null error' followed by an icomplete, but long query text: Any idea what is the cause ? Maybe the query was to long to fit into a column of one of the MonSQL tables ?
-
Hello JP, I am running Asemon V3.2.3 that monitors ASE 16.0 SP02 PL07. If I access Sysmon's 'dcache_dtl' section I see this error ( see sysmon_dchace_dtl_overflow.png ) Can you advise where can this be corrected ? I suppose it's the proc 'sp_sysmon_dcache_dtl_V16' and from this output it looks like it failed to display maybe the 'Found in wash' figure ? In the procedure I find these variables: declare @tmpint bigint / temp var for integer storage / declare @tmpint2 int / temp var for integer storage...
-
Hello JP, I am running Asemon V3.2.3 that monitors ASE 16.0 SP02 PL07. If I access Sysmon's 'dcache_dtl' section I see this error ( see sysmon_dchace_dtl_overflow.png ) Can you advise where can this be corrected ? I suppose it's the proc 'sp_sysmon_dcache_dtl_V16' and from this output it looks like it failed to display maybe the 'Found in wash' figure ? In the procedure I find these variables: declare @tmpint bigint / temp var for integer storage / declare @tmpint2 int / temp var for integer storage...
-
Hello JP, I am running Asemon V3.2.3 that monitors ASE 16.0 SP02 PL07. If I access Sysmon's 'dcache_dtl' section I see this error: Can you advise where can this be corrected ? I suppose it's the proc 'sp_sysmon_dcache_dtl_V16' and from this output it looks like it failed to display maybe the 'Found in wash' figure ? In the procedure I find these variables: declare @tmpint bigint / temp var for integer storage / declare @tmpint2 int / temp var for integer storage / ~~~* Further down I find this: /...
-
Hello JP, thank you very much. This new schema solved the problem. I don't see any new numeric overflow errors pertaining to this table now.
-
Hello Jean-Paul, I run Asemon 3.2.3. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
Hello Jean-Paul, I run Asemon 3.2.2. on ASE 16.0 SP02 PL07. The logger log showed this error: <server>_DataCache - Error in loop on table '<server>_DataCache' on connection : 'ARCH'. Error=0 state=JZ00B. SQL message=JZ00B: Numeric over flow. asemon_logger.AsemonSQLException: JZ00B: Numeric overflow. at asemon_logger.Archive_ASE.saveValues(Archive_ASE.java:373) at asemon_logger.CollectorGeneric.saveValues(CollectorGeneric.java:475) at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:276)...
-
yes, I swapped this file with the one you provided, but I haven't edited anything in it. I only edited sql_SpaceUsed_statistics.php
-
yes, I swapped this file with the one you provided, but I haven't edited anything in it.
-
Hi JP, yes, there's is this error when I run the collector: [php:error] [pid 1080] [client ::1:34046] PHP Fatal error: Uncaught PDOException: SQLSTATE[ZZZZZ]: <<unknown error="">>: 207 [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Invalid column name 'LastTranLogEndDumpTime'.\n (SQLExecute[207] at ./ext/pdo_odbc/odbc_stmt.c:254) in /var/www/html/asemon_report/COMMON/connectArchiveServer.php:237\nStack trace:\n#0 /var/www/html/asemon_report/COMMON/connectArchiveServer.php(237): PDO->query()\n#1...
-
Hi JP, thank you, with the latest SDK 16.0 SP04 PL06 all the errors I reported are gone except for the 'SpaceUsed' collector. I am still getting: * Error loading 'Space used in databases' : Internal Server Error Script : ../ASE/sql/sqlSpaceUsedstatistics.php*
-
Hi JP, thank you, with the latest SDK 16.0 SP04 PL06 all the errors I reported are gone except for the 'SpaceUsed' collector. I am still getting: Error loading 'Space used in databases' : Internal Server Error Script : ../ASE/sql/sql_SpaceUsed_statistics.php
-
Thank you J.P., it's working now.
-
Hello Jean-Pierre, yes, I followed the instruction fully. Again, this is my my /etc/odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID=sa Password=........ Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 Here are the required packages that I have installed: sudo dpkg -l | egrep -i 'php|odbc|pdo|dbo' ii ifupdown 0.8.36+nmu1ubuntu3.1 amd64 high level tools to configure network interfaces ii libapache2-mod-php 2:8.1+92ubuntu1...
-
Hello. I just set up Asemon 3.2.3 on linux mint to monitor ASE 16.0 GA PL01 (DT license). I have the logger and the report components installed with archive database created. My PHP is 8.1.2. I am able to login to ASE using unix ODBC (see ss).Here is the odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID= Password= Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 But when I try to connect to the archive server via Asemon...
-
Ok, and what about the missing sybsecurity database ?
-
Hello, thank you, now it's working. Is there a reason why you don't want it to lookup read-only params ?
-
Hi JP, good to know it runs only one time per day. right now I am playing around with the logger and I launch it for brief periods of time so it explains why I don't see any data. as for the min table size, the databases it monitors have tables of this size and much larger. tthanks!
-
Hello Jean-Pierre, I have Asemon v3.2.3 set up on ASE 16.0 SP02 PL07 to monitor ASE instance of the same version. The 'Fragmentation' collector does not show data regardless of the time range I select. I tried with reducing the 'Min page cnt' to 1 or 0 to see if it makes any difference, but it does not. See attached ss. I also checked the tables ".$server."_Fragment and indeed, they are empty. Any idea why is that ? Thanks !
-
Hi Jean-Paul, I discovered the same issue with 'SpaceUsed' collector. In file 'sql_SpaceUsed_statistics.php' I had to comment out the select of columns 'BckET', 'Bck_s', 'BtranET', 'Btran_s', 'LastChkpt' from tables ".$ServerName."_AseDbSpce' and ".$ServerName."_OpenDbs as these columns do not exist in these tables. Also, this collector does not show the 'sybsecurity' database which I have set up on the monitored server whereas the 'Logs contention' collector in the 'Summary' shows this db.
-
Hi Jean-Paul, I discovered the same issue with 'SpaceUsed' collector. In file 'sql_SpaceUsed_statistics.php' I had to comment out the select of columns 'BckET', 'Bck_s', 'BtranET', 'Btran_s', 'LastChkpt' from table ".$ServerName."_AseDbSpce' and ".$ServerName."_OpenDbs as these columns do not exist in these tables.
-
Hello, I have Asemon v3.2.3 set up to monitor ASE 16.0 SP02 PL07. The archive db also runs on ASE 16.0 SP02PL07. In 'AllAseParams' collector I noticed that there are missing parameters 'total physical memory' and 'total logical memory'. I both used filters on the table like '%memory%', '%physical%', '%logical%', '%total%' and scrolled down the whole list and they are not there. See attached ss. Any idea why they are missing ?
-
Hello Jean-Pierre, yes, I followed the instruction fully. Again, this is my my /etc/odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID=sa Password=........ Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=marek-ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 Here are the required packages that I have installed: sudo dpkg -l | egrep -i 'php|odbc|pdo|dbo' ii ifupdown 0.8.36+nmu1ubuntu3.1 amd64 high level tools to configure network interfaces ii libapache2-mod-php 2:8.1+92ubuntu1...
-
Hello Jean-Pierre, yes, I followed the instruction fully. Again, this is my my /etc/odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID=sa Password=........ Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=marek-ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 Here are the required packages that I have installed: sudo dpkg -l | egrep -i 'php|odbc|pdo|dbo' ii ifupdown 0.8.36+nmu1ubuntu3.1 amd64 high level tools to configure network interfaces ii libapache2-mod-php 2:8.1+92ubuntu1...
-
Hello Jean-Pierre, yes, I followed the instruction fully. Again, this is my my /etc/odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID=sa Password=........ Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=marek-ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 Here are the required packages that I have installed: sudo dpkg -l | egrep -i 'php|odbc|pdo|dbo' ii ifupdown 0.8.36+nmu1ubuntu3.1 amd64 high level tools to configure network interfaces ii libapache2-mod-php 2:8.1+92ubuntu1...
-
Hello Jean-Pierre, yes, I followed the instruction fully. Again, this is my my /etc/odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID=sa Password=........ Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=marek-ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 Here are the required packages that I have installed: sudo dpkg -l | egrep -i 'php|odbc|pdo|dbo' ii ifupdown 0.8.36+nmu1ubuntu3.1 amd64 high level tools to configure network interfaces ii libapache2-mod-php 2:8.1+92ubuntu1...
-
Hello Jean-Pierre, yes, I followed the instruction fully. Again, this is my my /etc/odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID=sa Password=........ Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=marek-ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 Here are the required packages that I have installed: sudo dpkg -l | egrep -i 'php|odbc|pdo|dbo' ii ifupdown 0.8.36+nmu1ubuntu3.1 amd64 high level tools to configure network interfaces ii libapache2-mod-php 2:8.1+92ubuntu1...
-
Hey. I found this presentation about Asemon from 2015. Hope that Jean-Paul does not mind posting it here.
-
Hello Martin, it's working now, thank you :)
-
Hello. I just set up Asemon 3.2.3 on linux mint to monitor ASE 16.0 GA PL01 (DT license). I have the logger and the report components installed with archive database created. My PHP is 8.1.2. I am able to login to ASE using unix ODBC (see ss).Here is the odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID= Password= Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=marek-ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 But when I try to connect to the archive server via...
-
Hello. I just set up Asemon 3.2.3 on linux mint to monitor ASE 16.0 GA PL01 (DT license). I have the logger and the report components installed with archive database created. My PHP is 8.1.2. I am able to login to ASE using unix ODBC (see ss).Here is the odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID= Password= Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=marek-ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 But when I try to connect to the archive server via...
-
Hello. I just set up Asemon 3.2.3 on linux mint to monitor ASE 16.0 GA PL01 (DT license). I have the logger and the report components installed with archive database created. My PHP is 8.1.2. I am able to login to ASE using unix ODBC (see ss).Here is the odbc.ini file: [SAPASE] Description=Sybase ODBC Data Source UserID= Password= Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so Server=marek-ThinkPad-T460 Port=5000 Database=asemon UseCursor=1 But when I try to connect to the archive server via...
-
ok, got it. thank you, Martin.
-
thanks Martin. in the meantime I found a comment in that query just before these columns' values set referring to SP04, and it got mw thinking that it's probably not compatible with SP02, but I didn't want to spam this thread until someone responds. we are planning to upgrade to SP04 somehwere next year anyway, but until then I'll keep these columns commented out. Thanks! P.S. by the way, SAP plans to release new ASE 16.1 in this quarter. Do you already have plans for releasing Asemon version complatible...
-
thanks Martin. in the meantime I found a comment in that query just before these columns' values set referring to SP04, and it got mw thinking that it's probably not compatible with SP02, but I didn't want to spam this thread until someone responds. we are planning to upgrade to SP04 somehwere next year anyway, but until then I'll keep these columns commented out. Thanks!
-
Hello. Recently I deployed ASEmon v.3.2.3. Some of the metrics that are displayed in table format allow for quick lookup and edit of the sql query that provides the data. The query is shown in this white pop window which allows you to edit it, but I don't see any 'apply' or 'ok' or 'confirm' button. If I add some changes and click on the close button, they are lost. See attached ss. Does ASEmon support this functionality of adhoc changes to collectors' queries ? If so how can I apply them in the...
-
Hello. Recently I deployed ASEmon v.3.2.3. Some of the metrics that are displayed in table format allow for quick lookup and edit of the sql query that provides the data. The query is shown in this white pop window which allows you to edit it, but I don't see any 'apply' or 'ok' or 'confirm' button. If I add some changes and click on the close button, they are lost. See attached ss. Does ASEmon support this functionality of adhoc changes to collectors' queries ? If so how can I apply them in the...
-
Ok, If found this query in file \AsemonReportSrv\Asemon_report\ASE\sql\sql_alldatabases.php And I commented out this portion: execute ('update #dbinfos set -- BckET = (select case when max(BackupEndTime) is null then null else convert (varchar, max(BackupEndTime), 111)+'' ''+convert (varchar, max(BackupEndTime), 108)+''.''+convert(varchar, datepart(ms,max(BackupEndTime))) end from '+@srvname+'_OpenDbs where DBID=I.dbid and LastBackupFailed=0), -- Bck_s = (select datediff(ss,max(BackupStartTime),max(BackupEndTime))...
-
Hello. Recently I deployed ASEmon v.3.2.3. Some of the metrics that are displayed in table format allow for quick lookup and edit of the sql query that provides the data. The query is shown in this white pop window which allows you to edit it, but I don't see any 'apply' or 'ok' or 'confirm' button. If I add some changes and click on the close button, they are lost. See attached ss. Does ASEmon support this functionality of adhoc changes to collectors' queries ? If so how can I apply them in the...
-
Hello everyone. Recently I deployed ASEmon v.3.2.3 to monitor my ASE instances in version 16.0 SP02 PL07. The archive server is also in the same version. I have the archive server setup with asemon db, as well as the asemon logger. I can view metrics ok, but the problem is with the option AllDatabasesList. If I click on it I get: ERROR Module : refreshgrid() Gridname : AllDatabasesList Message : Sybase error in msg_handler_GET : 207 severity : 16 state : 4 line : 1 Msg : Invalid column name 'LastTranLogEndDumpTime'....
-
Hello everyone. Recently I deployed ASEmon v3.2.3 to monitor ASE instances. Both the archive and monitored servers are in version 16.0 SP02 PL07. The asemon db and the asemon logger are all setup. I can view the metrics, but the option 'AllAseParams ' does not show anything for the monitored server. See attached ss. and Here is the query: ==================================== set nocount on declare @tname varchar(255), @srvname varchar(255) create table #aseparamsinfos ( srvname varchar(255) not null,...
-
Hello everyone. Recently I deployed ASEmon v.3.2.3 to monitor my ASE instances in version 16.0 SP02 PL07. The archive server is also in the same version. I have the archive server setup with asemon db, as well as the asemon logger. I can view metrics ok, but the problem is with the option AllDatabasesList. If I click on it I get: ERROR Module : refreshgrid() Gridname : AllDatabasesList Message : Sybase error in msg_handler_GET : 207 severity : 16 state : 4 line : 1 Msg : Invalid column name 'LastTranLogEndDumpTime'....
1
