13.5. Monitoring Database Link Activity

13.5. Monitoring Database Link Activity

It is possible to monitor the activity of database links from the command line using the ldapsearch command-line utility to return the monitoring attributes that are required. The monitoring attributes are stored in the cn=monitor,cn=database_link_name, cn=chaining database,cn=plugins,cn=config.

For example, the ldapsearch[16] command-line utility can be used to retrieve the number of add operations received by a particular database link. For example, this command monitors a database link called DBLink1: 

ldapsearch -h directory.example.com -p 389 -D "cn=Directory Manager" -w password -s sub -b 
     "cn=monitor,cn=DBLink1,cn=chaining database,cn=plugins,cn=config" "(objectclass=*)" nsAddCount

Table 13.12, “Database Link Monitoring Attributes” lists the database link monitoring attributes which can be monitored.

Attribute Name Description
nsAddCount The number of add operations received.
nsDeleteCount The number of delete operations received.
nsModifyCount The number of modify operations received.
nsRenameCount The number of rename operations received.
nsSearchBaseCount The number of base-level searches received.
nsSearchOneLevelCount The number of one-level searches received.
nsSearchSubtreeCount The number of subtree searches received.
nsAbandonCount The number of abandon operations received.
nsBindCount The number of bind request received.
nsUnbindCount The number of unbinds received.
nsCompareCount The number of compare operations received.
nsOperationConnectionCount The number of open connections for normal operations.
nsBindConnectionCount The number of open connections for bind operations.
Table 13.12. Database Link Monitoring Attributes

For more information about ldapsearch, see the Directory Server Configuration, Command, and File Reference.


Note: This documentation is provided {and copyrighted} by Red Hat®, Inc. and is released via the Open Publication License. The copyright holder has added the further requirement that Distribution of substantively modified versions of this document is prohibited without the explicit permission of the copyright holder. The CentOS project redistributes these original works (in their unmodified form) as a reference for CentOS-5 because CentOS-5 is built from publicly available, open source SRPMS. The documentation is unmodified to be compliant with upstream distribution policy. Neither CentOS-5 nor the CentOS Project are in any way affiliated with or sponsored by Red Hat®, Inc.