Menu

Home

Jean-Paul Martin

Welcome to Asemon documentation.

What is Asemon

Asemon is a tool for monitoring Sybase servers : ASE , RS , IQ, RAO

Two parts in asemon :

asemon_logger : the "agent" part, written in Java, which periodically collects counters from a "monitored server", and archive them in an "archive database" (currently this "archive database" must be a Sybase ASE database)

asemon_report : the "query" and "reporting" part. Set of PHP pages, which can be installed in a Web Server. With these pages, you can query the "archive database" in order to analyse the data captured by asemon_logger.

Here are the known restrictions when using asemon on production servers [Asemon restrictions].

Detail of asemon relases : see [asemon what is new]

Installation

First, you have to install asemon_logger on a serveur (Windows or Unix)

See [Asemon logger installation] for details.

Second, install asemon_report (PHP pages in a web server).

See [Asemon report installation] for details.

Asemon Report Documentation

See [Asemon_report documentation].


Related

Wiki: Asemon logger installation
Wiki: Asemon report installation
Wiki: Asemon restrictions
Wiki: Asemon_report documentation
Wiki: asemon what is new

Discussion

  • Bhupendra Sharma

    Hi Team ,

    I am installing asemon first time on Linux ASE 16.0 , could you please help me or share the sample for Sampleconfig.xml file .

    Regards,
    Bhupendra Sharma
    +44-7404361486

     
  • Jean-Paul Martin

    Hi,
    here is a sample config file where MYARCHIVESRV is the ASE server hosting the asemon repository database
    and TESTSRV is the monitored ASE server
    "sa" is used on both servers for connection.
    Don't forget to update the "passwords" file in directory from which you start asemon_logger.
    Look at https://sourceforge.net/p/asemon/wiki/Asemon%20logger%20installation/ fro details

    <?xml version="1.0" encoding="UTF-8"?>
    <Config>
      <asemon>
          <admin_port> </admin_port>  <!-- admin_port is not mandatory. If defined, it allows to connect to asemon with isql -->
          <name>  </name>              <!-- asemon_logger name is mandatory only if admin_port is defined. Used to save the sa password of asemon_logger in passwords file -->
          <options>
            <!--
            <traceflag> skipRetreiveSQLText       </traceflag>
            <traceflag> disableBulkLoad           </traceflag>
            <traceflag> skipRetreivePlan          </traceflag>
            <traceflag> enableJNDI                </traceflag>
            <traceflag> disableENCPASS            </traceflag>
            <traceflag> skipSAProcs               </traceflag>
            <traceflag> skipRetreiveProcessObject </traceflag>
            <traceflag> traceCounterOverflow      </traceflag>
            <traceflag> ArchiveSQLHK </traceflag>
            <traceflag> skipArchiveSQL </traceflag>
          -->
          </options>
      </asemon>
    
      <ArchiveSrv>
          <name> MYARCHIVESRV </name>
          <type> ASE </type>
          <user> sa </user>
          <useKerberos> no </useKerberos>
          <database> asemon </database>
          <charset>  </charset>
          <GranteeList>  </GranteeList>
          <poolsize> 1 </poolsize>
          <packet_size> </packet_size> <!-- not mandatory. If defined, overrides default network packet size of the archive server -->
      </ArchiveSrv>
    
      <MonitoredSrv>
          <SRV>
              <name> TESTSRV </name>
              <user> sa </user>
              <charset> </charset>
              <srvDescriptor> ASE </srvDescriptor>
              <purgearchive daysToKeep="30"  deleteSleep="100" startDelay="1"/>
          </SRV>
      </MonitoredSrv>
    
    
      <SrvDescriptors>
    
          <SD>
              <name> ASE </name>
              <type checkMonitoringConfig="yes"> ASE </type>
              <version> 1 </version>
              <metricsDescriptorsFiles >                 
                 <md> AmStats.xml                                    </md>
                 <md> AseDbSpce_switch.xml                           </md>
                 <md> BlockedP_switch.xml                            </md>
    
    <!-- be carefull in prod before 15.7 -->
                 <md> CachedObj_switch.xml                           </md>
    <!-- -->
    
                 <md> CachedPrc_switch.xml                           </md>
                 <md min_usecount="1"> CachedSQL_switch.xml                           </md>
                 <md min_usecount="1"> CachedSTM_switch.xml                           </md>
                 <md> CachedXML_switch.xml                           </md>
                 <md> CachePool_switch.xml                           </md>
    
    <!-- V16, experimental, needs sybsecurity and audit config. changes
                 <md> ChEvents_switch.xml                            </md>
    -->
    
                 <md> Cnx.xml                                        </md>
                 <md> CnxActiv_switch.xml                            </md>
                 <md> CnxWaits.xml                                   </md>
    
    <!-- don't use this collector on production servers before 15.7SP130, V16 PL???. It can crash the server. 
                 <md> Compress_switch.xml                            </md>
    -->
    
                 <md> DataCache.xml                                  </md>
                 <md> DeadLock_switch.xml                            </md>
                 <md> DevIO_switch.xml                               </md>
                 <md> Engines_switch.xml                             </md>
                 <md> ErrLog_switch.xml                              </md>
                 <md HOUR_EXEC="12" minpages="10"> Fragment_switch.xml </md>
    
    <!-- don't use LockWaits with ASE V15.7. Seen lots of spinlock contention on rdesmgr_spin. -->
                 <md> LockWaits.xml                                  </md>
    <!-- -->
    
                 <md> LogsHold_switch.xml                            </md>
    
    <!-- don't use in prod, can fill master -->
                 <md HOUR_EXEC="17"> MissStats_switch.xml                           </md>
    <!-- -->
    
                 <md> MemUsage_switch.xml                                    </md>
                 <md> MonConf.xml                                    </md>
                 <md min_logical_reads="10000"> MonSQL_switch.xml                              </md>
                 <md> MonState_switch.xml                            </md>
                 <md> NetworkIO.xml                                  </md>
                 <md> OpenDbs.xml                                    </md>
                 <md> OpObjAct_switch.xml                            </md>
                 <md> PModUse_switch.xml                             </md>
                 <md> ProcCache.xml                                  </md>
                 <md delay="30"> ProcMem.xml                                  </md>
    <!--
                 <md delay="30"> QPMetrics_switch.xml                                  </md>
                 <md delay="30"> QPMSQL_switch.xml                                  </md>
    -->
                 <md> StmtCache_switch.xml                           </md>
                 <md> SysCaches.xml                                  </md>
                 <md> SysConf.xml                                    </md>
                 <md> SysDev_switch.xml                              </md>
    
    <!-- experimental -->
                 <md> SysExec_switch.xml                             </md>
    <!-- -->
    
                 <md> SysMon.xml                                     </md>
                 <md> SysMonFld.xml                                  </md>
    
    <!-- next six collectors are used by the new kernel sysmon section. Don't activate them if you don't use this new sysmon section -->
                 <md> SysEngThr_switch.xml                           </md>
                 <md> SysThread_switch.xml                           </md>
                 <md> IOControl_switch.xml                           </md>
                 <md> WorkQueue_switch.xml                           </md>
                 <md> ThreaPool_switch.xml                           </md>
                 <md> SysLoad_switch.xml                             </md>
                 <md> BuckPool_switch.xml                            </md>
                 <md> SysNVCach_switch.xml                           </md>
    <!-- -->
                 <md> SysWaits.xml                                   </md>
                 <md> Trends.xml                                     </md>
                 <md> WClassInf.xml                                  </md>
                 <md> WEvInf.xml                                     </md>
            </metricsDescriptorsFiles>
          </SD>
      </SrvDescriptors>
    
    </Config>
    
     
  • Bhupendra Sharma

    Thansk Paul , for Replying

    I am getting below error while installing asemon_logger
    Please suggest if any value need to set in between
    <srvdescriptors>
    .
    .
    </srvdescriptors>

    Error -
    cailstceccdb1 asemon/asemon_logger_V3.1.3% ./asemon_logger.sh -c SR0config_file.xml
    2020/02/15 23:41:06.761 main - Start Asemon_logger V3.1.3a
    2020/02/15 23:41:06.785 main - Current directory is : /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3
    2020/02/15 23:41:06.785 main - Java version : 1.7.0
    2020/02/15 23:41:06.787 main - Classpath is : /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/dist/Asemon_logger_V3.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/jdom.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/xerces.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/java-getopt-1.0.9.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/jConnect-16_0/classes/jconn4.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/jConnect-16_0/classes/jTDS3.jar
    2020/02/15 23:41:06.787 main - Config file used : SR0config_file.xml
    2020/02/15 23:41:07.680 main - textsize for retreiving text (XML documents) for 'SR0': 65536
    2020/02/15 23:41:07.681 main - validateConfig : (SR0config_file.xml) : not all monitored servers have a corresponding srvDescriptor
    cailstceccdb1 asemon/asemon_logger_V3.1.3%

    Regards,
    Bhupendra Sharma
    +44-7404361486

     
  • Jean-Paul Martin

    Hi Bhupendra,
    in the section <MonitoredSrv>... </MonitoredSrv>
    you can have several "monitored server" sections <SRV>...</SRV>
    For each of them you give the name of monitored server <name> name_of_monitored_server </name>
    and you must give the reference to the subsection srvDescriptor. In case of ASE you can just use "ASE"

    Ex . :

    <MonitoredSrv>
          <SRV>
              <name> TESTSRV1 </name>
              <user> sa </user>
              <charset> </charset>
              <srvDescriptor> ASE </srvDescriptor>
              <purgearchive daysToKeep="30"  deleteSleep="100" startDelay="1"/>
          </SRV>
          <SRV>
              <name> TESTSRV2 </name>
              <user> sa </user>
              <charset> </charset>
              <srvDescriptor> ASE </srvDescriptor>
              <purgearchive daysToKeep="30"  deleteSleep="100" startDelay="1"/>
          </SRV>
          ...
      </MonitoredSrv>
    

    Best regards
    Jpm

     
  • Bhupendra Sharma

    Thanks Jpm ,

    Please help -
    I am getting below error , my ASEMON and Monitor Database both on same server . is that require any entry in interface file ?

    cailstceccdb1 asemon/asemon_logger_V3.1.3% setenv ASEMON_LOGGER_HOME /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3
    cailstceccdb1 asemon/asemon_logger_V3.1.3%
    cailstceccdb1 asemon/asemon_logger_V3.1.3% ./asemon_logger.sh -c 'SR0config_file.xml'
    2020/02/23 16:12:10.567 main - Start Asemon_logger V3.1.3a
    2020/02/23 16:12:10.591 main - Current directory is : /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3
    2020/02/23 16:12:10.591 main - Java version : 1.7.0
    2020/02/23 16:12:10.593 main - Classpath is : /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/dist/Asemon_logger_V3.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/jdom.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/xerces.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/java-getopt-1.0.9.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/jConnect-16_0/classes/jconn4.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/jConnect-16_0/classes/jTDS3.jar
    2020/02/23 16:12:10.593 main - Config file used : SR0config_file.xml
    2020/02/23 16:12:11.578 main - Try to connect to srv : ASEMON
    2020/02/23 16:12:11.579 main - connectSRV : ERROR Server ASEMON does not exists in interfaces or SQL.INI file
    java.io.FileNotFoundException: passwords (No such file or directory)
    at java.io.FileInputStream.<init>(FileInputStream.java:158)
    at java.io.FileInputStream.<init>(FileInputStream.java:113)
    at java.io.FileReader.<init>(FileReader.java:70)
    at asemon_logger.PassFileMgr.delPassword(PassFileMgr.java:268)
    at asemon_logger.Asemon_logger.main(Asemon_logger.java:538)
    2020/02/23 16:12:11.580 main - Password removed from passwords file for 'ASEMON.sa'
    cailstceccdb1 asemon/asemon_logger_V3.1.3%</init></init></init>

    Regards,
    Bhupendra Sharma
    07404361486

     
  • Jean-Paul Martin

    Hi
    of course you need an entry for your ASE server named "ASEMON" in interfaces file. Else you get the error :
    2020/02/23 16:12:11.579 main - connectSRV : ERROR Server ASEMON does not exists in interfaces or SQL.INI file
    Regards
    JPM

     
  • Bhupendra Sharma

    Hi JPM,

    I am new in ASEMON and need your support , I have trying to install ASEMON - Report in my Laptop which connect to my ASEMON-Logger and Monitoring Server but i am getting below error while running for Apche in ASEMON -Report confgiuration . Please suggest and let me know how to setup ASEMON-REport -

    C:\AsemonReportSRV>
    C:\AsemonReportSRV>startApache.bat

    C:\AsemonReportSRV>REM Use this file to manually start the Apache server

    C:\AsemonReportSRV>REM Note : start the "setup.bat" file before, if you don't have Open Client installed on your machine

    C:\AsemonReportSRV>set PATH=c:\AsemonReportSRV\sybase\OCS-16_0\bin;c:\AsemonReportSRV\sybase\OCS-16_0\dll;c:\AsemonReportSRV\sybase\OCS-16_0\lib3p;C:\Sybase\DataAccess64\ADONET\dll;C:\Sybase\DataAccess\ADONET\dll;C:\Sybase\DataAccess64\ODBC\dll;C:\Sybase\DataAccess\ODBC\dll;C:\Sybase\DataAccess64\OLEDB\dll;C:\Sybase\DataAccess\OLEDB\dll;C:\Sybase\OCS-15_0\lib3p64;C:\Sybase\OCS-15_0\lib3p;C:\Sybase\OCS-15_0\dll;C:\Sybase\OCS-15_0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Webex\Webex\Applications;C:\Users\bhupendra.sharma\AppData\Local\Microsoft\WindowsApps;;C:\AsemonReportSRV\php-5.6.40

    C:\AsemonReportSRV>"C:\AsemonReportSRV\Apache24\bin\httpd"
    (OS 10013)An attempt was made to access a socket in a way forbidden by its access permissions. : AH00072: make_sock: could not bind to address [::]:80
    (OS 10013)An attempt was made to access a socket in a way forbidden by its access permissions. : AH00072: make_sock: could not bind to address 0.0.0.0:80
    AH00451: no listening sockets available, shutting down
    AH00015: Unable to open logs

    C:\AsemonReportSRV>

    Regards,
    Bhupendra Sharma
    +44-7404361486

     
  • Jean-Paul Martin

    Hi,
    its because the port 80 is already in use on your PC
    Try another port.
    Change port number in C:\AsemonReportSRV\Apache24\conf\httpd.conf
    For example :

    #
    # Listen: Allows you to bind Apache to specific IP addresses and/or
    # ports, instead of the default. See also the <VirtualHost>
    # directive.
    #
    # Change this to Listen on specific IP addresses as shown below to 
    # prevent Apache from glomming onto all bound IP addresses.
    #
    #Listen 80
    Listen 8080
    

    and then, when you call the asemon_report page :

    localhost:8080//asemon_report/asemon_report.php

    Cheers
    Jpm

     
  • Bhupendra Sharma

    Hi JPM ,

    could you please help my attched screenshot and ASEMON Report Page is not loading .
    Please let me know if any details i m missing , All three page in same screenshot -

    Regards,
    Bhupendra Sharma
    +44-07404361486

     
  • Jean-Paul Martin

    Hi,
    I see that asemon_logger is blocked because it cannot convert a table due to option "select into/bulk copy/pll sort" not set on your asemon database.

    Apache starts without error.

    How do you invoke the asemon_report page from your browser ?

    Best regards
    Jpm

     
  • Bhupendra Sharma

    Hi JPM ,

    Is that option "select into/bulk copy/pll sort" need to set on Monitor or ASEMON Server ?
    In our Production server we have not enabled bulk option .

    Regards,
    Bhupendra Sharma
    +44-07404361486

     
  • Bhupendra Sharma

    Hi JPM ,

    I have run ASEMON Logger and process stuck , is there any error log file we can check or it is running like this and i need to run in backgrond ?

    cailstceccdb1 asemon/asemon_logger_V3.1.3% asemon_logger.sh -c SR0config_file.xml
    2020/03/10 13:49:06.925 SR0_WClassInf - Start thread.
    2020/03/10 13:49:06.930 SR0_WEvInf - Start thread.
    2020/03/10 13:49:54.222 SR0_MonSQL - MonSQL BootID = 1
    2020/03/10 13:49:54.353 SR0_MonState - Modify archive table : alter table SR0_MonState modify [SnapsExecuted] bigint null
    2020/03/10 13:49:54.368 SR0_MonState - Archive table modified
    create index idx on SR0_MonState (Timestamp, Interval )
    2020/03/10 13:50:06.931 Purge SR0 - Start thread.
    2020/03/10 13:50:06.931 Purge SR0 - Try to connect to srv : ASEMON
    2020/03/10 13:50:06.932 Purge SR0 - Srv found in interfaces or SQL.INI file. Host=cailstceccdb1 Port=4901
    2020/03/10 13:50:06.936 Purge SR0 - Using password from passwords file for 'ASEMON.sa'
    2020/03/10 13:50:06.954 Purge SR0 - Connected to archive server : ASEMON Database : ASEMON

    Regards,
    Bhupendra Sharma
    +44-7404361486

     
  • Bhupendra Sharma

    Hi JPM ,

    I am getting issue while runing ASEMON REPORT , could you please check and advise -

    C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>startApache.bat
    C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>REM Use this file to manually start the Apache s
    C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>REM Note : start the "setup.bat" file before, if
    C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>set PATH=C:\Users\bhupendra.sharma\Documents\Ase
    \dll;C:\Users\bhupendra.sharma\Documents\AsemonReportSRV\sybase\OCS-16_0\lib3p;c:\AsemonReportSRV\sy
    \AsemonReportSRV\sybase\OCS-16_0\bin;c:\AsemonReportSRV\sybase\OCS-16_0\dll;c:\AsemonReportSRV\sybas
    C:\SAP\ASE-16_0\dll;C:\SAP\ASE-16_0\bin;C:\SAP\COCKPIT-4\bin;C:\SAP\OCS-16_0\lib3p64;C:\SAP\OCS-16_0
    \Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Amazo
    11.2.0\client_1\network\BIN;C:\AsemonReportSRV\php-5.6.40;C:\AsemonReportSRV\php-5.6.40;C:\Users\bhu
    RV\php-5.6.40

    C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>"C:\Users\bhupendra.sharma\Documents\AsemonRepor
    (OS 10049)The requested address is not valid in its context. : AH00072: make_sock: could not bind t
    AH00451: no listening sockets available, shutting down
    AH00015: Unable to open logs

    C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>

    Regards,
    Bhupendra Sharma
    +44-07404361486

     
  • Bhupendra Sharma

    Hi JPM ,

    I have chnage my port 8080/8000 but stuck at below and my http://localhost:8080 not working -

    C:\AsemonReportSRV>REM Use this file to manually start the Apache server

    C:\AsemonReportSRV>REM Note : start the "setup.bat" file before, if you don't have Open Client installed on your machine

    C:\AsemonReportSRV>set PATH=C:\Sybase\DataAccess64\ADONET\dll;C:\Sybase\DataAccess\ADONET\dll;C:\Sybase\DataAccess64\ODBC\dll;C:\Sybase\DataAccess\ODBC\dll;C:\Sybase\DataAccess64\OLEDB\dll;C:\Sybase\DataAccess\OLEDB\dll;C:\Sybase\OCS-15_0\lib3p64;C:\Sybase\OCS-15_0\lib3p;C:\Sybase\OCS-15_0\dll;C:\Sybase\OCS-15_0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Users\bhupendra.sharma\AppData\Local\Microsoft\WindowsApps;;C:\AsemonReportSRV\php-5.6.40

    C:\AsemonReportSRV>"C:\AsemonReportSRV\Apache24\bin\httpd"

    Regards,
    Bhupendra Sharma
    +44-7404361486

     
  • Jean-Paul Martin

    Hi Bhupendra,
    so now when you start Apache you get no error and the command hung : this is normal because the cmd windows must stay open (there is a possibility to start apache as a windows service with the -n switch of httpd, look to Apache documentation)
    And if you try http://localhost/8080/asemon_report/asemon_report.php
    in a browser on same machine, you get nothing ?
    Regards
    Jpm

     
  • Bhupendra Sharma

    Hi Martin ,

    http://localhost:8080/Asemon_report/Asemon_report.php like is open but i am not able to connect ASEMON server and getting below error , Plaese find error in below and attched screen shot -

    localhost:8080 says

    ERROR
    Module : connectServer()
    Message :
    Cannot open connection

    Query:

    Regards,
    Bhupendra Sharma
    +44-07404361486

     
  • Bhupendra Sharma

    Hi Paul , Can you please check and update on error i m getting

    REgards,
    Bhupendra SHarma
    +44-07404361486

     
  • Jean-Paul Martin

    Hi Bhupendra,
    did you correctly setup the definition of your asemon (archive) server in "C:\AsemonReportSRV\Sybase\ini\sql.ini" ?

    Then execute :
    setup.bat
    startApache.bat

    let the cmd window open and go to you browser
    If you give a correct user and password for asemon server you defined in you sql.ini file, it should connect

    Else check if startapache has raise some error during startup

    No more idea
    Regrds
    Jpm

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.