Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.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 126.96.36.199
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.