Case study 7: Space left on segments - Sybase free space
Platform: HP-UNIX 11, Tru64 , Windows
Sybase ASE version: 12.5.x
Background story: During history database development, we encountered that, from time to time, we run out of free space on segments, and some of software which works 24h/day and make changes in historical database stop working
Task: Make a script which will be executed once a day and warns a DBA if free space on segments goes below some value.
Solution: I've found this script on internet, on this site, and I reuse it for my task. The core of the code is given in this file. It returns segments name, total size of segments(in MB), free space on segments(in MB) and free space percentage.
This script is further used in CRON job and in case that free space percentage drops below 10%, CRON job sends an e-mail to DBA.