Thanks. In my case the exact command needed was dbmcli -d <database> -u <user>,<password> -uSQL <user>,<password> info log I stumbled upon -uSQL by trial/error in trying to make your suggestion work. I am not sure why I had to specify it but you did not have to. Bhalu Zute -----Original Message from John L. Singleton <[EMAIL PROTECTED]>----- Bhalu,
This dbmcli command should give you all of the information you want. # dbmcli -d <database> -u <dbmuser>,<dbmpass> info log Cheers, JLS Bhalu Zute wrote: >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 > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
