A script to check the health of SAP Adaptive Server Enterprise (Sybase ASE) server for Nagios.
The script has been published on GitHub. If is free to use – released under GPL v.3 license.
This is just a basic script that does most important checks. It should work with all versions of ASE: 12.5, 15.0, 15.5, 15.7 and 16.0. I have not tested in on ASE CE (Cluster Edition).
Script performs the following checks:
- the server is up
- no blocked processes (default threshold is 300 seconds)
- no long running transactions (default threshold is 300 seconds)
- log segment is not full in all databasess
- free space in data segment for all databasess
Usage:
./check_sybase_ase.sh -S server -U login [-P password] [-C character set] [-X path_to_sybase_installation]
The script requires a local installation of Open Client ($SYBASE path and isql binary).
If you have any issues please send me feedback.
Hi, We try to implement your script but I’m not able to connect to ASE Server. I try to check che connection via isql command line but the result is the same