Activity for asemon
-
Jean-Paul Martin posted a comment on ticket #53
Sorry, I didn't see it connects to ASE but the problem occurs after Try a more recent ODBC Sybase driver (SDK 16.0 SP04 PL08 available)
-
Hi Nicola seems your ODBC connection on RedHat 9 is not correctly configured Did it work before (with ODBC) ? or this pb came with 3.2.6 ? There is little doc for ODBC install on https://sourceforge.net/p/asemon/wiki/install%20asemon_report%20on%20Linux%20with%20PHP8/ Cannot help you more Best regards JP
-
Anonymous created ticket #53
very big memory request by connectArchiveServer.php
-
Steve Knell posted a comment on discussion Help
Hi J-P We are being asked to add authentication to the Asemon reporter website - we are using PHP-FPM on the back-end. Is there any simple way to do that, please? Or any docs which might help us? OpenID is the preferred route here. Thanks, Steve
-
Salut Catherine, I changed a lot of things in this collector since V3.2.5 It seems the SQL you are retreiving is NULL It seems also you activated debug trace 104 (the line 1214 in this asemon version is a debug line) Test with a more recent version (last one in V3.2.6b) Sorry, cannot help more Regards Jean Paul
-
cmesnil created ticket #52
<servername>_MonSQL - Error in loop. java.lang.NullPointerException
-
Ok good, I changed the sampleConfig.xml file to include this SSL option Best regards JP
-
Anonymous posted a comment on ticket #26
OOOooooohohoooo It works. In the <monitoredsrv> section I had : <usessl> YES </usessl></monitoredsrv> (this is what several sources say, even here in the ticket it's all in lowercase) So java didn't do "Enable SSL". The correct thing is: <usessl> YES </usessl> 2026/02/17 09:24:40.447 main - Try to connect to srv : AKKK1 2026/02/17 09:24:40.448 main - Srv found in interfaces or SQL.INI file. Host=akkk1.cz Port=4999 2026/02/17 09:24:40.448 main - Using password from passwords file for 'AKKK1.asemon'...
-
you should have : <useSSL> YES </useSSL> in this section (the SampleConfig.xml doesn't mention this)
-
So it seems you have a config problem in the asemon_config file Can you show me your section : ~~~ <monitoredsrv> <srv> <name> enter_monitored_server_name_here </name> <user> enter_monitored_user_name_here </user> <usekerberos> enter_YES_or_NO </usekerberos> <charset> enter_monitored_server_charset_here_or_leave_empty </charset> <packet_size> </packet_size> <srvdescriptor> enter_monitored_server_descriptor_name_here_ex_ASEV125 </srvdescriptor> <purgearchive daystokeep="90" deletesleep="100"> <textsize>...
-
Anonymous posted a comment on ticket #26
Message "SSL is activated" in the outpout missing.
-
There is a technical note on SAP support site describing actions to do for using SSL with V16 Note is : 2430055 - How to setup 3rd party/CA signed SSL with ASE and SDK - SAP ASE
-
Hi PetrK the only code in asemon_logger managing SSL is this if (useSSL) { if (verbose) Asemon_logger.printmess ("SSL is activated"); props.put("ENABLE_SSL","TRUE"); } So asemon set the connection property "ENABLE_SSL" and does nothing else Do you get the message "SSL is activated" in the outpout messages when starting asemon_logger ? (verbose is set to true for first connection) For jConnect SSL connection configuration you should refer to SAP jConnect documentation or SAP support site I have no...
-
Anonymous posted a comment on ticket #26
Thanks a lot for the tips, I tried and it didn't help. Still: ERROR connectSRV (1). Srv=AKKK1 State= JZ00L Err= 0 Msg=JZ00L: Login failed. Examine SQLWarnings concatenated to this exception for reason(s). Yes, the certificate for ASE should be a server certificate, i.e. AKKK1 (without private.cz), But our CA doesn't know how to do server certificates, it only knows url certificates. I tried them and they work everywhere (isql, InteractiveSQL, ASEISQL, DBeaver...). (SSL_TRUST_ALL_CERTS should be enabled...
-
By the way, I think the CN must be the name of the ASE server, AKKK1 in your case (without private.cz) Did my tests this way in the past Best regards JP
-
Yes your certificate must be in the keystore (added with "keytool -import ... ) Import the public certificate into the keystore with the alias 'akkk1.private.cz' since it seems you generated the certificate with this alias Before starting asemon_logger define these two variables : export SSLTRUSTSTORE=/dba/sybase/ase/16.0.0.0.28334/jConnect-16_0/truststore export SSLTRUSTSTOREPWD=paswword_of_your_trustore Didn't test this recently, but it worked in the past Best regards JP
-
Anonymous posted a comment on ticket #26
Hi JPM This is my first attempt with SSL on asemon_logger. Without SSL it works normally (port 5000). Hmmm, and it works (NoSSL - on port 5000) even if in config_akkk1.xml "<usessl> YES </usessl>" ...?? Above in the Ticket there is a note in the log from "Hardeep" "SSL is activated". He never wrote it to me. I'm going to be a little crazy.... As if SSL was not activated, and therefore it did not load the CA certificates...?? I don't know. The second possibility is that I have the wrong certificate...
-
Hi PetrK I have no idea also What did you change ? Did it works before with same ASE version (V16.0.04.7) without SSL ? Did you tried the lastest jConnect (V16.1 SP00 PL01 HF1 ) ? Best regards JP
-
Anonymous posted a comment on ticket #26
Hi JPM I have a similar problem, asemon_logger doesn't want to connect to ASE via SSL. I think I've tried everything. I've already imported and copied the CA certificates everywhere. I'm out of ideas, can you think of anything? --log 2026/02/12 12:04:37.276 main - Java version used = 21.0.8 2026/02/12 12:04:37.306 main - Start Asemon_logger V3.2.5 2026/02/12 12:04:37.306 main - Current directory is : /home/sybase/svc/asemon_logger 2026/02/12 12:04:37.306 main - Java version : 21.0.8 2026/02/12 12:04:37.307...
-
asemon what is new
-
asemon updated /ChangeLog.txt
-
-
Hi Elovelo all procs are in your_asemon_logger_home/proc Asemon_logger automatically loads procs at startup ONLY IF version of archive ASE is greater or equal to the version of the proc (this is because procs could not compile in a lower ASE version) You can try to create them manually in asemon database and see if it generates errors (some procs need some temporary tables created before. Source of these temp tables are also in proc directory) PDO procs are only necessary if your asemon_reports uses...
-
elovelo posted a comment on discussion Help
Hello J.P. the proc 'sp_sysmon_appmgmt_V16SP3' indeed is missing. Can you share its code, please ? As for the archive/monitored server versions. I got the blank output for parallel query management also for monitored servers that are in the same version as the archive version. The only difference is the line about used procedures: Sampling Started at : Dec 9 2025 11:56PM Sampling Ended at : Dec 10 2025 11:27AM Sample Interval : 41466 s Nb transactions : 2327036 Counters Last Cleared : ASE days running...
-
Hi Elovelo, can you verify that the proc "sp_sysmon_appmgmt_V16SP3" exists in your asemon archive database Non existance of this proc leads asemon_report to choose "Local sp_sysmon procs" If it exists , I don't understand why local procs are used By the way, I never did test using a archive server at a lower version than the monitored servers JP
-
asemon what is new
-
asemon what is new
-
-
-
Hello J.P. To be clear, my archive server runs on 16.0 SP02 PL07 part of my monitored servers are also in 16.0 SP02 PL07 and part of them are in 16.0 SP04 PL06 HF1. The server that I am interested in checking its Parallel Query Management is of 16.0 SP04 PL06 HF1. The query select top 1 ASE_Version from xxx_SysMonFl2 where Timestamp= (select max(Timestamp) from xxx_SysMonFl2) corresponds with the server version. Indeed the SysMon.xml and SysMonFld.xml collectors were disabled. I enabled them and...
-
Hello J.P. To be clear, my archive server runs on 16.0 SP02 PL07 part of my monitored servers are also in 16.0 SP02 PL07 and part of them are in 16.0 SP04 PL06 HF1. The server that I am interested in checking its Parallel Query Management is of 16.0 SP04 PL06 HF1. The query select top 1 ASE_Version from xxx_SysMonFl2 where Timestamp= (select max(Timestamp) from xxx_SysMonFl2) corresponds with the server version. Indeed the SysMon.xml and SysMonFld.xml collectors were disabled. I enabled them and...
-
are you sure that these two collectors are activated for your V16SP02PL07 servers ? <md> SysMon.xml </md> <md> SysMonFld.xml </md>
-
Are you sure, because this is not the version of a V16 SP02 PL07 server This is the version of your ASE hosting the archive database
-
Hello JP, the result is '16.0.04.06' I ran the query against all the rest of XXXXX_SysMonFI2 tables and the results correspond with the version of the monitored ASE.
-
Hi, can you give me the result of this query : select top 1 ASE_Version from XXXXXXX_SysMonFl2 where Timestamp = (select max(Timestamp) from XXXXXXX_SysMonFl2) Replace XXXXXXX by the name of your V16SP02 monitored server JP
-
Hello J.P. I run Asemon v3.2.3 on SAP ASE 16.0 SP02 PL07 I want to view the 'parallel' section of Sysmon for ASE in that is in version 16.0 SP04 PL06 HF1, but it in empty (see attached ss). I searched for any relevant collector in the <ase_name>.xml file that maybe needs to be enabled, but I did not find anything. It's the same for other ASE instances and in different versions that I monitor.</ase_name> I noticed that for monitored ASE 16.0 SP04 PL06 HF1 the 'procedures used' is 'sp_sysmon_xxx_V16'...
-
asemon what is new
-
-
-
-
-
-
Anonymous created ticket #22
Update PHO Version to 8.4
-
ok, JP. thank you, I will give ot a try with shorter deleteSleep
-
no, sorry, I didn't create a parameter for that Anyway with deletesleep=1 the purge should be considerably faster
-
Thank you. And I suppose there is no way to increase the packet size of these 1000 rows?
-
Hi elovelo, you can change the parameter deleteSleep and set it to "1" rather than "100" It 'll wait 1 ms between each delete packet of 1000 rows Restart asemon_logger to make this change effective Regards Jpm
-
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...
-
I see you had an error purging the OpObjAct. This purge is very basic : delete ?SERVERNAME?_OpObjAct where Timestamp < ?DATE? may be this table is corrupted. Check it
-
I didn't see you get error in the purge thread Do a delete of all rows in xxx_TrendsCfg table and restart asemon_logger Tell me if you still have error during next purge
-
Hi elovelo, these tables are never purged : AseParams SysMonFld2 TrendProc Trends TrendStmt WClassInf WEvInf They are not big tables and keeping this info is interesting Some tables keeps data if depending data still exists in other table (for exemple StmtPlan, StmObj, StmtPlnHK and StmtSQLHK depend on StmtStat) If you suspect any problem with the purge process , you can start asemon_logger with debug flag 113 (asemon_logger .... -d 113) and see all statements executed by purge thread Regards Jp...
-
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...
-
Piers Collins posted a comment on discussion Help
Hi, ignore this.. I managed to get it to start collecting. It was a latency issue with the collectors returning results. Regards Piers
-
Hi JP, we have several IQ 16.1 instances under asemon. However one of them I'm having issues getting all of the required statistical information. For example these are not being populated server1_AmStats server1_IQCnx server1_IQMPXInfo server1_IQSQL server1_IQStatus server1_IQSysmon1 server1_IQSysmon2 server1_IQSysmon3 server1_IQTblSize But these are server1_IQCtx server1_IQDbSpace server1_IQIdxUse server1_IQTblUse server1_IQXacts I see no errors in the logs explaining why and the logger has full...
-
Hi JP, we have several IQ 16.1 instances under asemon. However one of them I'm having issues getting all of the required statistical information. For example these are not being populated **server1_AmStats server1_IQCnx server1_IQMPXInfo server1_IQSQL server1_IQStatus server1_IQSysmon1 server1_IQSysmon2 server1_IQSysmon3 server1_IQTblSize ** But these are **server1_IQCtx server1_IQDbSpace server1_IQIdxUse server1_IQTblUse server1_IQXacts ** I see no errors in the logs explaining why and the logger...
-
Hi Albin if you do not want install V16.1 for asemon repository, then, you can manually create the sysmon_xxx_PDO_V161 procs in the asemon database I think I remember that there are not a lot of differences with V16SP3 Regards JP
-
Albin Rosberg posted a comment on discussion Help
Hi Jean-Paul, Sorry for the delay. Yes, we have sysmon_xxx_PDO_V161 procs under asemon/asemon_logger_V3.2.5/proc/ at the server where asemon_logger installed. Our ASE used for asemon database however is version V16.04.06 version We do not have any issue to get a Sysmon Statistics for ASE V16.0. We can see:” Archive server ASE version : Adaptive Server Enterprise/16.0 SP04 PL06 HF1/EBF 31044 SMP/P/x86_64/SLES 12.4/ase160sp04pl06x/3636/64-bit/FBO/Thu Jun 27 20:17:29 2024 Procedures used : sp_sysmon_xxx_PDO_V16SP3”...
-
Hi Albin, new sysmon_xxx_PDO_V161 exist in asemon/proc Asemon_logger should have created then at startup. Do you have any trace ? Is your ASE used for your asemon database also at V16.1 version ? Else, you can create the sysmon_xxx_PDO_V161 procs manually but you may encounter problems since these procs are for V16.1 version Regards JPM
-
Hi We recently replaced the asemon report server to a V3.2.5. We have upgraded from asemon_logger_V3.1.9 to asemon_logger_V3.2.5 as well. At the same time we have upgraded the ASE instance from 16.0 SP4 PL06 to 16.1 SP00 PL00 (in-place upgrade) We have got some issue to get a Sysmon Statistics for ASE 16.1. It has given as error: Module: refresh_Sysmon_data with Message: Procedures: sp_sysmon_XXX_PDO_V161 missing in asemon database. It seems like we have missed something. Any insights?
-
Hello Jean-Paul, This part : If selinux is activated : 1) authorize httpd to acces to Sybase files and asemon_report : chcon -t httpd_sys_rw_content_t /your_sybase_home_dir/ -R chcon -t httpd_sys_rw_content_t /var/www/html/asemon_report/ -R or (on RedHat 9) : (check SELinux alerts with : sealert -l "*" and apply recommended actions) For example : semanage fcontext -a -t httpd_sys_content_t "/your_asemon_report_dir/.*)?"` restorecon -R -v /your_asemon_report_dir 2) authorize httpd to use sockets :...
-
Hello Jean-Paul, This part : If selinux is activated : 1) authorize httpd to acces to Sybase files and asemon_report : chcon -t httpd_sys_rw_content_t /your_sybase_home_dir/ -R chcon -t httpd_sys_rw_content_t /var/www/html/asemon_report/ -R or (on RedHat 9) : (check SELinux alerts with : sealert -l "*" and apply recommended actions) For example : semanage fcontext -a -t httpd_sys_content_t "/your_asemon_report_dir/.*)?"` restorecon -R -v /your_asemon_report_dir 2) authorize httpd to use sockets :...
-
Hi Catherine ???? I don't understand your question JP
-
Hello Jean-Paul, Can you please explain how to configure (especially path to Sybase Client and asemon report) on Redhat9 when SE Linux is not enabled ? Best Regards, Catherine
-
Thank you very much, it solved the issue!
-
Hi, very strange try deleting all rows in ASE1_TrendsCfg Asemon will repopulate this table during the next purge with V3.2.5 data config Hope this will solve your pb Regards JP
-
Hi We just changed a couple of things in our setup. 1) we replaced the asemon report server to a new server and bcp:d over the old data 2) we changed the ASE instance name; e.g. MonitoredSrv.name from ASE1NEW to ASE1 3) we have upgraded from asemon_logger_V3.1.9 to asemon_logger_V3.2.5 when starting up, data is being sent correctly and things seem to be working; except purge which oddly enough still shows the old name somehow. Is there any data we have missed to update? 2025/07/29 14:36:25.124 Purge...
-
Hello Jean-Paul, The server name in the /etc/odbc.ini was incorrect. my bad ! Best Regards, Catherine
-
Hello Catherine I also had a lot of problems to setup odbc connection Did you configured your ODBC dSybase driver and DSN as specified in the Sybase doc ? To summaries, do for example : cd /home/sybase/SDK16SP04PL04/DataAccess64/ODBC/sample cp drivertemplate.txt mydrivertemplate.txt cat mydrivertemplate.txt : [Adaptive Server Enterprise] Description = Sybase ODBC Driver Driver = /home/sybase/SDK16SP04PL04/DataAccess64/ODBC/lib/libsybdrvodb.so FileUsage = -1 odbcinst -i -d -f mydrivertemplate.txt...
-
Hello Jean-Paul, Selinus is not enabled and odbc isql does not work either initiated by root... [08001][unixODBC][SAP][ASE ODBC Driver]Client unable to establish a connection [ISQL]ERROR: Could not SQLConnect Best Regards, Catherine
-
Hello Catherine did you allow httpd access to ports ? Example of commands I had to execute : ausearch -c 'httpd' --raw | audit2allow -M my-httpd semodule -i my-httpd.pp As root (not sybase), can you establish a connection with the "isql" included with the unixodbc package (in /usr/bin) ? Best regards JP
-
Hello Jean-Paul, At linux side it is not clear what they did with SElinux. But I now get this message. [08001][unixODBC][SAP][ASE ODBC Driver]Client unable to establish a connection [ISQL]ERROR: Could not SQLConnect Sybase isql connection works well. Best Reagards, Catherine
-
Hello Catherine is SE LInux active ??? I had this problem and had to grant SE rights to the Syb libraries and directories above Or it may be just a pb on rights on directories accessing the Syb libs (I also had that in the past) By the way : don't forget to add **"UseCursor=0" ** in your ODBC DSN, else your asemon_report grids will not be populated Hope this will help you setup asemon Best regards JP
-
Hello, While trying to install asemon report 3.2.5, I receive the following message when trying to connect to the archive server with Unix odbc (though the library exist): $ /usr/bin/isql ALT14011 sa XXXXXX -v [01000][unixODBC][Driver Manager]Can't open lib '/slucfrnxsgb9128/sybase/ASE161SP00PL00/DataAccess64/ODBC/lib/libsybdrvodb.so' : file not found [ISQL]ERROR: Could not SQLConnect $ ls -lah /slucfrnxsgb9128/sybase/ASE161SP00PL00/DataAccess64/ODBC/lib/libsybdrvodb.so -rwxrwxrwx. 1 sybase dba 3.6M...
-
Hello, While trying to install asemon report 3.2.5, I receive the following message when trying to connect to the archive server with Unix odbc (though the library exist): $ /usr/bin/isql ALT14011 sa rEj5_QbdwEaF -v [01000][unixODBC][Driver Manager]Can't open lib '/slucfrnxsgb9128/sybase/ASE161SP00PL00/DataAccess64/ODBC/lib/libsybdrvodb.so' : file not found [ISQL]ERROR: Could not SQLConnect $ ls -lah /slucfrnxsgb9128/sybase/ASE161SP00PL00/DataAccess64/ODBC/lib/libsybdrvodb.so -rwxrwxrwx. 1 sybase...
-
JHC posted a comment on discussion Help
awesome : many thanks !
-
Hi Jeremy, Apache has a "TimeOut" parameter set to 60 s by default. You can increase it. By default Asemon set the PHP "max_execution_time" param to 3600s by executing the : set_time_limit(3600); instruction. You can also increase the PHP param "post_max_size" It is set to 8 M by default. You can increase it to 32 M or 0 to disable the limit. Hope this will solve your problems Regards JP
-
Just wanted to confirm that i now have this working in podman container using php 8.4. Happy to share Dockerfile if this is of interest. Only thing i have noticed is that i sometimes get Gateway Timeout (EG when looking at 'Process' for a large range. I also get a '413 : request entity too large' error when trying to export a smaller sample of 'Process' to XLS . Are there any configuration parameters that i can change to try and get this working?
-
going to upgrade container to php 8 and will let you know how i get on :) Mamy thanks
-
Think you are right : just created new container and ran php in foreground [Wed Jul 9 14:48:31 2025] PHP Warning: odbc_exec(): SQL error: [FreeTDS][SQL Server]Invalid cursor state, SQL state 24000 in SQLExecDirect in /var/www/html/COMMON/connectArchiveServer.php on line 239 [Wed Jul 9 14:48:31 2025] PHP Warning: odbc_exec(): SQL error: [FreeTDS][SQL Server]Invalid cursor state, SQL state 24000 in SQLExecDirect in /var/www/html/COMMON/connectArchiveServer.php on line 239 [Wed Jul 9 14:48:31 2025]...
-
Sorry, UseCursor must be 0 !!! I did many tests in the past, and only 0 allow refresh of grids
-
How did you configure your ODBC DSN ? You must add : UseCursor=1
-
By the way, you should install PHP 8. I didn't test Asemon with PHP 7. Errors should appear in Apache log. Don't you have this file /var/log/httpd/error_log ?
-
I think the associated log is actually below and can see nothing of note Wed Jul 9 08:25:38 UTC 2025 ps -fe | grep php root 8 1 0 Jul08 ? 00:00:01 php-fpm: master process (/etc/php/7.4/fpm/php-fpm.conf) www-data 531 8 0 07:52 ? 00:00:00 php-fpm: pool www www-data 532 8 0 07:54 ? 00:00:00 php-fpm: pool www www-data 533 8 0 08:04 ? 00:00:00 php-fpm: pool www grep error_log /etc/php/7.4/fpm/php-fpm.conf error_log = /var/log/php7.4-fpm.log cat php7.4-fpm.log [08-Jul-2025 13:26:32] NOTICE: fpm is running,...
-
Hi Jeremy, can you check if you have any error message in Apache (/var/log/httpd/error_log) ? Regards JP
-
Hi I have installed ASEmon v3.2.5 and have collectors running against 2 ASEs. I can see that the tables have been created in the repository database and that MDA data is getting inserted. When i try to login via the Report, also v3.2.5 It connects and i can see the list of databases on the repository ASE. I can also see the 'ALLDBs' section populated. However, the registered servers are not listed in the dropdown box on the top bar, or visible in the 'Stat Servers' section. I am running the PHP report...
-
Hi Onkar I think it is due to some fields not reset to blank OR because there are two sections <SrvDescriptors>where ASEV15 is defined twice Find attached a corrected config file Regards JPM
-
Onkar posted a comment on discussion Help
I am in the stage of installing asemon_logger on sybase server. However I am getting below error while setting and starting asemon logger on solaris. Setting java_home doesn't working --> set JAVA_HOME=... %ASEMON_LOGGER_HOME%\asemon_logger..sh -c ''conf/your_config_file''.xml export JAVA_HOME=...$ASEMON_LOGGER_HOME/asemon_logger.sh -c "conf/BETAUAT1".xml -bash: export: `-c': not a valid identifier asemon_logger.sh -c BETAUAT1.conf throwing below error --> -bash-5.2$ asemon_logger.sh -c /syb16/asemon/asemon_logger_V3.2.5/conf/BETAUAT1.xml...
-
Hi, you have to manually drop corresponding tables in asemon database Regard Jpm
-
Anonymous created ticket #51
remove old servers from monitored list
-
Hi, can you run this displayed SQL manually under isql and see if you get more info I have never seen this type of error Regards JP
-
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 ?
-
Hi Mark, Cnx contains info about connections. A connection is identifyed by its SPID, KPID and Loggedindatetime. It contains the UserName, program_name, DBName, ipaddr, ... It is captured only one time, just when asemon see it the first time CnxActiv contains activity for the connections : CPUTime, LogicalReads, PhysicalReads, ... Asemon checks activity of connections every 30 s (by default) and inserts a row in CnxActiv table only if the connection did some work during this interval of 30 s (so,...
-
Mark Bersales modified a comment on discussion Open Discussion
Hi, I would just like to ask what is the difference between the <server>__Cnx table and the <server>__CnxActiv table. Reason being is that i noticed that the <server>__Cnx table contains entries that are not in the <server>__CnxActiv for a specific Loggedindatetime range. What instance does this occur usually? Does that mean mean that the user was only able to connect but did not perform any transactions during the time interval? Could it also be that the process has already completed before the...
-
Hi, I would just like to ask what is the difference between the <server>__Cnx table and the <server>__CnxActiv table. Reason being is that i noticed that the <server>__Cnx table contains entries that are not in the <server>__CnxActiv for a specific Loggedindatetime range. What instance does this occur usually? Does that mean mean that the user was only able to connect but did not perform any transactions during the time interval?</server></server></server></server> Regards, Mark
-
asemon what is new
