SAM - Informix DB monitoring

Version 1

    We have setup the Informix database monitoring on SAM, processes are as below.

     

      nstall Informix ODBC on SAM server

      Install IBM Informix Client-SDK 64bit 32bit, clientsdk.4.10.FC4DE.WIN 

    Configure and test Database ODBC Connection

     

    • Create the Procedures in the database SYSMASTER

     

    Ask Solarwind send the following Procedure scripts

     

    apm_connect;  

     

    apm_deadl;    

     

    apm_l_req;    

     

    apm_l_wait;   

     

    apm_latch_wait;

     

    apm_p_reads;  

     

    apm_p_writes; 

     

    apm_seq_s;    

     

    apm_sorts;    

     

    apm_tr_com;   

     

    apm_tr_rol;   

     

    • Create a template using the IBM Informix Template

      Open the template ->Update each component 

    Change the Credential for Database

     

    Change the connection string to match your DB service definition

     

    • Assign the Template to Node