[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    Re: how do I retrieve log area usage levels from system info tables?
From:       Adam Wendt <adam () ipwebdev ! com>
Date:       2004-09-29 2:05:16
Message-ID: 415A185C.4070304 () ipwebdev ! com
[Download RAW message or body]

SELECT PCTUSEDLOG,LOGSIZE,USEDLOG FROM SERVERDBSTATISTICS

Adam Wendt
IPCoast, Inc.

Michael Hennessy wrote:

>hi all,
>
>Is it possible to retrieve information on the current usage level of the log
>volumes from the system info tables?
>
>I know I can find the data volume usage using:
>
>"select usedsizepercentage from datastatistics"
>
>. but I cant seem to find any corresponding information for the log volumes,
>although the Free Log Area and Used Log Area etc can be displayed in the DB
>Manager.
>
>Any thoughts or tips?
>
>regards,
>
>Michael Hennessy
>----------------------------------------------------------------------------
>------
>Excalibur Engineering Pty. Ltd.
>
>Mobile Phone No : (+61) 0411 789392
>Office Phone No. : (+61) 0249 400133
>Office Fax     No. : (+61) 0249 400266
>Email  Address    : hennessy@excalibureng.com
>Postal Address    : PO Box 1088 Newcastle NSW 2300, Australia
>Street Address    : 80 Chin Chen Street, Islington
>                              Newcastle, 2296, Australia
>----------------------------------------------------------------------------
>------
>Public Key available at http://www.keyserver.net:
>Key ID: 688697D4
>Key fingerprint = F80C 144C CB9F 42D9 01BD  8BCA A944 AC74 6886 97D4
>----------------------------------------------------------------------------
>------
>
>
>
>
>  
>


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]