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.


Locations of visitors to this page
   
  powered by myself. DBA-Sybase 2006