OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
How to check log devspace fill level

From: Bhalu Zute (bzuteoddpost.com)
Date: Thu Apr 22 2004 - 15:07:50 CDT

I have SAPDB 7.4.2.25
  
Since autolog backup to external backup tools (ADINT2 + TSM) does not exist, I would like to implement my own via shell scripts. I would like to write a shell script that runs every 5 minutes, logs on to SAPDB, checks log fill level, and fires off a log backup (to external tool) if fill level exceeds say 50%
  
How can I retrive information on the log area via a DBMcli command? I would like to retrive "used size %", "not saved %" etc., as shown in DBMGui. An sample SQL statement would be appreciated. Which tables,etc. would I need to query?
  
Thanks in advance.
  
Bhalu Zute